Text Description of the Invoice Line Table

The INVLINE table describes how DTD data elements in Invoice Line map to open interface tables. The invoice line header element (%AMOUNT.TOTAL.T;) contains the elements VALUE, NUMOFDEC, SIGN, CURRENCY, and DRCR that map to AP_INVOICES_LINES_INTERFACE.AMOUNT. The invoice header line element (%OPERAMT.UNIT.T;) contains the elements VALUE, NUMOFDEC, SIGN, CURRENCY, UOMVALUE, UOMNUMDEC, and UOM that map to AP_INVOICE_LINES_INTERFACE.UNIT_PRICE. The invoice header line element (%QUANTITY.ITEM;) contains the elements VALUE, NUMOFDEC, SIGN, and UOM that map to AP_INVOICE_LINES_INTERFACE.QUANTITY_INVOICED. The invoice header line element LINENUM maps to AP_INVOICE_LINES_INTERFACE.LINE_NUMBER. The invoice header line element DESCRIPTN maps to AP_INVOICE_LINES_INTERFACE.ITEM_DESCRIPTION. The invoice header line element ITEM maps to AP_INVOICE_LINES_INTERFACE.VENDOR_ITEM_NUMBER. The invoice header line element DOCUMNTREF contains the following four elements that are mapped to separate interface tables:

  1. DOCUMENTID maps to AP_INVOICE_LINES_INTERFACE.PO_NUMBER.

  2. DOCUMENTRF? maps to AP_INVOICE_LINES_INTERFACE.RELEASE_NUM.

  3. LINENUM? maps to AP_INVOICE_LINES_INTERFACE.PO_LINE_NUMBER.

  4. SCHLINENUM? maps to AP_INVOICE_LINES_INTERFACE.PO_SHIPMENT_NUM.