/PF1/DB_ITEM_TL

Payment Items Template in the Payment Engine | #template | Component: Payment Factory
Column Name Description
CLIENT Client
CLEARING_AREA Clearing Area
TEMPLATE_PI_KEY Globally Unique Identifier
Column Name Description
💲 Transaction Currency (TR_CURR):
TR_AMOUNT Amount in Transaction Currency
TR_FEE Charge Amount
💲 Refund Compensation Currency (COM_CURR):
COM_AMOUNT Refund Compensation
💲 Account Currency (A_CURR):
A_AMOUNT Monetary Amount in Account Currency
A_FEE External Charge (Third Party)
Column Name Description
Column Name Description
Column Name Description
PI_KIND Payment Item Category Show values
TR_DEBCREDIND Transaction Debit/Credit Show values
FEE_DEBCRED Charge Debit/Credit Show values
FEE_INFO Charge Bearer Show values
DIRECT_DEB_TYPE Direct Debit Type Show values
Column Name Description Domain name
TEMPLATE_PO_KEY Globally Unique Identifier
REF_ITEM_EXT External Item Reference /PF1/DOM_PO_REF_EXT_ID
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
TRANS_TYPE Transaction Type (Advanced Payment Management) /PF1/DOM_BPE_TRNSTYPE
PRIORITY Payment Item Priority /PF1/DOM_PO_PI_PRIORITY
REF_UND_CON Contract Reference /PF1/DOM_PO_REF_UND_CON
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
STREET Street /PF1/DOM_RD_BANK_STREET
HOUSE_NUM House Number
ZIP_CODE ZIP Code /PF1/DOM_RD_ZIP_CODE
CITY City Heading /PF1/DOM_RD_CITY
COUNTRY_ADDRESS Country/Region Name /PF1/DOM_RD_COUNTRY
PAYMENT_NOTE Payment Note /PF1/DOM_PR_CONTENT
PAYMENT_NOTE_LENGTH Payment Note Length /PF1/DOM_PR_PAYMENT_NOTE_LENG
EXCHNGRATE Exchange Rate /PF1/DOM_PO_ITEM_EXCHANGERATE
ISO_XML ISO XML /PF1/DOM_ISO_XML
ISO_XML_MSG_TYPE XML Message Identifier /PF1/DOM_MESSAGE_TYPE
Master Data Relations Join Conditions
Account Currency After Substitution
  • /PF1/DB_ITEM_TL.CLIENT == TCURC.MANDT
  • /PF1/DB_ITEM_TL.ACCT_CUR == TCURC.WAERS
Bank Country/Region
  • Bank Country/Region
  • Client
  • /PF1/DB_ITEM_TL.COUNTRY == T005.LAND1
  • /PF1/DB_ITEM_TL.CLIENT == T005.MANDT
Ordering Party Account Currency
  • /PF1/DB_ITEM_TL.CLIENT == TCURC.MANDT
  • /PF1/DB_ITEM_TL.REF_ACCT_CUR == TCURC.WAERS
Ordering Party Bank Country/Region
  • Ordering Party Bank Country/Region
  • Client
  • /PF1/DB_ITEM_TL.REF_COUNTRY == T005.LAND1
  • /PF1/DB_ITEM_TL.CLIENT == T005.MANDT