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_INVOICE_LINES_ALL

Product:	AP - Payables
Description:	AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
Implementation/DBA Data:	AP.AP_INVOICE_LINES_ALL

Primary Key: AIL_PK

INVOICE_ID
LINE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_INVOICE_LINES_ALL	AP_INVOICES_ALL	AP_INVOICE_LINES_ALL.INVOICE_ID
AP_INVOICE_LINES_ALL	AP_INVOICES_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID
AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID2 AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER
AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID3 AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER2
AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID4 AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER3
AP_INVOICE_LINES_ALL	AP_INVOICES_ALL	AP_INVOICE_LINES_ALL.INVOICE_ID
AP_INVOICE_LINES_ALL	PO_LINE_LOCATIONS_ALL	AP_INVOICE_LINES_ALL.PO_LINE_LOCATION_ID
AP_INVOICE_LINES_ALL	RCV_SHIPMENT_LINES	AP_INVOICE_LINES_ALL.RCV_SHIPMENT_LINE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
JAI_AP_INVOICE_LINES	AP_INVOICE_LINES_ALL	JAI_AP_INVOICE_LINES.INVOICE_ID JAI_AP_INVOICE_LINES.INVOICE_LINE_NUMBER