FND Design Data [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: TableAP.AP_INVOICE_LINES_ALL
Primary Key: AIL_PK
  1. ColumnINVOICE_ID
  2. ColumnLINE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_INVOICE_LINES_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_LINES_ALL.INVOICE_ID
AP_INVOICE_LINES_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID
AP_INVOICE_LINES_ALL FK Joins to TableAP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID2
AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER
AP_INVOICE_LINES_ALL FK Joins to TableAP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID3
AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER2
AP_INVOICE_LINES_ALL FK Joins to TableAP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID4
AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER3
AP_INVOICE_LINES_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_LINES_ALL.INVOICE_ID
AP_INVOICE_LINES_ALL FK Joins to TablePO_LINE_LOCATIONS_ALL AP_INVOICE_LINES_ALL.PO_LINE_LOCATION_ID
AP_INVOICE_LINES_ALL FK Joins to TableRCV_SHIPMENT_LINES AP_INVOICE_LINES_ALL.RCV_SHIPMENT_LINE_ID
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_INVOICE_LINES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
TableJAI_AP_INVOICE_LINES FK Joins to AP_INVOICE_LINES_ALL JAI_AP_INVOICE_LINES.INVOICE_ID
JAI_AP_INVOICE_LINES.INVOICE_LINE_NUMBER