描述:发票批次信息汇总
Primary Key: AP_BATCHES_PK
- BATCH_ID
Primary Key: AP_BATCHES_UK1
- BATCH_NAME
- BATCH_DATE
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
AP_BATCHES_ALL.INVOICE_CURRENCY_CODE | FND_CURRENCIES |
AP_BATCHES_ALL.PAYMENT_CURRENCY_CODE | FND_CURRENCIES |
AP_BATCHES_ALL.BATCH_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
Foreign Keys to this table:
Foreign Key Column | Foreign Table |
---|---|
AP_INVOICES_ALL.BATCH_ID | AP_BATCHES_ALL |
AP_BATCHES_ALL | |
AP_INVOICE_DISTRIBUTIONS_ALL.BATCH_ID | AP_BATCHES_ALL |
AP_PAYMENT_SCHEDULES_ALL.BATCH_ID | AP_BATCHES_ALL |
AP_RECURRING_PAYMENTS_ALL.BATCH_ID | AP_BATCHES_ALL |
Comments:
AP_BATCHES_ALL包含关于您批量输入的发票的摘要信息,如果您启用了“批控制应付款项”选项。您输入的每一批发票都有一行。如果您启用了批量控制,每个发票必须对应于该表中的一个记录。您的Oracle Payables应用程序使用此信息将一个人在一批中输入的发票分组在一起。