/pf1/P_DB_ORDER

/PF1/P_DB_ORDER | view: /PF1/PV_DB_ORDER | TRAN | Extraction: Not supported | Component: Payment Factory
Tables used: /PF1/DB_ORDER
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
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
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
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
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
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
risk_score Risk Score
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
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_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
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
Master Data Relations Join Conditions
Channel
  • Client
  • ?
  • Channel
Foreign Key for Clearing Area /PF1/P_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
  • Bank Country/Region Recipient
  • Client
  • /PF1/P_DB_ORDER.RCV_COUNTRY == T005.LAND1
  • /PF1/P_DB_ORDER.MANDT == T005.MANDT
Return/Rejection Reason
  • Return/Rejection Reason
  • Client
Bank Country/Region (Internal Sender)
  • Bank Country/Region (Internal Sender)
  • Client
  • /PF1/P_DB_ORDER.SND_INT_COUNTRY == T005.LAND1
  • /PF1/P_DB_ORDER.MANDT == T005.MANDT