Table: AP_BANK_BRANCHES

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

Primary Key: AP_BANK_BRANCHES_PK

1. BANK_BRANCH_ID

Primary Key: AP_BANK_BRANCHES_UK1

1. BANK_NUM

Primary Key: AP_BANK_BRANCHES_UK2

1. BANK_NAME
2. BANK_BRANCH_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
AP_BANK_BRANCHES		AP_BANK_BRANCHES	AP_BANK_BRANCHES.CLEARING_HOUSE_ID
AP_BANK_BRANCHES		AP_PAYMENT_PROGRAMS	AP_BANK_BRANCHES.TRANSMISSION_PROGRAM_ID
AP_BANK_BRANCHES		AP_PAYMENT_PROGRAMS	AP_BANK_BRANCHES.PRINTING_PROGRAM_ID
AP_BANK_BRANCHES		ECE_TP_HEADERS	AP_BANK_BRANCHES.TP_HEADER_ID
AP_BANK_BRANCHES		PAY_EXTERNAL_ACCOUNTS	AP_BANK_BRANCHES.PAYROLL_BANK_ACCOUNT_ID
AP_BANK_ACCOUNTS_ALL		AP_BANK_BRANCHES	AP_BANK_ACCOUNTS_ALL.BANK_BRANCH_ID
AP_BANK_BRANCHES		AP_BANK_BRANCHES	AP_BANK_BRANCHES.CLEARING_HOUSE_ID
AP_BANK_CHARGES		AP_BANK_BRANCHES	AP_BANK_CHARGES.TRANSFERRING_BANK_BRANCH_ID
AP_BANK_CHARGES		AP_BANK_BRANCHES	AP_BANK_CHARGES.RECEIVING_BANK_BRANCH_ID
AP_BANK_TRANSMISSIONS		AP_BANK_BRANCHES	AP_BANK_TRANSMISSIONS.BANK_BRANCH_ID
AP_TRANSMISSIONS_SETUP		AP_BANK_BRANCHES	AP_TRANSMISSIONS_SETUP.BANK_BRANCH_ID
AR_BATCHES_ALL		AP_BANK_BRANCHES	AR_BATCHES_ALL.OLD_REMITTANCE_BANK_BRANCH_ID
AR_CASH_RECEIPTS_ALL		AP_BANK_BRANCHES	AR_CASH_RECEIPTS_ALL.OLD_CUSTOMER_BANK_BRANCH_ID
AR_CASH_RECEIPTS_ALL		AP_BANK_BRANCHES	AR_CASH_RECEIPTS_ALL.OLD_ISSUER_BANK_BRANCH_ID
AR_INTERIM_CASH_RECEIPTS_ALL		AP_BANK_BRANCHES	AR_INTERIM_CASH_RECEIPTS_ALL.OLD_CUSTOMER_BANK_BRANCH_ID
CE_UPG_AP_BANKS_TMP		AP_BANK_BRANCHES	CE_UPG_AP_BANKS_TMP.BANK_BRANCH_ID
CE_UPG_PURGE_AP_BANKS		AP_BANK_BRANCHES	CE_UPG_PURGE_AP_BANKS.BANK_BRANCH_ID
JL_BR_AP_COLLECTION_DOCS_ALL		AP_BANK_BRANCHES	JL_BR_AP_COLLECTION_DOCS_ALL.BANK_BRANCH_ID
POS_ACCT_ADDR_REL		AP_BANK_BRANCHES	POS_ACCT_ADDR_REL.BANK_BRANCH_ID
POS_SUP_BANK_ACCOUNT_REQUESTS		AP_BANK_BRANCHES	POS_SUP_BANK_ACCOUNT_REQUESTS.BANK_BRANCH_ID