/pf1/I_ITEM

/PF1/I_ITEM | view: /PF1/IV_ITEM | Extraction: Not supported | Component: Payment Factory

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

🔑 Keys (3)
💰 Amounts (7)
∑ Quantities
📅 Dates (28)
☰ Categorical (33)
Other (59)
🔗 Relations (14)

Column Name	Description
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
💲 Release Currency (release_curr):
release_amount	Amount Calculated for Release

Column Name	Description

Column Name	Description
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
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
snd_company_code	Company Code	BUKRS
crusr	Creating User	USNAM
chusr	Last User Change	USNAM
rlusr	User Who Released Object	USNAM

Master Data Relations	Join Conditions
Account Currency After Substitution Account Currency After Substitution Client	`/PF1/I_ITEM.ACCT_CUR == TCURC.WAERS` `/PF1/I_ITEM.MANDT == TCURC.MANDT`
Foreign Key for Clearing Area	`/PF1/I_ITEM.MANDT == /PF1/T_CLAREA.MANDT`
Bank Country/Region Bank Country/Region Client	`/PF1/I_ITEM.COUNTRY == T005.LAND1` `/PF1/I_ITEM.MANDT == T005.MANDT`
Foreing Key for Original Currency Original Currency Client	`/PF1/I_ITEM.ORIGINAL_CURR == TCURC.WAERS` `/PF1/I_ITEM.MANDT == TCURC.MANDT`
Foreign Key: Payment Order Type Payment Order Type Client	`/PF1/I_ITEM.PO_TYPE == /PF1/T_POTYPE.CLEARING_AREA` `/PF1/I_ITEM.MANDT == /PF1/T_POTYPE.MANDT`
Creation Process of Payment Object	`/PF1/I_ITEM.PROCESS == /PF1/T_PROCESS.PROCESS`
Ordering Party Account Currency Ordering Party Account Currency Client	`/PF1/I_ITEM.REF_ACCT_CUR == TCURC.WAERS` `/PF1/I_ITEM.MANDT == TCURC.MANDT`
Foreign Key for Account-Managing Unit Clearing Area Account Managing Area Client	`/PF1/I_ITEM.CLEARING_AREA == /PF1/T_AM_AREA.CLEARING_AREA` `/PF1/I_ITEM.REF_AM_AREA == /PF1/T_AM_AREA.AM_AREA` `/PF1/I_ITEM.MANDT == /PF1/T_AM_AREA.MANDT`
Clearing Agreement ID Route ID Clearing Agreement ID ? Client	`/PF1/I_ITEM.REF_ROUTE == /PF1/DB_CA.CLEARING_AREA` `/PF1/I_ITEM.REF_CLEARING == /PF1/DB_CA.ROUTE_ID` `/PF1/I_ITEM.[column in domain "/PF1/DTE_BPE_CLEARING_ID"] == /PF1/DB_CA.CLEARING_ID` `/PF1/I_ITEM.MANDT == /PF1/DB_CA.CLIENT`
Ordering Party Bank Country/Region Client Ordering Party Bank Country/Region	`/PF1/I_ITEM.MANDT == T005.MANDT` `/PF1/I_ITEM.REF_COUNTRY == T005.LAND1`
Route ID Route ID ? Client	`/PF1/I_ITEM.REF_ROUTE == /PF1/DB_ROUTE.CLEARING_AREA` `/PF1/I_ITEM.[column in domain "/PF1/DTE_BPE_ROUTE_ID"] == /PF1/DB_ROUTE.ROUTE_ID` `/PF1/I_ITEM.MANDT == /PF1/DB_ROUTE.CLIENT`
Return/Rejection Reason Return/Rejection Reason Client	`/PF1/I_ITEM.RETURN_CODE == /PF1/T_REVERSE.CLEARING_AREA` `/PF1/I_ITEM.MANDT == /PF1/T_REVERSE.CLIENT`
Foreign Key: Transaction Type Transaction Type (Advanced Payment Management) ? Client	`/PF1/I_ITEM.TRANS_TYPE == /PF1/T_TRANSTYPE.TRANS_TYPE` `/PF1/I_ITEM.[column in domain "/PF1/DTE_BPE_CLEARING_AREA"] == /PF1/T_TRANSTYPE.CLEARING_AREA` `/PF1/I_ITEM.MANDT == /PF1/T_TRANSTYPE.MANDT`
Transaction Currency Transaction Currency Client	`/PF1/I_ITEM.TR_CURR == TCURC.WAERS` `/PF1/I_ITEM.MANDT == TCURC.MANDT`