Table: AR_BATCHES_ALL

Product:	AR - Receivables
Description:	Receipt batch information
Implementation/DBA Data:	AR.AR_BATCHES_ALL

Primary Key: AR_BATCHES_PK

1. BATCH_ID

Primary Key: AR_BATCHES_UK1

1. TRANSMISSION_REQUEST_ID
2. BATCH_ID

Primary Key: AR_BATCHES_UK2

1. BATCH_SOURCE_ID
2. BATCH_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AR_BATCHES_ALL		AR_BATCH_SOURCES_ALL	AR_BATCHES_ALL.BATCH_SOURCE_ID
AR_BATCHES_ALL		AP_BANK_BRANCHES	AR_BATCHES_ALL.OLD_REMITTANCE_BANK_BRANCH_ID
AR_BATCHES_ALL		AP_BANK_ACCOUNTS_ALL	AR_BATCHES_ALL.REMITTANCE_BANK_ACCOUNT_ID
AR_BATCHES_ALL		AR_TRANSMISSIONS_ALL	AR_BATCHES_ALL.TRANSMISSION_REQUEST_ID
AR_BATCHES_ALL		AR_LOCKBOXES_ALL	AR_BATCHES_ALL.LOCKBOX_ID
AR_BATCHES_ALL		FND_CURRENCIES	AR_BATCHES_ALL.CURRENCY_CODE
AR_BATCHES_ALL		AP_PAYMENT_PROGRAMS	AR_BATCHES_ALL.AUTO_PRINT_PROGRAM_ID
AR_BATCHES_ALL		AP_PAYMENT_PROGRAMS	AR_BATCHES_ALL.AUTO_TRANS_PROGRAM_ID
AR_BATCHES_ALL		CE_BANK_ACCT_USES_ALL	AR_BATCHES_ALL.REMIT_BANK_ACCT_USE_ID
AR_ADJUSTMENTS_ALL		AR_BATCHES_ALL	AR_ADJUSTMENTS_ALL.BATCH_ID
AR_AUTOREC_EXCEPTIONS		AR_BATCHES_ALL	AR_AUTOREC_EXCEPTIONS.BATCH_ID
AR_CASH_RECEIPTS_ALL		AR_BATCHES_ALL	AR_CASH_RECEIPTS_ALL.SELECTED_REMITTANCE_BATCH_ID
AR_CASH_RECEIPT_HISTORY_ALL		AR_BATCHES_ALL	AR_CASH_RECEIPT_HISTORY_ALL.BATCH_ID
AR_INTERIM_CASH_RECEIPTS_ALL		AR_BATCHES_ALL	AR_INTERIM_CASH_RECEIPTS_ALL.BATCH_ID
AR_INTERIM_CASH_RCPT_LINES_ALL		AR_BATCHES_ALL	AR_INTERIM_CASH_RCPT_LINES_ALL.BATCH_ID
AR_MC_BATCHES		AR_BATCHES_ALL	AR_MC_BATCHES.BATCH_ID
AR_PAYMENT_SCHEDULES_ALL		AR_BATCHES_ALL	AR_PAYMENT_SCHEDULES_ALL.SELECTED_FOR_RECEIPT_BATCH_ID
FV_AR_BATCHES_ALL		AR_BATCHES_ALL	FV_AR_BATCHES_ALL.BATCH_ID
RA_CUSTOMER_TRX_ALL		AR_BATCHES_ALL	RA_CUSTOMER_TRX_ALL.REMITTANCE_BATCH_ID