/PF1/DB_CA

Database Table for Clearing Agreements | #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
Column Name Description
Column Name Description
CLEARING_START Begin of Clearing
CLEARING_END End of Clearing
CUTOFF_TIME_OF_DAY Cut-Off Time of Day
CRDAT Creation Date
CRTIM Creation Time
CHDAT Change Date
CHTIM Changed Time
RLDAT Release Date
RLTIM Release Time
ARCHIVE_FLUD Resubmission Date
Column Name Description
RELEASE_STATUS Release Status Show values
CLEARING_STATUS Clearing Agreement Status Show values
CLEARING_TYPE Clearing Agreement Type Show values
FLG_GROUPING Payment Grouping Show values
FLG_COLLECTION Collection of Items Show values
FLG_IND_ADVICE Individual Advice Show values
FLG_CLEARING_TIME Cut-Off Time - Channel Availability Show values
CLEARING_TZ_SEL Time Zone Selection for Clearing Time Show values
FLG_ONLINE Forward Items Online Show values
FLG_LOCK_OUTPUT Lock Outgoing Payment Orders for Route/Clearing Agreement Show values
FLG_MAX_AMOUNT Maximum Amount for Outgoing Payment Orders Show values
FLG_ITEM_SPLIT Split Payment Items When Maximum Amount Exceeded Show values
LMR_MGMT_FLAG Liquidity Management Report Show values
FLG_FWD_REQUEST Processing Option - Message Forwarding vs. Clearing Show values
RCV_DETERMINATION Receiving Bank Account Determination Show values
FLG_POST_TIME Planned Execution Time Show values
POST_TIME_UNIT Time Unit for Posting Date/Time determination Show values
POST_TIME_BASE Base Time for Posting Date/Time Determination Show values
POST_TIME_UPDOWN Markup/Markdown for Posting Date/Time Determination Show values
AVIS_PRIORITY Payment Priority Show values
FLG_RESERV Prenote Required Show values
FLG_SPLIT_POSTDATE Value Date Split Show values
OUT_PRIORITY Payment Priority Show values
OUT_DECOUPLING Apply Decoupling in Emergency Cases Show values
FLG_BANK_CONFIRMATION Bank Confirmation Indicator Show values
PRIO_CLR_ITEM Payment Priority Show values
FLG_PLANNED_TIME Planned Execution Time (Internal) Show values
PL_TIME_UNIT Time Unit for Planned Execution Time and Closing Date Show values
PL_TIME_BASE Base Time for Planned Execution Time and Closing Date Show values
PL_TIME_FLG_ID Sign: Markup/Markdown Show values
CUTOFF_TIME_FLG Bank Cut-Off Time Show values
CUTOFF_TIME_BASE Base Time for Cut-Off Time Show values
CUTOFF_TIME_SIGN Markup/Markdown Sign for Cut-Off Time Show values
CUTOFF_TIME_UNIT Markup/Markdown Time Unit for Cut-Off Time Show values
FLG_BTCHBOOKG Batch Booking Indicator (Single Posting) Show values
BALANCE_CHECK Route Processing - Balance Check for Clearing Account Show values
AVOID_DUE_DATE_SHIFT Skip Due Date Shift Show values
CUTOFF_TIME_TZ_SEL Time Zone Selection for Clearing Time Show values
REACT_CA_LOCK Response to Locked Clearing Agreement Show values
REACT_MIN_RQ_NOT Response if Minimum Requirements for Closing not Met Show values
ALREADY_ALT Already used as an Alternate Clearing Agreement. Show values
RELEASE_STATUSCD Release Status Show values
ARCHIVE_STATUS Archiving Status Show values
Column Name Description Domain name
VA_RULESET Rule Set ID of Value Date Agreement /PF1/DOM_RP_RULESET_ID
POST_TIME_VALUE Value for Posting Date/Time Determination /PF1/DOM_RP_PL_DATE_INDECREASE
AVIS_CONVERTER Converter ID /PF1/DOM_BPE_CONVERTER_ID
CL_INSTITUT Clearing Institute BU_PARTNER
ROUTE_ACCT_NO Account Number for Account at Route /PF1/DOM_BPE_ACCT
ROUTE_COUNTRY Bank Country/Region for Account at Route LAND1
ROUTE_BANKKEY Bank Key for Account at Route BANKK
ROUTE_IBAN IBAN for Account at Route /PF1/DOM_BPE_IBAN
ROUTE_HOLDERNAME Account Holder for Account at Route /PF1/DOM_BPE_HOLDERNAME
OUT_CONVERTER Converter ID /PF1/DOM_BPE_CONVERTER_ID
LCL_INSTRUMENT ISO20022: Local Instrument Code or Proprietary Code /PF1/DOM_ISO_CODE35
CATEGORY_PURPOSE_CODE ISO20022: Category Purpose Code or Proprietary Code /PF1/DOM_ISO_CODE35
SERVICE_LEVEL ISO20022: Service Level Code or Proprietary Code /PF1/DOM_ISO_CODE35
PL_TIME_INDEC Markup/Markdown for Execution Time and Closing Date /PF1/DOM_RP_PL_DATE_INDECREASE
CUTOFF_TIME_OFFSET Markup/Markdown Offset for Cut-Off Time /PF1/DOM_RP_CUTOFF_TIME_OFFSET
BUKRS Company Code BUKRS
TREEID DMEE: unique description for a DMEE format tree DMEE_TREEID
TREETYPE DMEE: tree type DMEE_TREETYPE
ALT_ROUTE Alternate Route /PF1/DOM_BPE_GENERAL_ID
ALT_CA Alternate Clearing Agreement /PF1/DOM_BPE_GENERAL_ID
NODE_ID Globally Unique Identifier
CRUSR Creating User USNAM
CHUSR Last User Change USNAM
RLUSR User Who Released Object USNAM
REJECTION Rejection Reason
Master Data Relations Join Conditions
Channel
  • Channel
  • Client
  • Clearing Area
