/PF1/I_ITEM_ORDER

Order to Item relationship with status | view: /PF1/IV_ITEM_PO | Extraction: Not supported | Component: Payment Factory

Tables used: /PF1/DB_OBJ_REL, /PF1/DB_ORDER, /PF1/DB_ITEM, /PF1/DB_ITEM, /PF1/DB_OBJ_REL, /PF1/DB_ITEM

🔑 Keys (5)
💰 Amounts (6)
∑ Quantities
📅 Dates (29)
☰ Categorical (34)
Other (58)
🔗 Relations (13)

Column Name	Description
po_date	Reference to Outgoing Payment Order: PO Date
po_no	Reference to Outgoing Payment Order: Sequence Number
clearing_area FK	Clearing Area
pi_date	Payment Item Date
pi_no	Payment Item Number From Number Range

Column Name	Description
💲 Transaction Currency (tr_curr):
tr_amount	Amount in Transaction Currency
tr_fee	Charge Amount
nom_amount_chng	Transaction Amount Difference Changed
💲 Transfer Currency Code (a_amount_curr):
a_amount	Monetary Amount in Transfer Currency
a_amount_fee	Charges in account currency
💲 Original Currency (original_curr):
original_amount	Original Amount

Column Name	Description

Column Name	Description
po_date	Reference to Outgoing Payment Order: PO Date
pi_date	Payment Item Date
ref_pred_pi_date	Date Reference to Predecessor Items
ref_succ_pi_date	Date Reference to Successor Items
ref_inp_po_date	Reference to Incoming Payment Order: PO Date
ref_outp_po_date	Reference to Outgoing Payment Order: PO Date
ref_coll_date	Payment Batch Date
coll_ent_date	Date of Stored Item in Payment Batch
coll_ent_time	Time of Stored Item in Payment Batch
orig_val_date	(OBSOLETE) Original Value Date
orig_val_time	(OBSOLETE) Original Value Date Time
val_date	(OBSOLETE) Value Date
val_time	(OBSOLETE) Value Date Time
act_val_date	(OBSOLETE) Actual Value Date
pi_post_date	Posting Date
pi_post_time	Posting Time
pl_clr_date	Planned Clearing Date for Payment Item
pl_clr_time	Planned Clearing Time for Payment Item
pi_process_date	Date When Item was Sent to AM System for Posting
pi_process_time	Time When Item Was Sent to AM System for Posting
act_post_date	Actual Posting Date (AM)
ref_recall_date	Payment Recall Date
due_date	Due Date Specified by Ordering Party
crdat	Creation Date
crtim	Creation Time
chdat	Change Date
chtim	Changed Time
rldat	Release Date
rltim	Release Time

Column Name	Description
relation_state	Relation State of Business Objects	Show values
pi_kind	Payment Item Category	Show values
flg_posted	Item Already Posted	Show values
flg_reserved	Item Reserved in Account Management	Show values
flg_fh_error	Payment Item Error Flag	Show values
flg_disp_success	Execute Action	Show values
flg_a_returned	(OBSOLETE) Flag Active Return	Show values
flg_eh_error	Payment Item Error Flag due to EH Checks	Show values
flg_listener_reg	Event Listener Registered	Show values
flg_remittance	(OBSOLETE) Remittance Indicator	Show values
predeterm_route	Predetermined Route Retrieved from E&V	Show values
rp_to_determine	Calculate Route, Clearing Agreement and Value Date Agreement	Show values
flg_add_info	Flag for Additional Information about a Payment Item	Show values
value_date_stat	Value Date Status	Show values
flg_hld_val_date	Hold Value Date Indicator	Show values
tr_debcredind	Transaction Debit/Credit	Show values
fee_debcred	Charge Debit/Credit	Show values
fee_info	Charge Bearer	Show values
priority	Payment Priority	Show values
flg_enforce_post	Force Posting	Show values
release_activity	Activity for Release and Authorization Check	Show values
release_status	Release Status	Show values
flg_internal	Internal Posting	Show values
split_indi	Ordering Party Item Split	Show values
flg_item_auth	Flag to Indicate External Authorization Status	Show values
continue_ev_opo	Enrichment & Validation Continuation Status	Show values
pi_kind_003	Payment Item Category (Index 003)	Show values
pi_kind_004	Payment Item Category (Index 004)	Show values
pi_kind_acq	Payment Item Category (Index Collectors/Queues)	Show values
direct_deb_type	Direct Debit Type	Show values
flg_inp_po_arc	Referencing incoming order is archived	Show values
flg_outp_po_arc	Referencing outgoing order is archived	Show values
flg_out_inf_arc	Referencing advice order is archived	Show values
flg_recall_arc	Referencing recall is archived	Show values

