/PF1/DB_ITEM

Payment Items in the Payment Engine | #transactional | Component: Payment Factory
Column Name Description
CLIENT Client
GUID Globally Unique Identifier
Column Name Description
💲 Transaction Currency (TR_CURR):
TR_AMOUNT Amount in Transaction Currency
TR_FEE Charge Amount
NOM_AMOUNT_CHNG Transaction Amount Difference Changed
💲 Original Currency (ORIGINAL_CURR):
ORIGINAL_AMOUNT Original Amount
💲 Transfer Currency Code (A_AMOUNT_CURR):
A_AMOUNT Monetary Amount in Transfer Currency
A_AMOUNT_FEE Charges in account currency
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
FLG_TCHAIN (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
PI_NO Payment Item Number From Number Range /PF1/DOM_PO_PO_ID
SEGMENTATION_KEY Segmentation Criteria for DB Tables /PF1/DOM_BPE_SEGMENTATION_KEY
TIME_PART Partition field of DB table /PF1/DOM_BPE_TIME_PART
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
TECH_PRIORITY Payment Item Technical Priority /PF1/DOM_PO_TECHNICAL_PRIORITY
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_ITEM_EXT_OUT External Item Reference - outbound messages /PF1/DOM_PO_REF_EXT_ID
REF_ITEM_EXT_IN External Item Reference - inbound messages /PF1/DOM_PO_REF_EXT_ID
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
UETR Unique Transaction Reference (UETR) SMUM_C36
REF_PREDEF_GRP Predefined grouping criteria /PF1/DOM_PO_PI_REF_PREDEF_GRP
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
BAM_ID Bank Account Technical ID NUM10
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
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
COSTCENTER Cost Center KOSTL
BUS_AREA Business Area GSBER
UNIT Bank Area IHC_DOM_UNIT
PN_NUMBER Payment Order Number IHC_DOM_PN_NUMBER
PN_YEAR Fiscal Year of IHC Payment Order JAHR
PAYMENT_METHOD Payment Method for This Payment ZLSCH
PAYMENT_METHOD_SUPPLEMENT Payment method supplement UZAWE
CRUSR Creating User USNAM
CHUSR Last User Change USNAM
RLUSR User Who Released Object USNAM
Master Data Relations Join Conditions
Account Currency After Substitution
  • /PF1/DB_ITEM.CLIENT == TCURC.MANDT
  • /PF1/DB_ITEM.ACCT_CUR == TCURC.WAERS
Foreign Key for Clearing Area /PF1/DB_ITEM.CLIENT == /PF1/T_CLAREA.MANDT
Bank Country/Region
  • Bank Country/Region
  • Client
  • /PF1/DB_ITEM.COUNTRY == T005.LAND1
  • /PF1/DB_ITEM.CLIENT == T005.MANDT
Foreing Key for Original Currency
  • /PF1/DB_ITEM.CLIENT == TCURC.MANDT
  • /PF1/DB_ITEM.ORIGINAL_CURR == TCURC.WAERS
Creation Process of Payment Object /PF1/DB_ITEM.PROCESS == /PF1/T_PROCESS.PROCESS
Ordering Party Account Currency
  • /PF1/DB_ITEM.CLIENT == TCURC.MANDT
  • /PF1/DB_ITEM.REF_ACCT_CUR == TCURC.WAERS
Foreign Key for Account-Managing Unit
  • Clearing Area
  • Account Managing Area
Clearing Agreement ID
  • ?
  • Client
  • Route ID
  • Clearing Agreement ID
  • /PF1/DB_ITEM.[column in domain "/PF1/DTE_BPE_CLEARING_ID"] == /PF1/DB_CA.CLEARING_ID
  • /PF1/DB_ITEM.CLIENT == /PF1/DB_CA.CLIENT
  • /PF1/DB_ITEM.REF_ROUTE == /PF1/DB_CA.CLEARING_AREA
  • /PF1/DB_ITEM.REF_CLEARING == /PF1/DB_CA.ROUTE_ID
Ordering Party Bank Country/Region
  • Ordering Party Bank Country/Region
  • Client
  • /PF1/DB_ITEM.REF_COUNTRY == T005.LAND1
  • /PF1/DB_ITEM.CLIENT == T005.MANDT
Route ID
  • ?
  • Route ID
  • Client
Return/Rejection Reason
Foreign Key: Transaction Type
  • Transaction Type (Advanced Payment Management)
  • ?
Transaction Currency
  • /PF1/DB_ITEM.CLIENT == TCURC.MANDT
  • /PF1/DB_ITEM.TR_CURR == TCURC.WAERS