/PF1/DB_ORDER

Payment Order in the Payment Engine | #transactional | Component: Payment Factory
Column Name Description
CLIENT Client
GUID Globally Unique Identifier
Column Name Description
💲 Currency of Recipient Items (SUM_CURR):
SUM_ITEMS Sum of Amounts
💲 Release Currency (RELEASE_CURR):
RELEASE_AMOUNT Amount Calculated for Release
Column Name Description
Column Name Description
PO_DATE Payment Order Date
PROC_DATE Order Processing Date in Advanced Payment Mgmt
PROC_TIME Order Processing Time in Advanced Payment Management
PL_PROC_DATE Execution Date (Planned)
PL_PROC_TIME Execution Time (Planned)
FILE_CRDATE File Creation Date
OL_DATE Object List Date
REF_COLL_DATE Payment Batch Date
REF_RECALL_DATE Payment Recall Date
ORP_VAL_DATE_1 (OBSOLETE) Ordering Party Value Date 1
ORP_VAL_DATE_2 (OBSOLETE) Ordering Party Value Date 2
SETT_DATE (OBSOLETE) Interbank Settlement Date
DUE_DATE Due Date Specified by Ordering Party
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
PRIORITY Payment Priority Show values
FLG_FH_ERROR Payment Order Error Flag Show values
FLG_ENFORCE_PROC Forced Processing Identification Show values
PO_SIZE Flag for Small or Large Order Size Category Show values
FLG_EH_ERROR Payment Order Error Flag due to EH Checks Show values
FLG_LISTENER_REG Event Listener Registered Show values
BTCHBOOKG Batch Booking Indicator Show values
FLG_ADD_INFO (Additional) Information for Payment Order Available Show values
RELEASE_ACTIVITY Activity for Release and Authorization Check Show values
RELEASE_STATUS Release Status Show values
CONTINUE_EV Enrichment & Validation Continuation Status Show values
FLG_DUP_CHECK Duplicate Check Show values
FLG_DUP_CHECKSUM Internal or External Checksum Show values
PO_AUTH_FLAG Flag for Authorization Check Show values
PAYMENT_SCENARIO Payment Scenario Description Show values
ORP_SPLIT Ordering Party Item Split Show values
AUTH_PENDING Pending Authorization Indicator Show values
FLG_HOLD_VALDATE (OBSOLETE) Holds Value Date Indicator 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
ARCHIVE_STATUS Archiving Status Show values
Column Name Description Domain name
PO_NO Payment Order Number From Number Range /PF1/DOM_PO_PO_ID
TECH_STAT Technical Status of Payment Order /PF1/DOM_BPE_SC_STATE_ID
PREV_TECH_STAT Previous Technical Status of Payment Order /PF1/DOM_BPE_SC_STATE_ID
FILE_NUMBER File Number /PF1/DOM_FH_FILE_NO
IPO_RESUB_STAT Technical Status of Payment Order /PF1/DOM_BPE_SC_STATE_ID
UPDATE_COUNTER Lock Counter for Optimistic Stateless Updates /PF1/DOM_LOCK_COUNTER
TECH_PRIORITY Payment Order Technical Priority /PF1/DOM_PO_TECHNICAL_PRIORITY
PROCESS Creation Process of Payment Object /PF1/DOM_PI_PROCESS
SEGMENTATION_KEY Segmentation Criteria for DB Tables /PF1/DOM_BPE_SEGMENTATION_KEY
SND_INT_BANKKEY Bank Key (Internal Sender) BANKK
SND_INT_BIC Bank Identifier Code (BIC) of Internal Sender /PF1/DOM_BPE_BIC
SND_INT_IBAN IBAN (Internal Sender) /PF1/DOM_BPE_IBAN
SND_INT_ACC Account Number (Internal Sender) /PF1/DOM_BPE_ACCT
SND_INT_ACC_HLDR Sender Name /PF1/DOM_BPE_HOLDERNAME
SND_INT_REF Reference (Internal Sender) /PF1/DOM_PO_REF_EXT_PO_ID
SND_COMPANY_CODE Company Code BUKRS
SND_BAM_ID Bank Account Technical ID NUM10
RCV_BANKKEY Bank Key Recipient BANKK
RCV_BIC Bank Identifier Code (BIC) of Recipient /PF1/DOM_BPE_BIC
RCV_NAME Recipient Name /PF1/DOM_BPE_HOLDERNAME
REF_EXT_PO External Payment Order Number /PF1/DOM_PO_REF_EXT_ID
RISK_SCORE Risk Score
PAYMENT_METHOD Payment Method for This Payment ZLSCH
PAYMENT_METHOD_SUPPLEMENT Payment method supplement UZAWE
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
OL_NO Object List Number from Number Range (Secondary Key) /PF1/DOM_FH_OL_ID
CNT_ORP_ITEMS Number of Ordering Party Items /PF1/DOM_BPE_COUNT_8DIGITS
CNT_RCP_ITEMS Number of Recipient Items /PF1/DOM_BPE_COUNT_8DIGITS
CNT_CLR_ITEMS Number of Clearing Items /PF1/DOM_BPE_COUNT_8DIGITS
CNT_TOV_ITEMS Number of Turnover Items /PF1/DOM_BPE_COUNT_8DIGITS
REF_COLL_NO Payment Batch Number from Number Range (Secondary Key) /PF1/DOM_CP_CO_SECONDARY_KEY
REF_COLL_SEQ_NO Sequence Number of Payment Batch /PF1/DOM_CP_SEQUENCE_NO
FLG_EV_STATUS Execution Status of Each Check /PF1/DOM_PO_FLG_CHK_EV_STATUS
EV_ID_ORDER Check Set ID for Payment Order Enrichment and Validation NUMC6
EV_ID_X_ITEM Check Set ID for Cross Item Enrichment and Validation NUMC6
CHECK_SUM_METHOD Function Name FUNCNAME
TIMESTAMP_SBM_PS File Submission Time /PF1/DOM_TIME_STAMP
CHECKSUM Order Checksum /PF1/DOM_PO_CHECKSUM
TIMESTAMP_FCT_PS Timestamp Functional Submission/Output (Adv. Payment Mgmt) /PF1/DOM_TIME_STAMP
REF_CUST_GRP Customer Group /PF1/DOM_BPE_CUST_SGM
REF_CUSTOMER Customer /PF1/DOM_BPE_CUSTOMER
REF_CUST_SGM Customer Segment /PF1/DOM_BPE_CUST_SGM
REF_RECALL_NO Payment Recall Number /PF1/DOM_RECALL_ID
AUTH_PO_ID Payment Order ID of the Authorization System /PF1/DOM_PO_AUTH_PO_ID
AUTH_TIMESTAMP Timestamp of the Authorization /PF1/DOM_TIME_STAMP
REJECTION Rejection Reason
CRUSR Creating User USNAM
CHUSR Last User Change USNAM
RLUSR User Who Released Object USNAM
Master Data Relations Join Conditions
Channel
  • Channel
  • Client
  • ?
Foreign Key for Clearing Area /PF1/DB_ORDER.CLIENT == /PF1/T_CLAREA.MANDT
Foreign Key: Format
Foreign Key: Medium
Foreign Key: Payment Order Type
Bank Country/Region Recipient
  • Bank Country/Region Recipient
  • Client
  • /PF1/DB_ORDER.RCV_COUNTRY == T005.LAND1
  • /PF1/DB_ORDER.CLIENT == T005.MANDT
Return/Rejection Reason
Bank Country/Region (Internal Sender)
  • Bank Country/Region (Internal Sender)
  • Client
  • /PF1/DB_ORDER.SND_INT_COUNTRY == T005.LAND1
  • /PF1/DB_ORDER.CLIENT == T005.MANDT