eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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:	AP.AP_SELECTED_INVOICES_ALL

Primary Key: AP_SELECTED_INVOICES_PK

CHECKRUN_NAME
INVOICE_ID
PAYMENT_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_SELECTED_INVOICES_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME
AP_SELECTED_INVOICES_ALL	AP_INVOICES_ALL	AP_SELECTED_INVOICES_ALL.INVOICE_ID
AP_SELECTED_INVOICES_ALL	GL_SETS_OF_BOOKS_11I	AP_SELECTED_INVOICES_ALL.SET_OF_BOOKS_ID
AP_SELECTED_INVOICES_ALL	PO_VENDORS	AP_SELECTED_INVOICES_ALL.VENDOR_ID
AP_SELECTED_INVOICES_ALL	PO_VENDOR_SITES_ALL	AP_SELECTED_INVOICES_ALL.VENDOR_SITE_ID
AP_SELECTED_INVOICES_ALL	GL_CODE_COMBINATIONS	AP_SELECTED_INVOICES_ALL.AP_CCID
AP_SELECTED_INVOICES_ALL	AP_SELECTED_INVOICE_CHECKS_ALL	AP_SELECTED_INVOICES_ALL.PAY_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_ALL	AP_SELECTED_INVOICE_CHECKS_ALL	AP_SELECTED_INVOICES_ALL.PRINT_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_ALL	AP_BANK_ACCOUNTS_ALL	AP_SELECTED_INVOICES_ALL.EXTERNAL_BANK_ACCOUNT_ID