Column Name	Description	Domain name
time_part	Partition field of DB table	/PF1/DOM_BPE_TIME_PART
guid	Globally Unique Identifier
pi_stat	Status of Generic Status Management	/PF1/DOM_BPE_SC_STATE_ID
tech_stat	Processing Status of Payment Item	/PF1/DOM_BPE_SC_STATE_ID
prev_tech_stat	Previous Technical Status of Payment Item	/PF1/DOM_BPE_SC_STATE_ID
flg_error	Error Item
update_counter	Lock Counter for Optimistic Stateless Updates	/PF1/DOM_LOCK_COUNTER
ref_acct_loc_srv	Predefined Account Location	/PF1/DOM_BPE_ALS
ref_item_ext	External Item Reference	/PF1/DOM_PO_REF_EXT_ID
ref_pi_am_area	External Item Reference in Account Management System	/PF1/DOM_PO_REF_PI_AM_AR
ref_pred_pi_no	Sequence Number Reference to Predecessor Items	/PF1/DOM_PO_PO_ID
ref_succ_pi_no	Sequence Number Reference to Successor Items	/PF1/DOM_PO_PO_ID
ref_inp_po_no	Reference to Incoming Payment Order	/PF1/DOM_PO_PO_ID
ref_outp_po_no	Reference to Outgoing Payment Order: Sequence Number	/PF1/DOM_PO_PO_ID
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
ref_prenote_id	Prenote Reference	/PF1/DOM_PO_REF_PRENOTE_ID
ref_customer	Customer	/PF1/DOM_BPE_CUSTOMER
ref_cust_sgm	Customer Segment	/PF1/DOM_BPE_CUST_SGM
ref_item_ext_out	External Item Reference - outbound messages	/PF1/DOM_PO_REF_EXT_ID
ref_cust_grp	Customer Group	/PF1/DOM_BPE_CUST_SGM
bankkey	Bank Key	BANKK
bic	Bank Identifier Code (BIC)	/PF1/DOM_BPE_BIC
iban	IBAN After Account Substitution	/PF1/DOM_BPE_IBAN
acct_no	Account Number	/PF1/DOM_BPE_ACCT
holder	Substitute Account Holder Name	/PF1/DOM_BPE_HOLDERNAME
clrsysidcd	Clearing System Member ID Code	/PF1/DOM_PO_CLRSYSMMBIDCD
ref_bankkey	Ordering Party Domestic Bank Key	BANKK
ref_bic	Ordering Party Bank Internation Code(BIC)	/PF1/DOM_BPE_BIC
ref_iban	Ordering Party Account IBAN	/PF1/DOM_BPE_IBAN
ref_acct_no	Ordering Party Account Number	/PF1/DOM_BPE_ACCT
ref_holder	Reference Account Holder	/PF1/DOM_BPE_HOLDERNAME
ref_clrsysidcd	Clearing System Member ID Code	/PF1/DOM_PO_CLRSYSMMBIDCD
ref_valuta_id	Value Date Agreement ID	/PF1/DOM_BPE_GENERAL_ID
ref_ruleset_id	Rule Set ID of Value Date Agreement	/PF1/DOM_RP_RULESET_ID
exchngrate	Exchange Rate	/PF1/DOM_PO_ITEM_EXCHANGERATE
cheque_no	Check Number	/PF1/DOM_BPE_CHEQUE_NO
flg_ev_status	Execution Status of Each Check	/PF1/DOM_PO_FLG_CHK_EV_STATUS
ev_id	Incoming Check Set ID for Payment Item E&V	/PF1/DOM_BPE_PMNT_ITEM_EV_ID
item_group	ORP/RCP item group reference	/PF1/DOM_PO_ORP_SPLIT_REF
flg_ev_status_opo	Execution Status of Each Check	/PF1/DOM_PO_FLG_CHK_EV_STATUS
ev_id_opo	Outgoing Check Set ID for Payment Item E&V	/PF1/DOM_BPE_PMNT_ITEM_EV_ID
account_holder_id	Business Partner Number	/PF1/BCA_BUPA_PARTNER
risk_score	Risk Score
ref_recall_no	Payment Recall Number	/PF1/DOM_RECALL_ID
pi_range	Payment Item Range	/PF1/DOM_BPE_PI_RANGE
pi_range_003	Payment Item Range (Index 003)	/PF1/DOM_BPE_PI_RANGE
pi_range_004	Payment Item Range (Index 004)	/PF1/DOM_BPE_PI_RANGE
pi_range_acq	Payment Item Range (Index ACQ)	/PF1/DOM_BPE_PI_RANGE
mandate_id	Mandate Identification	/PF1/DOM_PO_MANDATE_ID
uci	Creditor ID	/PF1/DOM_UCI
end_to_end_id	Ordering Party Reference (Unique Number for ISO Payment)	/PF1/DOM_PO_PI_REF_ORDPARTY
costcenter	Cost Center	KOSTL
bus_area	Business Area	GSBER
tech_priority	Payment Item 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
Account Currency After Substitution Client Account Currency After Substitution	`/PF1/I_ITEM_ORDER.MANDT == TCURC.MANDT` `/PF1/I_ITEM_ORDER.ACCT_CUR == TCURC.WAERS`
Foreign Key for Clearing Area	`/PF1/I_ITEM_ORDER.MANDT == /PF1/T_CLAREA.MANDT`
Bank Country/Region Client Bank Country/Region	`/PF1/I_ITEM_ORDER.MANDT == T005.MANDT` `/PF1/I_ITEM_ORDER.COUNTRY == T005.LAND1`
Foreing Key for Original Currency Original Currency Client	`/PF1/I_ITEM_ORDER.ORIGINAL_CURR == TCURC.WAERS` `/PF1/I_ITEM_ORDER.MANDT == TCURC.MANDT`
Creation Process of Payment Object	`/PF1/I_ITEM_ORDER.PROCESS == /PF1/T_PROCESS.PROCESS`
Ordering Party Account Currency Client Ordering Party Account Currency	`/PF1/I_ITEM_ORDER.MANDT == TCURC.MANDT` `/PF1/I_ITEM_ORDER.REF_ACCT_CUR == TCURC.WAERS`
Foreign Key for Account-Managing Unit Client Clearing Area Account Managing Area	`/PF1/I_ITEM_ORDER.MANDT == /PF1/T_AM_AREA.MANDT` `/PF1/I_ITEM_ORDER.CLEARING_AREA == /PF1/T_AM_AREA.CLEARING_AREA` `/PF1/I_ITEM_ORDER.REF_AM_AREA == /PF1/T_AM_AREA.AM_AREA`
Clearing Agreement ID ? Clearing Agreement ID Client Route ID	`/PF1/I_ITEM_ORDER.[column in domain "/PF1/DTE_BPE_CLEARING_ID"] == /PF1/DB_CA.CLEARING_ID` `/PF1/I_ITEM_ORDER.REF_CLEARING == /PF1/DB_CA.ROUTE_ID` `/PF1/I_ITEM_ORDER.MANDT == /PF1/DB_CA.CLIENT` `/PF1/I_ITEM_ORDER.REF_ROUTE == /PF1/DB_CA.CLEARING_AREA`
Ordering Party Bank Country/Region Client Ordering Party Bank Country/Region	`/PF1/I_ITEM_ORDER.MANDT == T005.MANDT` `/PF1/I_ITEM_ORDER.REF_COUNTRY == T005.LAND1`
Route ID ? Client Route ID	`/PF1/I_ITEM_ORDER.[column in domain "/PF1/DTE_BPE_ROUTE_ID"] == /PF1/DB_ROUTE.ROUTE_ID` `/PF1/I_ITEM_ORDER.MANDT == /PF1/DB_ROUTE.CLIENT` `/PF1/I_ITEM_ORDER.REF_ROUTE == /PF1/DB_ROUTE.CLEARING_AREA`
Return/Rejection Reason Return/Rejection Reason Client	`/PF1/I_ITEM_ORDER.RETURN_CODE == /PF1/T_REVERSE.CLEARING_AREA` `/PF1/I_ITEM_ORDER.MANDT == /PF1/T_REVERSE.CLIENT`
Foreign Key: Transaction Type ? Transaction Type (Advanced Payment Management) Client	`/PF1/I_ITEM_ORDER.[column in domain "/PF1/DTE_BPE_CLEARING_AREA"] == /PF1/T_TRANSTYPE.CLEARING_AREA` `/PF1/I_ITEM_ORDER.TRANS_TYPE == /PF1/T_TRANSTYPE.TRANS_TYPE` `/PF1/I_ITEM_ORDER.MANDT == /PF1/T_TRANSTYPE.MANDT`
Transaction Currency Client Transaction Currency	`/PF1/I_ITEM_ORDER.MANDT == TCURC.MANDT` `/PF1/I_ITEM_ORDER.TR_CURR == TCURC.WAERS`