/PF1/DB_BIS_ITEM

BIS Item/transaction data for batch screening | #transactional | Component: Payment Factory
Column Name Description
CLIENT Client
ITEM_GUID Globally Unique Identifier
Column Name Description
💲 Transaction Currency (TR_CURR):
TR_AMOUNT Amount in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
DEPARTMENT Address: Department /PF1/DOM_ISO_ADDR_LINE
SUB_DEPARTMENT Address: Sub-Department /PF1/DOM_ISO_ADDR_LINE
STREETNAME Address: Street Name /PF1/DOM_ISO_ADDR_LINE
BUILDINGNUMBER Address: Building Number /PF1/DOM_ISO_CHAR16
POSTALCODE Address: Postal Code /PF1/DOM_ISO_CHAR16
TOWNNAME Address: Town Name /PF1/DOM_ISO_CHAR35
COUNTRYSUBDIV Address: SubDivision /PF1/DOM_ISO_CHAR35
COUNTRY_ADDR ISO Country Code INTCA
ADDR_LINE1 Address Line /PF1/DOM_ISO_ADDR_LINE
ADDR_LINE2 Address Line /PF1/DOM_ISO_ADDR_LINE
ADDR_LINE3 Address Line /PF1/DOM_ISO_ADDR_LINE
ADDR_LINE4 Address Line /PF1/DOM_ISO_ADDR_LINE
ADDR_LINE5 Address Line /PF1/DOM_ISO_ADDR_LINE
ADDR_LINE6 Address Line /PF1/DOM_ISO_ADDR_LINE
ADDR_LINE7 Address Line /PF1/DOM_ISO_ADDR_LINE
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
Master Data Relations Join Conditions
Account Currency After Substitution
  • /PF1/DB_BIS_ITEM.CLIENT == TCURC.MANDT
  • /PF1/DB_BIS_ITEM.ACCT_CUR == TCURC.WAERS
Bank Country/Region
  • Bank Country/Region
  • Client
  • /PF1/DB_BIS_ITEM.COUNTRY == T005.LAND1
  • /PF1/DB_BIS_ITEM.CLIENT == T005.MANDT