Table: AP_BANK_ACCOUNTS_ALL

Product:	AP - Payables
Description:
Implementation/DBA Data:	AP.AP_BANK_ACCOUNTS_ALL

Primary Key: AP_BANK_ACCOUNTS_PK

1. BANK_ACCOUNT_ID

Primary Key: AP_BANK_ACCOUNTS_UK1

1. BANK_ACCOUNT_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
AP_BANK_ACCOUNTS_ALL		FND_CURRENCIES	AP_BANK_ACCOUNTS_ALL.CURRENCY_CODE
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.BANK_ERRORS_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.EARNED_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.UNEARNED_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.ON_ACCOUNT_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.UNAPPLIED_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.UNIDENTIFIED_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.FACTOR_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.RECEIPT_CLEARING_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.REMITTANCE_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.SHORT_TERM_DEPOSIT_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.ASSET_CODE_COMBINATION_ID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.FUTURE_DATED_PAYMENT_CCID
AP_BANK_ACCOUNTS_ALL		AR_RECEIVABLES_TRX_ALL	AP_BANK_ACCOUNTS_ALL.BR_STD_RECEIVABLES_TRX_ID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.LOSS_CODE_COMBINATION_ID
AP_BANK_ACCOUNTS_ALL		%	AP_BANK_ACCOUNTS_ALL.SET_OF_BOOKS_ID
AP_BANK_ACCOUNTS_ALL		AP_BANK_BRANCHES	AP_BANK_ACCOUNTS_ALL.BANK_BRANCH_ID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.GAIN_CODE_COMBINATION_ID
AP_BANK_ACCOUNTS_ALL		PAY_EXTERNAL_ACCOUNTS	AP_BANK_ACCOUNTS_ALL.PAYROLL_BANK_ACCOUNT_ID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.CASH_CLEARING_CCID
AP_BANK_ACCOUNTS_ALL		GL_CODE_COMBINATIONS	AP_BANK_ACCOUNTS_ALL.BANK_CHARGES_CCID
AP_BANK_ACCOUNT_USES_ALL		AP_BANK_ACCOUNTS_ALL	AP_BANK_ACCOUNT_USES_ALL.EXTERNAL_BANK_ACCOUNT_ID
AP_CHECKS_ALL		AP_BANK_ACCOUNTS_ALL	AP_CHECKS_ALL.BANK_ACCOUNT_ID
AP_CHECKS_ALL		AP_BANK_ACCOUNTS_ALL	AP_CHECKS_ALL.EXTERNAL_BANK_ACCOUNT_ID
AP_CHECK_STOCKS_ALL		AP_BANK_ACCOUNTS_ALL	AP_CHECK_STOCKS_ALL.BANK_ACCOUNT_ID
AP_HISTORY_CHECKS_ALL		AP_BANK_ACCOUNTS_ALL	AP_HISTORY_CHECKS_ALL.BANK_ACCOUNT_ID
AP_INV_SELECTION_CRITERIA_ALL		AP_BANK_ACCOUNTS_ALL	AP_INV_SELECTION_CRITERIA_ALL.BANK_ACCOUNT_ID
AP_PAYMENT_SCHEDULES_ALL		AP_BANK_ACCOUNTS_ALL	AP_PAYMENT_SCHEDULES_ALL.EXTERNAL_BANK_ACCOUNT_ID
AP_PBATCH_SET_LINES_ALL		AP_BANK_ACCOUNTS_ALL	AP_PBATCH_SET_LINES_ALL.BANK_ACCOUNT_ID
AP_RECON_CHECK_RESULTS		AP_BANK_ACCOUNTS_ALL	AP_RECON_CHECK_RESULTS.BANK_ACCOUNT_ID
AP_RECON_DETAILS		AP_BANK_ACCOUNTS_ALL	AP_RECON_DETAILS.BANK_ACCOUNT_ID
AP_RECON_LOCKS		AP_BANK_ACCOUNTS_ALL	AP_RECON_LOCKS.BANK_ACCOUNT_ID
AP_RECON_RECORD_CODES		AP_BANK_ACCOUNTS_ALL	AP_RECON_RECORD_CODES.BANK_ACCOUNT_ID
AP_RECON_RECORD_SPECS		AP_BANK_ACCOUNTS_ALL	AP_RECON_RECORD_SPECS.BANK_ACCOUNT_ID
AP_RECON_SUMMARIES		AP_BANK_ACCOUNTS_ALL	AP_RECON_SUMMARIES.BANK_ACCOUNT_ID
AP_RECON_TRANSACTION_CODES		AP_BANK_ACCOUNTS_ALL	AP_RECON_TRANSACTION_CODES.BANK_ACCOUNT_ID
AP_SELECTED_INVOICES_ALL		AP_BANK_ACCOUNTS_ALL	AP_SELECTED_INVOICES_ALL.EXTERNAL_BANK_ACCOUNT_ID
AP_SELECTED_INVOICE_CHECKS_ALL		AP_BANK_ACCOUNTS_ALL	AP_SELECTED_INVOICE_CHECKS_ALL.EXTERNAL_BANK_ACCOUNT_ID
AP_SYSTEM_PARAMETERS_ALL		AP_BANK_ACCOUNTS_ALL	AP_SYSTEM_PARAMETERS_ALL.BANK_ACCOUNT_ID
AR_AUTOREC_EXCEPTIONS		AP_BANK_ACCOUNTS_ALL	AR_AUTOREC_EXCEPTIONS.CUST_BANK_ACCT_ID
AR_AUTOREC_EXCEPTIONS		AP_BANK_ACCOUNTS_ALL	AR_AUTOREC_EXCEPTIONS.REMIT_BANK_ACCT_ID
AR_BATCHES_ALL		AP_BANK_ACCOUNTS_ALL	AR_BATCHES_ALL.REMITTANCE_BANK_ACCOUNT_ID
AR_CASH_RECEIPTS_ALL		AP_BANK_ACCOUNTS_ALL	AR_CASH_RECEIPTS_ALL.REMITTANCE_BANK_ACCOUNT_ID
AR_CC_ERROR_HISTORY		AP_BANK_ACCOUNTS_ALL	AR_CC_ERROR_HISTORY.CUSTOMER_BANK_ACCOUNT_ID
AR_INTERIM_CASH_RECEIPTS_ALL		AP_BANK_ACCOUNTS_ALL	AR_INTERIM_CASH_RECEIPTS_ALL.OLD_REMIT_BANK_ACCOUNT_ID
AR_INTERIM_CASH_RECEIPTS_ALL		AP_BANK_ACCOUNTS_ALL	AR_INTERIM_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID
%		AP_BANK_ACCOUNTS_ALL
AR_RECEIPT_METHOD_ACCOUNTS_ALL		AP_BANK_ACCOUNTS_ALL	AR_RECEIPT_METHOD_ACCOUNTS_ALL.OLD_BANK_ACCOUNT_ID
CE_ARCH_HEADERS		AP_BANK_ACCOUNTS_ALL	CE_ARCH_HEADERS.BANK_ACCOUNT_ID
CE_ARCH_HEADERS_ALL		AP_BANK_ACCOUNTS_ALL	CE_ARCH_HEADERS_ALL.BANK_ACCOUNT_ID
CE_BA_SIGNATORIES		AP_BANK_ACCOUNTS_ALL	CE_BA_SIGNATORIES.BANK_ACCOUNT_ID
CE_FORECAST_OPENING_BAL		AP_BANK_ACCOUNTS_ALL	CE_FORECAST_OPENING_BAL.BANK_ACCOUNT_ID
CE_FORECAST_ROWS		AP_BANK_ACCOUNTS_ALL	CE_FORECAST_ROWS.BANK_ACCOUNT_ID
CE_FORECAST_TRX_CELLS		AP_BANK_ACCOUNTS_ALL	CE_FORECAST_TRX_CELLS.BANK_ACCOUNT_ID
CE_JE_MAPPINGS		AP_BANK_ACCOUNTS_ALL	CE_JE_MAPPINGS.BANK_ACCOUNT_ID
CE_STATEMENT_HEADERS_ALL		AP_BANK_ACCOUNTS_ALL	CE_STATEMENT_HEADERS_ALL.BANK_ACCOUNT_ID
CE_STATEMENT_HEADERS		AP_BANK_ACCOUNTS_ALL	CE_STATEMENT_HEADERS.BANK_ACCOUNT_ID
CE_TRANSACTION_CODES		AP_BANK_ACCOUNTS_ALL	CE_TRANSACTION_CODES.BANK_ACCOUNT_ID
CE_UPG_AP_ACCTS_TMP		AP_BANK_ACCOUNTS_ALL	CE_UPG_AP_ACCTS_TMP.BANK_ACCOUNT_ID
CE_UPG_PURGE_AP_ACCTS		AP_BANK_ACCOUNTS_ALL	CE_UPG_PURGE_AP_ACCTS.BANK_ACCOUNT_ID
FV_AR_BATCHES_ALL		AP_BANK_ACCOUNTS_ALL	FV_AR_BATCHES_ALL.BANK_ACCOUNT_ID
FV_CCR_ORGS		AP_BANK_ACCOUNTS_ALL	FV_CCR_ORGS.BANK_ACCOUNT_ID
FV_INTERIM_CASH_RECEIPTS_ALL		AP_BANK_ACCOUNTS_ALL	FV_INTERIM_CASH_RECEIPTS_ALL.BANK_ACCOUNT_ID
IBE_ORD_ONECLICK		AP_BANK_ACCOUNTS_ALL	IBE_ORD_ONECLICK.PAYMENT_ID
IGS_FI_LOCKBOXES		AP_BANK_ACCOUNTS_ALL	IGS_FI_LOCKBOXES.BANK_ACCOUNT_ID
JL_BR_AR_BORDEROS_ALL		AP_BANK_ACCOUNTS_ALL	JL_BR_AR_BORDEROS_ALL.BANK_ACCOUNT_ID
JL_BR_AR_PAY_SCHED_AUX		AP_BANK_ACCOUNTS_ALL	JL_BR_AR_PAY_SCHED_AUX.BANK_ACCOUNT_ID
JL_BR_AR_SELECT_ACCOUNTS_ALL		AP_BANK_ACCOUNTS_ALL	JL_BR_AR_SELECT_ACCOUNTS_ALL.BANK_ACCOUNT_ID
RA_CUSTOMER_TRX_ALL		AP_BANK_ACCOUNTS_ALL	RA_CUSTOMER_TRX_ALL.CUSTOMER_BANK_ACCOUNT_ID
RA_CUSTOMER_TRX_ALL		AP_BANK_ACCOUNTS_ALL	RA_CUSTOMER_TRX_ALL.DRAWEE_BANK_ACCOUNT_ID
RA_CUSTOMER_TRX_ALL		AP_BANK_ACCOUNTS_ALL	RA_CUSTOMER_TRX_ALL.REMITTANCE_BANK_ACCOUNT_ID