FND Design Data [Home] [Help]

Table: AP_SELECTED_INVOICES_ALL

Product: AP - Payables
Description: Temporary storage of invoices selected for payment in a payment batch
Implementation/DBA Data: TableAP.AP_SELECTED_INVOICES_ALL
Primary Key: AP_SELECTED_INVOICES_PK
  1. ColumnCHECKRUN_NAME
  2. ColumnINVOICE_ID
  3. ColumnPAYMENT_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_SELECTED_INVOICES_ALL FK Joins to TableAP_INV_SELECTION_CRITERIA_ALL AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME
AP_SELECTED_INVOICES_ALL FK Joins to TableAP_INVOICES_ALL AP_SELECTED_INVOICES_ALL.INVOICE_ID
AP_SELECTED_INVOICES_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AP_SELECTED_INVOICES_ALL.SET_OF_BOOKS_ID
AP_SELECTED_INVOICES_ALL FK Joins to TablePO_VENDORS AP_SELECTED_INVOICES_ALL.VENDOR_ID
AP_SELECTED_INVOICES_ALL FK Joins to TablePO_VENDOR_SITES_ALL AP_SELECTED_INVOICES_ALL.VENDOR_SITE_ID
AP_SELECTED_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_SELECTED_INVOICES_ALL.AP_CCID
AP_SELECTED_INVOICES_ALL FK Joins to TableAP_SELECTED_INVOICE_CHECKS_ALL AP_SELECTED_INVOICES_ALL.PAY_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_ALL FK Joins to TableAP_SELECTED_INVOICE_CHECKS_ALL AP_SELECTED_INVOICES_ALL.PRINT_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AP_SELECTED_INVOICES_ALL.EXTERNAL_BANK_ACCOUNT_ID