/PF1/DB_COLLECT - Database Table for Collector
Database Table for Collector information is stored in SAP table /PF1/DB_COLLECT.
It is part of development package /PF1/CP_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Clearing Processing Persistency Layer".
It is part of development package /PF1/CP_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Clearing Processing Persistency Layer".
Fields for table /PF1/DB_COLLECT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | |
GUID | Globally Unique Identifier | X | GUID | RAW | 16 | |
.INCLUDE | COLLECTOR_KEY | /PF1/STR_CP_COLLECTOR_KEY | 0 | |||
CLEARING_AREA | Clearing Area | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | /PF1/T_CLAREA | |
COLLECTOR_NO | Payment Batch Number from Number Range (Secondary Key) | /PF1/DTE_CP_CO_SECONDARY_KEY | NUMC | 20 | ||
SEQUENCE_NO | Sequence Number of Payment Batch | /PF1/DTE_CP_SEQUENCE_NO | NUMC | 10 | ||
COLLECTOR_DATE | Payment Batch Date | /PF1/DTE_CP_COLLECTOR_DATE | DATS | 16 | ||
.INCLUDE | /PF1/STR_CP_COLLECTOR_DATA | 0 | ||||
.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 | ||
NO_OF_ITEMS_DEB | Payment Batch Debit Items | /PF1/DTE_CP_NO_OF_ITEMS_DEB | DEC | 6 | ||
NO_OF_ITEMS_CRED | Payment Batch Credit Items | /PF1/DTE_CP_NO_OF_ITEMS_CRED | DEC | 6 | ||
ACC_SUM_DEB | Batch Total Debit | /PF1/DTE_CP_ACC_SUM_DEB | CURR | 12 | ||
ACC_SUM_CRED | Payment Batch Total for Credit | /PF1/DTE_CP_ACC_SUM_CRED | CURR | 12 | ||
ACT_CLOSE_DATE | Date of Last Check of Time-Based Closing Criteria | /PF1/DTE_CP_ACT_CLOSE_DATE | DATS | 16 | ||
ACT_CLOSE_TIME | Time of Last Check of Time-Based Closing Criteria | /PF1/DTE_CP_ACT_CLOSE_TIME | TIMS | 12 | ||
CLOSE_REASON | Reason for Closing Payment Batch | /PF1/DTE_CP_CLOSE_REASON | CHAR | 4 | ||
COLLECTOR_STAT | Payment Batch Status | /PF1/DTE_CP_COLLECTOR_STATUS | CHAR | 6 | ||
COLLECTOR_PIKIND | Collected Payment Item Category | /PF1/DTE_CP_COLLECT_PI_KIND | CHAR | 4 | ||
CLOSE_USER | Batch Closed By | /PF1/DTE_CP_CLOSE_USER | CHAR | 24 | ||
CLOSE_DAT | Date | /PF1/DTE_BPE_DATE | DATS | 16 | ||
CLOSE_TIME | Time | /PF1/DTE_BPE_TIME | TIMS | 12 | ||
CHECK_DATE | Date of Last Specified Clearing Time Check | /PF1/DTE_CP_ACT_CHECK_DATE | DATS | 16 | ||
CHECK_TIME | Time of Last Specified Clearing Time Check | /PF1/DTE_CP_ACT_CHECK_TIME | TIMS | 12 | ||
ACCT_NO | Account Number | /PF1/DTE_BPE_ACCT | CHAR | 68 | ||
ACCT_CUR | Account Currency | /PF1/DTE_BPE_AC_CUR | CUKY | 10 | * | |
COUNTRY | Bank Country/Region | /PF1/DTE_BPE_BANKCOUNTRY | CHAR | 6 | * | |
BANKKEY | Bank Key | /PF1/DTE_BPE_BANKCODE | CHAR | 30 | ||
IBAN | International Bank Account Number (IBAN) | /PF1/DTE_BPE_IBAN | CHAR | 68 | ||
HOLDER | Account Holder Name | /PF1/DTE_BPE_HOLDERNAME | CHAR | 160 | ||
BIC | Bank Identifier Code (BIC) | /PF1/DTE_BPE_BIC | CHAR | 22 | ||
.INCLUDE | GRP_ACCOUNT_DATA | /PF1/STR_CP_ACT_SEPARATION | 0 | |||
SEP_BIC | Bank Identifier Code (BIC) | /PF1/DTE_BPE_BIC | CHAR | 22 | ||
SEP_ACCT_NO | Account Number | /PF1/DTE_BPE_ACCT | CHAR | 68 | ||
SEP_ACCT_CUR | Account Currency | /PF1/DTE_BPE_AC_CUR | CUKY | 10 | * | |
SEP_COUNTRY | Bank Country/Region | /PF1/DTE_BPE_BANKCOUNTRY | CHAR | 6 | * | |
SEP_BANKKEY | Bank Key | /PF1/DTE_BPE_BANKCODE | CHAR | 30 | ||
SEP_IBAN | International Bank Account Number (IBAN) | /PF1/DTE_BPE_IBAN | CHAR | 68 | ||
SEP_HOLDER | Account Holder Name | /PF1/DTE_BPE_HOLDERNAME | CHAR | 160 | ||
POST_DATE | Posting Date | /PF1/DTE_PO_POST_DATE | DATS | 16 | ||
FLG_RESERVED | Reservation Already Made (Prenote) | /PF1/DTE_PO_FLG_PRENOTE | CHAR | 2 | ||
REF_PRENOTE_ID | Prenote Reference | /PF1/DTE_PO_REF_PRENOTE_ID | CHAR | 92 | ||
RESERVED_AMOUNT | Amount Reserved in the Prenote | /PF1/DTE_BPE_RESERVED_AMOUNT | CURR | 12 | ||
RESERV_AMNT_CURR | Reserved in the Prenote Currency | /PF1/DTE_BPE_RESERVED_CURRENCY | CUKY | 10 | * | |
PROCESS_DATE | (Obsolete)Date when Item was sent to the AM System for Post. | DATS | 16 | |||
PL_CLR_DATE | Planned Clearing Date for Payment Item | /PF1/DTE_PO_PI_PLCLEARINGDATE | DATS | 16 | ||
FLG_ENFORCE_PROC | Forced Processing Identification | /PF1/DTE_PO_FLG_ENFORCE_PROC | CHAR | 2 | ||
.INCLUDE | /PF1/STR_CP_CLR_BOOKED | 0 | ||||
FLG_CLR_BOOKED | Identifies Clearing Item Posted when Closing Payment Batch | /PF1/DTE_CP_FLG_CLR_BOOKED | CHAR | 2 | ||
.INCLUDE | /PF1/STR_CP_COLLECTOR_SEPA | 0 | ||||
DUE_DATE | Due Date Specified by Ordering Party | /PF1/DTE_PO_DUE_DATE | DATS | 16 | ||
DIRECT_DEB_TYPE | Direct Debit Type | /PF1/DTE_SDD_TYPE | CHAR | 2 | ||
PL_CLOSING_DATE | Planned Closing Date | /PF1/DTE_CP_CLOSING_DATE | DATS | 16 | ||
REF_ORIG_MSG_ID | Original Message Identification | /PF1/DTE_REF_ORIG_MSG_ID | CHAR | 70 | ||
CHARGE_SUM_DEB | Sum of debit charges | /PF1/DTE_CHARGE_SUM_DEB | CURR | 12 | ||
CHARGE_SUM_CRED | Sum of credit charges | /PF1/DTE_CHARGE_SUM_CRED | CURR | 12 | ||
TECH_QUEUE_RSN | Creation Reason for Technical Queue | /PF1/DTE_TECH_QUEUE_REASON | CHAR | 4 | ||
.INCLUDE | GRP_HASH_FIELDS | /PF1/STR_CP_COLL_CRITERIA_FLDH | 0 | |||
.INCLUDE | GRP_CUST_FIELDS | /PF1/STR_CP_COLL_CRITERIA_FLDC | 0 | |||
OTHER_FIELD | Single-Character Flag | CHAR1 | CHAR | 2 | ||
FEE_INFO | Charge Bearer | /PF1/DTE_BPE_CHARGE_DETAIL | CHAR | 12 | ||
ORIG_PO | PO-Key | CHAR | 40 | |||
ACCT_CURR | Account Currency | /PF1/DTE_PO_ITEM_ACCOUNT_CURR | CUKY | 10 | * | |
SEPA_PAYMENT | Ruleset Indicator - SEPA Payment | /PF1/DTE_RP_SEPA_PAYMENT | CHAR | 2 | ||
PAYMENT_METHOD | ISO20022: Payment Method (short) | /PF1/DTE_PAYM_METHOD | CHAR | 6 | ||
BCM_RULE | Rule Id | BNK_COM_BTCH_RULE_ID | CHAR | 20 | * | |
COLLECTION_KEY | Batch Separation Criteria Key (Hash) | /PF1/DTE_CP_COLLECTION_KEY | CHAR | 128 | ||
.INCLUDE | /PF1/STR_CP_COLLECTOR_SUMS | 0 | ||||
TR_SUM_DEB | Batch Total Debit | /PF1/DTE_CP_ACC_SUM_DEB | CURR | 12 | ||
TR_SUM_CRED | Payment Batch Total for Credit | /PF1/DTE_CP_ACC_SUM_CRED | CURR | 12 | ||
A_AMOUNT_DEB | Amount in Account Currency (Aggregated) | /PF1/DTE_CP_A_AMOUNT_SUM_DEB | CURR | 12 | ||
A_AMOUNT_CRED | Amount in Account Currency (Aggregated) | /PF1/DTE_CP_A_AMOUNT_SUM_CRED | CURR | 12 | ||
.INCLUDE | /PF1/STR_CP_ORDER | 0 | ||||
CLOSE_TIMESTAMP | Time Stamp for Closing Time | /PF1/DTE_CP_CLOSE_TIMESTAMP | CHAR | 28 | ||
CURRENCY | Transaction Currency | /PF1/DTE_BPE_CURR | CUKY | 10 | * | |
DEBCREDIND | Transaction Debit/Credit | /PF1/DTE_BPE_DCFLG | CHAR | 2 | ||
VALUE_DATE | (OBSOLETE) Value Date | /PF1/DTE_PO_VALUE_DATE | DATS | 16 | ||
ROUTE_ID | Route ID | /PF1/DTE_BPE_ROUTE_ID | CHAR | 22 | ||
CLEARING_ID | Clearing Agreement ID | /PF1/DTE_BPE_CLEARING_ID | CHAR | 22 | ||
PO_DATE | Payment Order Date | /PF1/DTE_PO_PO_DATE | DATS | 16 | ||
PO_NO | Payment Order Number From Number Range | /PF1/DTE_PO_PO_SECONDARY_KEY | NUMC | 24 | ||
.INCLUDE | AFX_STATUS_DATA_EXT | 0 | ||||
ARCHIVE_STATUS | Archiving Status | TYP_ARCHIVE_STATUS | CHAR | 2 | ||
ARCHIVE_FLUD | Resubmission Date | TYP_ARCHIVE_FLUD | DATS | 16 | ||
REJECTION | Rejection Reason | TYP_REJECTION | CHAR | 4 | ||
.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 |