FND Design Data [Home] [Help]

Table: XTR_BANK_ACCOUNTS

Product: XTR - Treasury
Description: Bank account information
Implementation/DBA Data: TableXTR.XTR_BANK_ACCOUNTS
Primary Key: XTR_BANK_ACCOUNTS_PK
  1. ColumnACCOUNT_NUMBER
  2. ColumnPARTY_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
XTR_BANK_ACCOUNTS FK Joins to TableGL_CODE_COMBINATIONS XTR_BANK_ACCOUNTS.CODE_COMBINATION_ID
XTR_BANK_ACCOUNTS FK Joins to TableHZ_PARTIES XTR_BANK_ACCOUNTS.BANK_BRANCH_ID
XTR_BANK_ACCOUNTS FK Joins to TableHZ_PARTIES XTR_BANK_ACCOUNTS.BANK_ACCT_USE_ID
XTR_BANK_ACCOUNTS FK Joins to TableCE_CASHPOOLS XTR_BANK_ACCOUNTS.CASHPOOL_ID
XTR_BANK_ACCOUNTS FK Joins to TableGL_CODE_COMBINATIONS XTR_BANK_ACCOUNTS.PARTY_INT_CCID
XTR_BANK_ACCOUNTS FK Joins to TableGL_CODE_COMBINATIONS XTR_BANK_ACCOUNTS.PARTY_PRIN_CCID
XTR_BANK_ACCOUNTS FK Joins to TableXTR_MASTER_CURRENCIES XTR_BANK_ACCOUNTS.CURRENCY
XTR_BANK_ACCOUNTS FK Joins to TableXTR_PARTY_INFO XTR_BANK_ACCOUNTS.PARTY_CODE
TableXTR_BANK_BALANCES FK Joins to XTR_BANK_ACCOUNTS XTR_BANK_BALANCES.ACCOUNT_NUMBER
XTR_BANK_BALANCES.COMPANY_CODE
TableXTR_BANK_BAL_INTERFACE FK Joins to XTR_BANK_ACCOUNTS XTR_BANK_BAL_INTERFACE.ACCOUNT_NO
XTR_BANK_BAL_INTERFACE.COMPANY_CODE
TableXTR_DEALS FK Joins to XTR_BANK_ACCOUNTS XTR_DEALS.BUY_ACCOUNT_NO
XTR_DEALS.COMPANY_CODE
TableXTR_DEALS FK Joins to XTR_BANK_ACCOUNTS XTR_DEALS.SELL_ACCOUNT_NO
XTR_DEALS.COMPANY_CODE
TableXTR_DEALS FK Joins to XTR_BANK_ACCOUNTS XTR_DEALS.MATURITY_ACCOUNT_NO
XTR_DEALS.COMPANY_CODE
TableXTR_DEALS FK Joins to XTR_BANK_ACCOUNTS XTR_DEALS.PREMIUM_ACCOUNT_NO
XTR_DEALS.COMPANY_CODE
TableXTR_DEALS FK Joins to XTR_BANK_ACCOUNTS XTR_DEALS.SETTLE_ACCOUNT_NO
XTR_DEALS.COMPANY_CODE
TableXTR_DEALS FK Joins to XTR_BANK_ACCOUNTS XTR_DEALS.START_ACCOUNT_NO
XTR_DEALS.COMPANY_CODE
TableXTR_DEAL_DATE_AMOUNTS FK Joins to XTR_BANK_ACCOUNTS XTR_DEAL_DATE_AMOUNTS.ACCOUNT_NO
XTR_DEAL_DATE_AMOUNTS.CPARTY_CODE
TableXTR_INTEREST_RATE_RANGES FK Joins to XTR_BANK_ACCOUNTS XTR_INTEREST_RATE_RANGES.REF_CODE
XTR_INTEREST_RATE_RANGES.PARTY_CODE
TableXTR_SOURCE_OF_IMPORTS FK Joins to XTR_BANK_ACCOUNTS XTR_SOURCE_OF_IMPORTS.ACCOUNT_NUMBER
XTR_SOURCE_OF_IMPORTS.COMPANY_CODE