描述:在一批付款中选择用于付款的发票的临时存放
Primary Key: AP_SELECTED_INVOICES_PK
- CHECKRUN_NAME
- INVOICE_ID
- PAYMENT_NUM
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_SELECTED_INVOICES_ALL.INVOICE_ID | AP_INVOICES_ALL |
AP_SELECTED_INVOICES_ALL.SET_OF_BOOKS_ID | % |
AP_SELECTED_INVOICES_ALL.VENDOR_ID | PO_VENDORS |
AP_SELECTED_INVOICES_ALL.VENDOR_SITE_ID | PO_VENDOR_SITES_ALL |
AP_SELECTED_INVOICES_ALL.AP_CCID | GL_CODE_COMBINATIONS |
AP_SELECTED_INVOICES_ALL.PAY_SELECTED_CHECK_ID | AP_SELECTED_INVOICE_CHECKS_ALL |
AP_SELECTED_INVOICES_ALL.PRINT_SELECTED_CHECK_ID | AP_SELECTED_INVOICE_CHECKS_ALL |
AP_SELECTED_INVOICES_ALL.EXTERNAL_BANK_ACCOUNT_ID | AP_BANK_ACCOUNTS_ALL |
Comments:
AP_SELECTED_INVOICES_ALL是一个临时表,它存储关于在支付批处理中为支付选择的发票的信息。您的Oracle Payables应用程序在您启动支付批处理后插入到该表。在当前付款批次中,Payables为付款选择的每个发票都将有一行。当您在付款批处理中构建付款时,您的Oracle Payables应用程序使用该表中的信息在AP_SELECTED_INVOICE_CHECKS中创建行。