FND Design Data [Home] [Help]

Table: AR_BATCHES_ALL

Product: AR - Receivables
Description: Receipt batch information
Implementation/DBA Data: TableAR.AR_BATCHES_ALL
Primary Key: AR_BATCHES_PK
  1. ColumnBATCH_ID
Primary Key: AR_BATCHES_UK1
  1. ColumnTRANSMISSION_REQUEST_ID
  2. ColumnBATCH_ID
Primary Key: AR_BATCHES_UK2
  1. ColumnBATCH_SOURCE_ID
  2. ColumnBATCH_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_BATCHES_ALL FK Joins to TableAR_BATCH_SOURCES_ALL AR_BATCHES_ALL.BATCH_SOURCE_ID
AR_BATCHES_ALL FK Joins to TableAP_BANK_BRANCHES AR_BATCHES_ALL.OLD_REMITTANCE_BANK_BRANCH_ID
AR_BATCHES_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AR_BATCHES_ALL.REMITTANCE_BANK_ACCOUNT_ID
AR_BATCHES_ALL FK Joins to TableAR_TRANSMISSIONS_ALL AR_BATCHES_ALL.TRANSMISSION_REQUEST_ID
AR_BATCHES_ALL FK Joins to TableAR_LOCKBOXES_ALL AR_BATCHES_ALL.LOCKBOX_ID
AR_BATCHES_ALL FK Joins to TableFND_CURRENCIES AR_BATCHES_ALL.CURRENCY_CODE
AR_BATCHES_ALL FK Joins to TableAP_PAYMENT_PROGRAMS AR_BATCHES_ALL.AUTO_PRINT_PROGRAM_ID
AR_BATCHES_ALL FK Joins to TableAP_PAYMENT_PROGRAMS AR_BATCHES_ALL.AUTO_TRANS_PROGRAM_ID
AR_BATCHES_ALL FK Joins to TableCE_BANK_ACCT_USES_ALL AR_BATCHES_ALL.REMIT_BANK_ACCT_USE_ID
TableAR_ADJUSTMENTS_ALL FK Joins to AR_BATCHES_ALL AR_ADJUSTMENTS_ALL.BATCH_ID
TableAR_AUTOREC_EXCEPTIONS FK Joins to AR_BATCHES_ALL AR_AUTOREC_EXCEPTIONS.BATCH_ID
TableAR_CASH_RECEIPTS_ALL FK Joins to AR_BATCHES_ALL AR_CASH_RECEIPTS_ALL.SELECTED_REMITTANCE_BATCH_ID
TableAR_CASH_RECEIPT_HISTORY_ALL FK Joins to AR_BATCHES_ALL AR_CASH_RECEIPT_HISTORY_ALL.BATCH_ID
TableAR_INTERIM_CASH_RECEIPTS_ALL FK Joins to AR_BATCHES_ALL AR_INTERIM_CASH_RECEIPTS_ALL.BATCH_ID
TableAR_INTERIM_CASH_RCPT_LINES_ALL FK Joins to AR_BATCHES_ALL AR_INTERIM_CASH_RCPT_LINES_ALL.BATCH_ID
TableAR_MC_BATCHES FK Joins to AR_BATCHES_ALL AR_MC_BATCHES.BATCH_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to AR_BATCHES_ALL AR_PAYMENT_SCHEDULES_ALL.SELECTED_FOR_RECEIPT_BATCH_ID
TableFV_AR_BATCHES_ALL FK Joins to AR_BATCHES_ALL FV_AR_BATCHES_ALL.BATCH_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to AR_BATCHES_ALL RA_CUSTOMER_TRX_ALL.REMITTANCE_BATCH_ID