I_BankChainItemTP

TP for Intermediary bank of Bank Chain | view: IFABCHITEMTP | Extraction: Not supported | Component: Master Data

Tables used: TBCHAIN21

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (3)
Other (3)
🔗 Relations (14)

Column Name	Description
BkChnCountryKeyOfRecipientBank FK	Country/Region Key of Recipient Bank
BkChnBankKeyOfRecipientBank FK	Bank Key of Recipient Bank
BkChnAcctNumberAtRecipientBank	Account Number at Recipient Bank
BkChnCurrencyKey FK	Currency
BkChnCountryKeyOfSenderBank FK	Country/Region Key of Sender Bank
BkChnBankKeyOfSenderBank FK	Bank Key of Sender Bank
BkChnPaymentMethodSupplement FK	Payment method supplement
BkChnIntermediaryBank	Current Number of a Bank in Bank Chain	Show values

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
BkChnIntermediaryBank	Current Number of a Bank in Bank Chain	Show values
BkChnIntermediaryBankForEdit	Current Number of a Bank in Bank Chain	Show values
BkChnTypeOfBankInBankChain	Type of Bank in a Bank Chain (Correspondent, Intermediary)	Show values

Column Name	Description	Domain name
BkChnAcctNmbrAtRcpntBkForEdit	Account Number at Recipient Bank	BANKN35
BkChnAcctNmbrAtCorrespondBank	Account Number at Correspondent Bank	BANKN35
IBAN	IBAN (International Bank Account Number)	IBAN

Master Data Relations	Join Conditions
Bank Key of Recipient Bank Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank Bank Key of Recipient Bank Bank Key of Recipient Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNBANKKEYOFRECIPIENTBANK == BNKA.BANKL` `I_BANKCHAINITEMTP.BKCHNBKKEYOFRCPNTBKFOREDIT == BNKA.BANKL` `I_BANKCHAINITEMTP.MANDT == BNKA.MANDT`
Bank Key of Sender Bank Country/Region Key of Sender Bank Country/Region Key of Sender Bank Bank Key of Sender Bank Bank Key of Sender Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFSENDERBANK == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNBANKKEYOFSENDERBANK == BNKA.BANKL` `I_BANKCHAINITEMTP.BKCHNBKKEYOFSNDRBKFOREDIT == BNKA.BANKL` `I_BANKCHAINITEMTP.MANDT == BNKA.MANDT`
Bank Key of a Correspondent Bank Country/Region Key of a Correspondent Bank Bank Key of a Correspondent Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFCORRESPONDENTBK == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNBKKEYOFCORRESPONDENCEBANK == BNKA.BANKL` `I_BANKCHAINITEMTP.MANDT == BNKA.MANDT`
Bank Key of Recipient Bank Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank Bank Key of Recipient Bank Bank Key of Recipient Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNBANKKEYOFRECIPIENTBANK == BNKA.BANKL` `I_BANKCHAINITEMTP.BKCHNBKKEYOFRCPNTBKFOREDIT == BNKA.BANKL` `I_BANKCHAINITEMTP.MANDT == BNKA.MANDT`
Bank Key of Sender Bank Country/Region Key of Sender Bank Country/Region Key of Sender Bank Bank Key of Sender Bank Bank Key of Sender Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFSENDERBANK == BNKA.BANKS` `I_BANKCHAINITEMTP.BKCHNBANKKEYOFSENDERBANK == BNKA.BANKL` `I_BANKCHAINITEMTP.BKCHNBKKEYOFSNDRBKFOREDIT == BNKA.BANKL` `I_BANKCHAINITEMTP.MANDT == BNKA.MANDT`
Country/Region Key of a Correspondent Bank Country/Region Key of a Correspondent Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFCORRESPONDENTBK == T005.LAND1` `I_BANKCHAINITEMTP.MANDT == T005.MANDT`
Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == T005.LAND1` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == T005.LAND1` `I_BANKCHAINITEMTP.MANDT == T005.MANDT`
Country/Region Key of Sender Bank Country/Region Key of Sender Bank Country/Region Key of Sender Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == T005.LAND1` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFSENDERBANK == T005.LAND1` `I_BANKCHAINITEMTP.MANDT == T005.MANDT`
Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank Country/Region Key of Recipient Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFRCPNTBKFOREDIT == T005.LAND1` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFRECIPIENTBANK == T005.LAND1` `I_BANKCHAINITEMTP.MANDT == T005.MANDT`
Country/Region Key of Sender Bank Country/Region Key of Sender Bank Country/Region Key of Sender Bank Client	`I_BANKCHAINITEMTP.BKCHNCNTRYKEYOFSNDRBKFOREDIT == T005.LAND1` `I_BANKCHAINITEMTP.BKCHNCOUNTRYKEYOFSENDERBANK == T005.LAND1` `I_BANKCHAINITEMTP.MANDT == T005.MANDT`
Currency Client Currency Currency	`I_BANKCHAINITEMTP.MANDT == TCURC.MANDT` `I_BANKCHAINITEMTP.BKCHNCURRENCYKEYFOREDIT == TCURC.WAERS` `I_BANKCHAINITEMTP.BKCHNCURRENCYKEY == TCURC.WAERS`
Currency Client Currency Currency	`I_BANKCHAINITEMTP.MANDT == TCURC.MANDT` `I_BANKCHAINITEMTP.BKCHNCURRENCYKEYFOREDIT == TCURC.WAERS` `I_BANKCHAINITEMTP.BKCHNCURRENCYKEY == TCURC.WAERS`
Payment method supplement Payment method supplement Payment method supplement Client	`I_BANKCHAINITEMTP.BKCHNPAYTMETHSUPLMNTFOREDIT == T042F.UZAWE` `I_BANKCHAINITEMTP.BKCHNPAYMENTMETHODSUPPLEMENT == T042F.UZAWE` `I_BANKCHAINITEMTP.MANDT == T042F.MANDT`
Payment method supplement Payment method supplement Payment method supplement Client	`I_BANKCHAINITEMTP.BKCHNPAYTMETHSUPLMNTFOREDIT == T042F.UZAWE` `I_BANKCHAINITEMTP.BKCHNPAYMENTMETHODSUPPLEMENT == T042F.UZAWE` `I_BANKCHAINITEMTP.MANDT == T042F.MANDT`