Results for “ap_invoice_lines_interface”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_INVOICE_LINES_INTERFACE is a Payables module interface table in the AP schema. It stores the line-level information that the Payables Invoice Import program (APXIIMPT) consumes to create one or more invoice distributions. Each row represents a single invoice line destined to become one or more rows in AP_INVOICE_DISTRIBUTIONS_ALL, with the header-level context supplied by the companion AP_INVOICE_INTERFACE table. Because the table holds pre-validated, transient staging data rather than durable master data, the heuristic Data Vault classification mined from its foreign-key structure is satellite-leaning; from a modeling perspective it is best treated as a satellite attached to the invoice import process, retaining descriptive and foreign-key context rather than acting as a hub or link in its own right.

Key Information Stored

The documented physical schema for 12.2.2 comprises 185 columns, of which the most operationally significant are summarized below.

• INVOICE_LINE_ID — the surrogate primary key and the sole documented unique-index business-key candidate (AP_INVOICE_LINES_INTERFACE_U1). It is the value that must be referenced when writing dependent rows such as tax lines.
• INVOICE_ID — links the line to its parent header row in AP_INVOICE_INTERFACE.
• LINE_NUMBER, LINE_TYPE_LOOKUP_CODE, LINE_GROUP_NUMBER, AMOUNT, DESCRIPTION — the core line identity and value attributes.
• PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID, PO_NUMBER, PO_LINE_NUMBER, RCV_TRANSACTION_ID, RECEIPT_NUMBER, MATCH_OPTION — the matching and receipt context needed for purchase-order and receipt-matched invoices.
• DIST_CODE_CONCATENATED, DIST_CODE_COMBINATION_ID, DISTRIBUTION_SET_ID — charge-account derivation inputs.
• TAX_CODE, TAX_RATE, TAX_RATE_ID, TAX_REGIME_CODE, TAX_JURISDICTION_CODE, TAXABLE_FLAG, TAX_RECOVERABLE_FLAG — E-Business Tax determinants and results.
• PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE, PA_ADDITION_FLAG — Projects costing attributes.
• AWT_GROUP_ID, PAY_AWT_GROUP_ID — withholding tax group assignment.
• CREDIT_CARD_TRX_ID, AWARD_ID, SOURCE_TRX_ID — foreign-key references described under Related Objects.

Common Use Cases and Queries

The primary use case is verifying exactly what Invoice Import will process prior to submission. Because rows are deleted after successful import, the table is a live staging area and is commonly queried for pre-import validation and error diagnosis.

• Reconciling staged lines against the parent header: SELECT l.invoice_id, l.line_number, l.amount FROM ap.ap_invoice_lines_interface l WHERE l.invoice_id = :p_invoice_id ORDER BY l.line_number;
• Confirming that distribution amounts sum to the header total, joining to AP_INVOICE_INTERFACE on INVOICE_ID.
• Auditing tax defaults by selecting TAX_CODE, TAX_RATE, and TAXABLE_FLAG to compare against the expected regime before import.
• Detecting unmatched or partially matched lines via MATCH_OPTION, RCV_TRANSACTION_ID, and RECEIPT_NUMBER.
• Extracting PO-matched invoice populations by joining PO_HEADER_ID and PO_LINE_ID to PO_HEADERS_ALL and PO_LINES_ALL.

Related Objects

The documented foreign keys and intra-interface dependencies identify the following significant relationships.

• AP_INVOICE_INTERFACE — parent header table, joined on INVOICE_ID.
• AP_INVOICE_DISTRIBUTIONS_ALL — target table populated during import; correlated through the generated INVOICE_ID and line lineage.
• AP_CREDIT_CARD_TRXNS_ALL — referenced via CREDIT_CARD_TRX_ID for credit-card invoice lines.
• PO_RELEASES_ALL — referenced via PO_RELEASE_ID, with RELEASE_NUM carried alongside.
• FTE_INVOICE_LINES — referenced via INVOICE_LINE_ID for freight and special-charge processing.
• IGF_AW_AWARD_ALL — referenced via AWARD_ID for grants-related invoices.
• IGI_DOS_TRX_SOURCES — referenced via SOURCE_TRX_ID for international trade transaction sourcing.
• AP_INVOICE_IMPORT / APXIIMPT — the concurrent program that consumes these rows and creates invoice distributions.