eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: CE_BANK_ACCT_USES_ALL

Product:	CE - Cash Management
Description:	This table stores information about your bank account uses.
Implementation/DBA Data:	CE.CE_BANK_ACCT_USES_ALL

Primary Key: CE_BANK_ACCT_USES_U1

BANK_ACCT_USE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
CE_BANK_ACCT_USES_ALL	CE_BANK_ACCOUNTS	CE_BANK_ACCT_USES_ALL.BANK_ACCOUNT_ID
CE_BANK_ACCT_USES_ALL	HR_ALL_ORGANIZATION_UNITS	CE_BANK_ACCT_USES_ALL.ORG_ID
CE_BANK_ACCT_USES_ALL	HZ_PARTIES	CE_BANK_ACCT_USES_ALL.ORG_PARTY_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.EDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.UNEDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.BR_STD_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	CE_BANK_ACCOUNTS	CE_BANK_ACCT_USES_ALL.BANK_ACCOUNT_ID
CE_BANK_ACCT_USES_ALL	HR_ALL_ORGANIZATION_UNITS	CE_BANK_ACCT_USES_ALL.ORG_ID
CE_BANK_ACCT_USES_ALL	HZ_PARTIES	CE_BANK_ACCT_USES_ALL.ORG_PARTY_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.EDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.UNEDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.BR_STD_RECEIVABLES_TRX_ID
AP_CHECKS_ALL	CE_BANK_ACCT_USES_ALL	AP_CHECKS_ALL.CE_BANK_ACCT_USE_ID
AP_HISTORY_CHECKS_ALL	CE_BANK_ACCT_USES_ALL	AP_HISTORY_CHECKS_ALL.CE_BANK_ACCT_USE_ID
AP_SYSTEM_PARAMETERS_ALL	CE_BANK_ACCT_USES_ALL	AP_SYSTEM_PARAMETERS_ALL.CE_BANK_ACCT_USE_ID
AR_AUTOREC_EXCEPTIONS	CE_BANK_ACCT_USES_ALL	AR_AUTOREC_EXCEPTIONS.REMIT_BANK_ACCT_USE_ID
AR_BATCHES_ALL	CE_BANK_ACCT_USES_ALL	AR_BATCHES_ALL.REMIT_BANK_ACCT_USE_ID
AR_BATCH_SOURCES_ALL	CE_BANK_ACCT_USES_ALL	AR_BATCH_SOURCES_ALL.REMIT_BANK_ACCT_USE_ID
AR_CASH_RECEIPTS_ALL	CE_BANK_ACCT_USES_ALL	AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID
CE_GL_ACCOUNTS_CCID	CE_BANK_ACCT_USES_ALL	CE_GL_ACCOUNTS_CCID.BANK_ACCT_USE_ID
FV_AR_BATCHES_ALL	CE_BANK_ACCT_USES_ALL	FV_AR_BATCHES_ALL.CE_BANK_ACCT_USE_ID
FV_INTERIM_CASH_RECEIPTS_ALL	CE_BANK_ACCT_USES_ALL	FV_INTERIM_CASH_RECEIPTS_ALL.CE_BANK_ACCT_USE_ID
JAI_CMN_RG_PLA_TRXS	CE_BANK_ACCT_USES_ALL	JAI_CMN_RG_PLA_TRXS.BANK_BRANCH_ID
JL_BR_AR_BORDEROS_ALL	CE_BANK_ACCT_USES_ALL	JL_BR_AR_BORDEROS_ALL.BANK_ACCT_USE_ID
JL_BR_AR_COLLECTION_DOCS_ALL	CE_BANK_ACCT_USES_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.BANK_ACCT_USE_ID
JL_BR_AR_PAY_SCHED_AUX	CE_BANK_ACCT_USES_ALL	JL_BR_AR_PAY_SCHED_AUX.BANK_ACCT_USE_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL	CE_BANK_ACCT_USES_ALL	JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BANK_ACCT_USE_ID
JL_BR_AR_SELECT_ACCOUNTS_ALL	CE_BANK_ACCT_USES_ALL	JL_BR_AR_SELECT_ACCOUNTS_ALL.BANK_ACCT_USE_ID
RA_CUSTOMER_TRX_ALL	CE_BANK_ACCT_USES_ALL	RA_CUSTOMER_TRX_ALL.REMIT_BANK_ACCT_USE_ID
XTR_ACCOUNT_DEBIT_AUTHS	CE_BANK_ACCT_USES_ALL	XTR_ACCOUNT_DEBIT_AUTHS.BANK_ACCT_USE_ID
XTR_BANK_BALANCES	CE_BANK_ACCT_USES_ALL	XTR_BANK_BALANCES.BANK_ACCT_USE_ID
XTR_BANK_BAL_INTERFACE	CE_BANK_ACCT_USES_ALL	XTR_BANK_BAL_INTERFACE.BANK_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.BUY_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.SELL_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.MATURITY_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.PREMIUM_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.SELL_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.START_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.CPARTY_ACCT_USE_ID
XTR_DEALS	CE_BANK_ACCT_USES_ALL	XTR_DEALS.CLIENT_ACCT_USE_ID
XTR_DEALS_INTERFACE	CE_BANK_ACCT_USES_ALL	XTR_DEALS_INTERFACE.COMPANY_ACCT_A_USE_ID
XTR_DEALS_INTERFACE	CE_BANK_ACCT_USES_ALL	XTR_DEALS_INTERFACE.COMPANY_ACCT_B_USE_ID
XTR_DEALS_INTERFACE	CE_BANK_ACCT_USES_ALL	XTR_DEALS_INTERFACE.CPARTY_ACCT_USE_ID
XTR_DEAL_DATE_AMOUNTS	CE_BANK_ACCT_USES_ALL	XTR_DEAL_DATE_AMOUNTS.COMPANY_ACCT_USE_ID
XTR_DEAL_DATE_AMOUNTS	CE_BANK_ACCT_USES_ALL	XTR_DEAL_DATE_AMOUNTS.CPARTY_ACCT_USE_ID
XTR_DEAL_DATE_AMOUNTS	CE_BANK_ACCT_USES_ALL	XTR_DEAL_DATE_AMOUNTS.BENEFECIARY_ACCT_USE_ID
XTR_EXPOSURE_TRANSACTIONS	CE_BANK_ACCT_USES_ALL	XTR_EXPOSURE_TRANSACTIONS.COMPANY_ACCT_USE_ID
XTR_EXPOSURE_TRANSACTIONS	CE_BANK_ACCT_USES_ALL	XTR_EXPOSURE_TRANSACTIONS.CPARTY_ACCT_USE_ID
XTR_EXT_IMPORT_INTERFACE	CE_BANK_ACCT_USES_ALL	XTR_EXT_IMPORT_INTERFACE.BANK_ACCT_USE_ID
XTR_IG_JOURNAL_STRUCTURES	CE_BANK_ACCT_USES_ALL	XTR_IG_JOURNAL_STRUCTURES.CPARTY_ACCT_USE_ID
XTR_IMPORT_TRAILER_DETAILS	CE_BANK_ACCT_USES_ALL	XTR_IMPORT_TRAILER_DETAILS.BANK_ACCT_USE_ID
XTR_INTEREST_RATE_RANGES	CE_BANK_ACCT_USES_ALL	XTR_INTEREST_RATE_RANGES.BANK_ACCT_USE_ID
XTR_INTERGROUP_TRANSFERS	CE_BANK_ACCT_USES_ALL	XTR_INTERGROUP_TRANSFERS.COMPANY_ACCT_USE_ID
XTR_INTERGROUP_TRANSFERS	CE_BANK_ACCT_USES_ALL	XTR_INTERGROUP_TRANSFERS.CPARTY_ACCT_USE_ID
XTR_MIRROR_DDA_LIMIT_ROW	CE_BANK_ACCT_USES_ALL	XTR_MIRROR_DDA_LIMIT_ROW.BANK_ACCT_USE_ID
XTR_MIRROR_DDA_LIM_ROW_TMP	CE_BANK_ACCT_USES_ALL	XTR_MIRROR_DDA_LIM_ROW_TMP.BANK_ACCT_USE_ID
XTR_POSITION_HISTORY	CE_BANK_ACCT_USES_ALL	XTR_POSITION_HISTORY.BANK_ACCT_USE_ID
XTR_REVALUATION_DETAILS	CE_BANK_ACCT_USES_ALL	XTR_REVALUATION_DETAILS.BANK_ACCT_USE_ID
XTR_ROLLOVER_TRANSACTIONS	CE_BANK_ACCT_USES_ALL	XTR_ROLLOVER_TRANSACTIONS.ACCUM_INT_ACCT_USE_ID
XTR_ROLLOVER_TRANSACTIONS	CE_BANK_ACCT_USES_ALL	XTR_ROLLOVER_TRANSACTIONS.BAL_OS_ACCT_USE_ID
XTR_ROLLOVER_TRANSACTIONS	CE_BANK_ACCT_USES_ALL	XTR_ROLLOVER_TRANSACTIONS.PRINCIPAL_ACCT_USE_ID
XTR_SETTLEMENT_CONTACTS	CE_BANK_ACCT_USES_ALL	XTR_SETTLEMENT_CONTACTS.BANK_ACCT_USE_ID
XTR_SETTLEMENT_SUMMARY	CE_BANK_ACCT_USES_ALL	XTR_SETTLEMENT_SUMMARY.COMPANY_ACCT_USE_ID
XTR_SETTLEMENT_SUMMARY	CE_BANK_ACCT_USES_ALL	XTR_SETTLEMENT_SUMMARY.CPARTY_ACCT_USE_ID
XTR_SOURCE_OF_IMPORTS	CE_BANK_ACCT_USES_ALL	XTR_SOURCE_OF_IMPORTS.BANK_ACCT_USE_ID
XTR_STANDING_INSTRUCTIONS	CE_BANK_ACCT_USES_ALL	XTR_STANDING_INSTRUCTIONS.BANK_ACCT_USE_ID