/pf1/I_Db_Order

/PF1/I_DB_ORDER | view: /PF1/I_DBORDER | Extraction: Not supported | Component: Payment Factory
Column Name Description
clearing_area FK Clearing Area
po_date Payment Order Date
po_no Payment Order Number From Number Range
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
payment_scenario Payment Scenario Description Show values
release_activity Activity for Release and Authorization Check Show values
release_status Release 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
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
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
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
ref_cust_sgm Customer Segment /PF1/DOM_BPE_CUST_SGM
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
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
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_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
tech_priority Payment Order Technical Priority /PF1/DOM_PO_TECHNICAL_PRIORITY
crusr Creating User USNAM
chusr Last User Change USNAM
rlusr User Who Released Object USNAM
BcmBatchLeadingZeros null
Master Data Relations Join Conditions
Channel
  • Client
  • ?
  • Channel
Foreign Key for Clearing Area /PF1/I_DB_ORDER.MANDT == /PF1/T_CLAREA.MANDT
Foreign Key: Format
  • Client
  • Format
Foreign Key: Medium
  • Client
  • Medium
Foreign Key: Payment Order Type
  • Client
  • Payment Order Type
Bank Country/Region Recipient
  • Client
  • Bank Country/Region Recipient
  • /PF1/I_DB_ORDER.MANDT == T005.MANDT
  • /PF1/I_DB_ORDER.RCV_COUNTRY == T005.LAND1
Return/Rejection Reason
  • Client
  • Return/Rejection Reason
Bank Country/Region (Internal Sender)
  • Client
  • Bank Country/Region (Internal Sender)
  • /PF1/I_DB_ORDER.MANDT == T005.MANDT
  • /PF1/I_DB_ORDER.SND_INT_COUNTRY == T005.LAND1