/PF1/DB_COLLINFO - Database Table for Collector Information
Database Table for Collector Information information is stored in SAP table /PF1/DB_COLLINFO.
It is part of development package /PF1/RP_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Route Processing Persistence Layer".
It is part of development package /PF1/RP_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Route Processing Persistence Layer".
Fields for table /PF1/DB_COLLINFO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | X | /PF1/STR_BPE_COLLINFO_KEY | 0 | |||
| .INCLUDE | CA_KEY | X | /PF1/STR_BPE_CA_KEY | 0 | ||
| CLEARING_AREA | Clearing Area | X | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | /PF1/T_CLAREA |
| ROUTE_ID | Route ID | X | /PF1/DTE_BPE_ROUTE_ID | CHAR | 22 | /PF1/DB_ROUTE |
| CLEARING_ID | Clearing Agreement ID | X | /PF1/DTE_BPE_CLEARING_ID | CHAR | 22 | |
| RELEASE_STATUS | Release Status | X | /PF1/DTE_BPE_RELEASE_STATUS | CHAR | 4 | |
| .INCLUDE | /PF1/STR_BPE_COLLINFO_DATA | 0 | ||||
| DIRECTION | Payment Batch Direction | /PF1/DTE_CP_COLLECT_DIRECTION | CHAR | 2 | ||
| COLLECT_KIND | Collection Type | /PF1/DTE_CP_COLLECT_KIND | CHAR | 4 | ||
| MAX_NO_OF_ITEMS | Maximum Item Number to Close Batch | /PF1/DTE_BPE_MAX_NO_OF_ITEMS | NUMC | 20 | ||
| MAX_ACC_SUM | Maximum Total to Close Batch | /PF1/DTE_BPE_MAX_ACC_SUM | CURR | 12 | ||
| MIN_NO_OF_ITEMS | Minimum Item Number of Batch | /PF1/DTE_BPE_MIN_NO_OF_ITEMS | NUMC | 20 | ||
| MIN_ACC_SUM | Minimum Total to Close Batch | /PF1/DTE_BPE_MIN_ACC_SUM | CURR | 12 | ||
| MIN_CLOSE_ITEMS | Item Limit for Posting Line Items/Collective Items | /PF1/DTE_BPE_ITEM_LIMIT | NUMC | 20 | ||
| MIN_CLOSE_SUM | Minimum Monetary Amount to Close Batch | /PF1/DTE_BPE_ITEM_SUM | CURR | 12 | ||
| CUR_ACC_SUM | Currency for Payment Batch Total | /PF1/DTE_BPE_CUR_ACC_SUM | CUKY | 10 | TCURC | |
| FLG_CURRENCY | Collection by Currency | /PF1/DTE_BPE_FLG_CURRENCY | CHAR | 2 | ||
| FLG_VALUE_SPLIT | Collection by Value Date | /PF1/DTE_BPE_FLG_VALUE_SPLIT | CHAR | 2 | ||
| FLG_DEBIT_CREDIT | Joint Collection of Debit and Credit Items | /PF1/DTE_BPE_FLG_DEBIT_CREDIT | CHAR | 2 | ||
| FLG_COLL_ACCTS | Collection by Account | /PF1/DTE_BPE_FLG_COLL_ACCOUNTS | CHAR | 2 | ||
| FLG_COLL_PIKINDS | Collection by Payment Item Category | /PF1/DTE_BPE_FLG_COLL_PIKIND | CHAR | 2 | ||
| FLG_COLL_POSTDAT | Collection by Posting Date | /PF1/DTE_BPE_FLG_COLL_POSTDATE | CHAR | 2 | ||
| FLG_SHOW_COLL | Batch Payment View | /PF1/DTE_BPE_FLG_SHOW_COLL | CHAR | 2 | ||
| FLG_NET_POSTING | Net or Gross Posting | /PF1/DTE_BPE_NET_POSTING | CHAR | 2 | ||
| FLG_SINGLE_POST | Indicator: Single Post Batch Item (Yes / No) | /PF1/DTE_BPE_SINGLE_POSTING | CHAR | 2 | ||
| FLG_ACCRUED | Payment Batch Already Accrued | /PF1/DTE_CP_FLG_ACCRUALED | CHAR | 2 | ||
| FLG_RESERVED_IT | Reservation for Payment Batch | /PF1/DTE_CP_FLG_RESERVED_ITEMS | CHAR | 2 | ||
| FLG_EOD_CLOSE | Close During End-Of-Day Processing | /PF1/DTE_CP_FLG_EOD_CLOSE | CHAR | 2 | ||
| FLG_COLL_PROCDAT | Collection by Processing Date | /PF1/DTE_BPE_FLG_COLL_PROCDATE | CHAR | 2 | ||
| FLG_DUE_DATE | Collection by Due Date and Direct Debit Type | /PF1/DTE_BPE_FLG_DUE_DATE | CHAR | 2 | ||
| FLG_ORIG_MSG_ID | Collection by Original Message ID | /PF1/DTE_CP_FLG_ORIG_MSG_ID | CHAR | 2 | ||
| FLG_EXT_RESP | External status response required for queue processing | /PF1/DTE_CP_EXT_STATUS_RESP | CHAR | 2 | ||
| .INCLUDE | /PF1/STR_PO_MULTI_COLLECTOR | 0 | ||||
| FLG_MULTI_COLL | Flag to identify this CA / Collec / PO for Multi Collection | /PF1/DTE_BPE_FLG_MULTI_COLLECT | CHAR | 2 | ||
| FLG_MULTI_PROC | Flag to Check Whether Batch is Already Processed | /PF1/DTE_BPE_FLG_MULTI_PROC | CHAR | 2 | ||
| FLG_LM_RELEVANT | Indicator: Liquidity Relevant | /PF1/DTE_BPE_RELEVANT | CHAR | 2 | ||
| COLLECTION_TYPE | (OBSOLETE) Collection Criteria Group Indicator | /PF1/DTE_CP_COLLECTION_ID | CHAR | 30 | ||
| .INCLUDE | GRP_HASH_FLAGS | /PF1/STR_CP_COLL_CRITERIA_HASH | 0 | |||
| .INCLUDE | GRP_CUST_FLAGS | /PF1/STR_CP_COLL_CRITERIA_CUS | 0 | |||
| FLG_OTHERS | Execute Action | /PF1/DTE_BPE_BOOLEAN | CHAR | 2 | ||
| FLG_FEE_INFO | Charge Bearer - Batch Separation Criteria | /PF1/DTE_FEE_INFO_SEPARATION | CHAR | 2 | ||
| FLG_ORIG_PO | Payment Batch Separation Criteria - Original PO | /PF1/DTE_CP_SEPARATE_ORIG_PO | CHAR | 2 | ||
| FLG_SEPARATE_SEPA | SEPA Payment Separator Criteria | /PF1/DTE_CP_SEPA_SEPARATION | CHAR | 2 | ||
| FLG_PAYMENT_METHOD | Payment Method Separation Indicator | /PF1/DTE_CP_PAYMENT_METHOD_SEP | CHAR | 2 | ||
| FLG_BCM_RULE | BCM Release Rule Separation Indicator | /PF1/DTE_CP_BCM_RULE_SEP | CHAR | 2 | ||
| FLG_DUE_DATE_ONLY | Collection by Due Date | /PF1/DTE_BPE_FLG_DUE_DATE_ONLY | CHAR | 2 | ||
| .INCLUDE | /PF1/STR_BPE_DBADMIN | 0 | ||||
| CRUSR | Creating User | /PF1/DTE_BPE_CRUSR | CHAR | 24 | ||
| CRDAT | Creation Date | /PF1/DTE_BPE_CRDAT | DATS | 16 | ||
| CRTIM | Creation Time | /PF1/DTE_BPE_CRTIM | TIMS | 12 | ||
| CHUSR | Last User Change | /PF1/DTE_BPE_CHUSR | CHAR | 24 | ||
| CHDAT | Change Date | /PF1/DTE_BPE_CHDAT | DATS | 16 | ||
| CHTIM | Changed Time | /PF1/DTE_BPE_CHTIM | TIMS | 12 | ||
| RLUSR | User Who Released Object | /PF1/DTE_BPE_RLUSR | CHAR | 24 | ||
| RLDAT | Release Date | /PF1/DTE_BPE_RLDAT | DATS | 16 | ||
| RLTIM | Release Time | /PF1/DTE_BPE_RLTIM | TIMS | 12 |