/PF1/DB_COLLECT

Database Table for Collector | #transactional | Component: Payment Factory
Column Name Description
CLIENT Client
GUID Globally Unique Identifier
Column Name Description
💲 Currency for Payment Batch Total (CUR_ACC_SUM):
MAX_ACC_SUM Maximum Total to Close Batch
MIN_ACC_SUM Minimum Total to Close Batch
MIN_CLOSE_SUM Minimum Monetary Amount to Close Batch
ACC_SUM_DEB Batch Total Debit
ACC_SUM_CRED Payment Batch Total for Credit
CHARGE_SUM_DEB Sum of debit charges
CHARGE_SUM_CRED Sum of credit charges
💲 Reserved in the Prenote Currency (RESERV_AMNT_CURR):
RESERVED_AMOUNT Amount Reserved in the Prenote
TR_SUM_DEB Batch Total Debit
TR_SUM_CRED Payment Batch Total for Credit
A_AMOUNT_DEB Amount in Account Currency (Aggregated)
A_AMOUNT_CRED Amount in Account Currency (Aggregated)
Column Name Description
Column Name Description
COLLECTOR_DATE Payment Batch Date
ACT_CLOSE_DATE Date of Last Check of Time-Based Closing Criteria
ACT_CLOSE_TIME Time of Last Check of Time-Based Closing Criteria
CLOSE_DAT Date
CLOSE_TIME Time
CHECK_DATE Date of Last Specified Clearing Time Check
CHECK_TIME Time of Last Specified Clearing Time Check
POST_DATE Posting Date
PROCESS_DATE null
PL_CLR_DATE Planned Clearing Date for Payment Item
DUE_DATE Due Date Specified by Ordering Party
PL_CLOSING_DATE Planned Closing Date
VALUE_DATE (OBSOLETE) Value Date
PO_DATE Payment Order Date
ARCHIVE_FLUD Resubmission Date
CRDAT Creation Date
CRTIM Creation Time
CHDAT Change Date
CHTIM Changed Time
RLDAT Release Date
RLTIM Release Time
Column Name Description
DIRECTION Payment Batch Direction Show values
COLLECT_KIND Collection Type Show values
FLG_CURRENCY Collection by Currency Show values
FLG_VALUE_SPLIT Collection by Value Date Show values
FLG_DEBIT_CREDIT Joint Collection of Debit and Credit Items Show values
FLG_COLL_ACCTS Collection by Account Show values
FLG_COLL_PIKINDS Collection by Payment Item Category Show values
FLG_COLL_POSTDAT Collection by Posting Date Show values
FLG_SHOW_COLL Batch Payment View Show values
FLG_NET_POSTING Net or Gross Posting Show values
FLG_SINGLE_POST Indicator: Single Post Batch Item (Yes / No) Show values
FLG_ACCRUED Payment Batch Already Accrued Show values
FLG_RESERVED_IT Reservation for Payment Batch Show values
FLG_EOD_CLOSE Close During End-Of-Day Processing Show values
FLG_COLL_PROCDAT Collection by Processing Date Show values
FLG_DUE_DATE Collection by Due Date and Direct Debit Type Show values
FLG_ORIG_MSG_ID Collection by Original Message ID Show values
FLG_EXT_RESP External status response required for queue processing Show values
FLG_MULTI_COLL Flag to identify this CA / Collec / PO for Multi Collection Show values
FLG_MULTI_PROC Flag to Check Whether Batch is Already Processed Show values
FLG_LM_RELEVANT Indicator: Liquidity Relevant Show values
COLLECTION_TYPE (OBSOLETE) Collection Criteria Group Indicator Show values
FLG_OTHERS Execute Action Show values
FLG_FEE_INFO Charge Bearer - Batch Separation Criteria Show values
FLG_ORIG_PO Payment Batch Separation Criteria - Original PO Show values
FLG_SEPARATE_SEPA SEPA Payment Separator Criteria Show values
FLG_PAYMENT_METHOD Payment Method Separation Indicator Show values
FLG_BCM_RULE BCM Release Rule Separation Indicator Show values
FLG_DUE_DATE_ONLY Collection by Due Date Show values
CLOSE_REASON Reason for Closing Payment Batch Show values
COLLECTOR_STAT Payment Batch Status Show values
COLLECTOR_PIKIND Collected Payment Item Category Show values
FLG_RESERVED Reservation Already Made (Prenote) Show values
FLG_ENFORCE_PROC Forced Processing Identification Show values
FLG_CLR_BOOKED Identifies Clearing Item Posted when Closing Payment Batch Show values
DIRECT_DEB_TYPE Direct Debit Type Show values
TECH_QUEUE_RSN Creation Reason for Technical Queue Show values
FEE_INFO Charge Bearer Show values
SEPA_PAYMENT Ruleset Indicator - SEPA Payment Show values
PAYMENT_METHOD ISO20022: Payment Method (short) Show values
DEBCREDIND Transaction Debit/Credit Show values
ARCHIVE_STATUS Archiving Status Show values
Column Name Description Domain name
COLLECTOR_NO Payment Batch Number from Number Range (Secondary Key) /PF1/DOM_CP_CO_SECONDARY_KEY
SEQUENCE_NO Sequence Number of Payment Batch /PF1/DOM_CP_SEQUENCE_NO
MAX_NO_OF_ITEMS Maximum Item Number to Close Batch NUM10
MIN_NO_OF_ITEMS Minimum Item Number of Batch NUM10
MIN_CLOSE_ITEMS Item Limit for Posting Line Items/Collective Items NUM10
NO_OF_ITEMS_DEB Payment Batch Debit Items /PF1/DOM_CP_NO_OF_ITEMS_DEB
NO_OF_ITEMS_CRED Payment Batch Credit Items /PF1/DOM_CP_NO_OF_ITEMS_CRED
CLOSE_USER Batch Closed By /PF1/DOM_CP_CLOSE_USER
ACCT_NO Account Number /PF1/DOM_BPE_ACCT
COUNTRY Bank Country/Region LAND1
BANKKEY Bank Key BANKK
IBAN International Bank Account Number (IBAN) /PF1/DOM_BPE_IBAN
HOLDER Account Holder Name /PF1/DOM_BPE_HOLDERNAME
BIC Bank Identifier Code (BIC) /PF1/DOM_BPE_BIC
SEP_BIC Bank Identifier Code (BIC) /PF1/DOM_BPE_BIC
SEP_ACCT_NO Account Number /PF1/DOM_BPE_ACCT
SEP_COUNTRY Bank Country/Region LAND1
SEP_BANKKEY Bank Key BANKK
SEP_IBAN International Bank Account Number (IBAN) /PF1/DOM_BPE_IBAN
SEP_HOLDER Account Holder Name /PF1/DOM_BPE_HOLDERNAME
REF_PRENOTE_ID Prenote Reference /PF1/DOM_PO_REF_PRENOTE_ID
REF_ORIG_MSG_ID Original Message Identification
OTHER_FIELD Single-Character Flag CHAR1
ORIG_PO null
BCM_RULE Rule Id BNK_COM_ID
COLLECTION_KEY Batch Separation Criteria Key (Hash) CHAR64
CLOSE_TIMESTAMP Time Stamp for Closing Time TIMESTAMP
ROUTE_ID Route ID /PF1/DOM_BPE_GENERAL_ID
CLEARING_ID Clearing Agreement ID /PF1/DOM_BPE_GENERAL_ID
PO_NO Payment Order Number From Number Range /PF1/DOM_PO_PO_ID
REJECTION Rejection Reason
CRUSR Creating User USNAM
CHUSR Last User Change USNAM
RLUSR User Who Released Object USNAM
Master Data Relations Join Conditions
Check Table for Clearing Area /PF1/DB_COLLECT.CLIENT == /PF1/T_CLAREA.MANDT
Currency for Payment Batch Total
  • /PF1/DB_COLLECT.CLIENT == TCURC.MANDT
  • /PF1/DB_COLLECT.CUR_ACC_SUM == TCURC.WAERS