Format
Medium
Payment Order Type
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
Calendar for determ. of the processing day of outgoing PO /PF1/DB_CA.CALENDAR == TFACD.IDENT
Clearing Area /PF1/DB_CA.CLIENT == /PF1/T_CLAREA.MANDT
Time Zone of Clearing Time
  • /PF1/DB_CA.CLIENT == TTZZ.CLIENT
  • /PF1/DB_CA.CLEARING_TZ == TTZZ.TZONE
Client /PF1/DB_CA.CLIENT == T000.MANDT
Exchange Rate Type for Credit Item
  • /PF1/DB_CA.CLIENT == TCURV.MANDT
  • /PF1/DB_CA.COURSE_TYPE_CRED == TCURV.KURST
Exchange Rate Type for Debit Item
  • /PF1/DB_CA.CLIENT == TCURV.MANDT
  • /PF1/DB_CA.COURSE_TYPE_DEB == TCURV.KURST
Time Zone of Clearing Time
  • /PF1/DB_CA.CLIENT == TTZZ.CLIENT
  • /PF1/DB_CA.CUTOFF_TIME_TZ == TTZZ.TZONE
Account Symbol
  • Clearing Area
  • Client
  • Account Symbol
Credit Transaction Type for CLRs
  • Credit Transaction Type for CLRs
  • Clearing Area
Debit Transaction Type for CLRs
  • Debit Transaction Type for CLRs
  • Clearing Area
Channel
  • Channel
  • Client
  • ?
Format
  • ?
  • Format
Medium
  • ?
  • Medium
Payment Order Type
  • ?
  • Payment Order Type
Sender Identification
  • Sender Identification
  • Client
  • Clearing Area
Route
  • Release Status
  • Route ID
  • Client
Transaction Type Clearing Credit
  • Transaction Type Clearing Credit
  • Clearing Area
Debit Transaction Type for Clearing Item
  • Debit Transaction Type for Clearing Item
  • Clearing Area