FND Design Data [Home] [Help]

Table: AP_BATCHES_ALL

Product: AP - Payables
Description: Summary invoice batch information
Implementation/DBA Data: TableAP.AP_BATCHES_ALL
Primary Key: AP_BATCHES_PK
  1. ColumnBATCH_ID
Primary Key: AP_BATCHES_UK1
  1. ColumnBATCH_NAME
  2. ColumnBATCH_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_BATCHES_ALL FK Joins to TableFND_CURRENCIES AP_BATCHES_ALL.INVOICE_CURRENCY_CODE
AP_BATCHES_ALL FK Joins to TableFND_CURRENCIES AP_BATCHES_ALL.PAYMENT_CURRENCY_CODE
AP_BATCHES_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_BATCHES_ALL.BATCH_CODE_COMBINATION_ID
TableAP_INVOICES_ALL FK Joins to AP_BATCHES_ALL AP_INVOICES_ALL.BATCH_ID
Table% FK Joins to AP_BATCHES_ALL
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_BATCHES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.BATCH_ID
TableAP_PAYMENT_SCHEDULES_ALL FK Joins to AP_BATCHES_ALL AP_PAYMENT_SCHEDULES_ALL.BATCH_ID
TableAP_RECURRING_PAYMENTS_ALL FK Joins to AP_BATCHES_ALL AP_RECURRING_PAYMENTS_ALL.BATCH_ID