/PF1/DB_COLLINFO

Database Table for Collector Information | #masterdata | Component: Payment Factory
Column Name Description
CLIENT FK Client
CLEARING_AREA FK Clearing Area
ROUTE_ID FK Route ID
CLEARING_ID Clearing Agreement ID
RELEASE_STATUS Release Status Show values
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
Column Name Description
Column Name Description
CRDAT Creation Date
CRTIM Creation Time
CHDAT Change Date
CHTIM Changed Time
RLDAT Release Date
RLTIM Release Time
Column Name Description
RELEASE_STATUS Release Status Show values
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
Column Name Description Domain name
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
CRUSR Creating User USNAM
CHUSR Last User Change USNAM
RLUSR User Who Released Object USNAM
Master Data Relations Join Conditions
Clearing Area /PF1/DB_COLLINFO.CLIENT == /PF1/T_CLAREA.MANDT
Client /PF1/DB_COLLINFO.CLIENT == T000.MANDT
Currency for Payment Batch Total
  • /PF1/DB_COLLINFO.CLIENT == TCURC.MANDT
  • /PF1/DB_COLLINFO.CUR_ACC_SUM == TCURC.WAERS
Route ID
  • Release Status
  • Route ID
  • Client