Results for “cancelled_amount”

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

Overview

JL_BR_AP_CONSOLID_INVOICES_ALL is a table owned by the JL schema within the Latin America Localizations product family. It stores detailed Brazilian consolidated invoice records — a localization construct that groups multiple supplier transactions into a single fiscal document for reporting and tax compliance purposes in Brazilian Payables operations. The table is documented as VALID in Oracle EBS 12.1.1 and 12.2.2 and currently contains 39 columns.

From a Data Vault modeling perspective, the FK structure suggests this object behaves as a link table: it connects independent dimensions such as vendors, vendor sites, sets of books, and currencies into a single transactional association. It does not function solely as a descriptive satellite, because its rows bind together references to external master entities while also carrying its own transactional attributes.

Key Information Stored

The primary key of the table is the surrogate CONSOLIDATED_INVOICE_ID, enforced by the unique index JL_BR_AP_CONS_INVOICES_PK. A second unique index, JL_BR_AP_CONSOLID_INVOICES_U1, also covers CONSOLIDATED_INVOICE_ID, confirming it as the sole business-key candidate documented for this object.

• VENDOR_ID — foreign key to PO_VENDORS, identifying the supplier.
• VENDOR_SITE_ID — foreign key to PO_VENDOR_SITES_ALL, identifying the supplier site.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS_11I, tying the record to a ledger.
• INVOICE_CURRENCY_CODE — foreign key to FND_CURRENCIES, defining the transaction currency.
• INVOICE_NUM — the supplier-facing invoice number for the consolidated document.
• INVOICE_AMOUNT and AMOUNT_APPLICABLE_TO_DISCOUNT — monetary values for the consolidated total and discountable portion.
• INVOICE_DATE, TERMS_DATE, and TERMS_ID — dating and payment-term attributes.
• CANCELLED_DATE, CANCELLED_BY, and CANCELLED_AMOUNT — audit fields for cancellation handling.
• PAY_GROUP_LOOKUP_CODE and PAY_GROUP_FLAG — payment grouping attributes.
• ORG_ID — multi-org operating unit identifier.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS DFF flexfield columns.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical usage revolves around Brazilian fiscal reporting, payment grouping, and reconciliation of supplier accounts against consolidated documents. A simple lookup by supplier and period is common:

SELECT consolidated_invoice_id, invoice_num, invoice_amount, invoice_date
FROM jl.jl_br_ap_consolid_invoices_all
WHERE vendor_id = :p_vendor_id
AND invoice_date BETWEEN :p_from AND :p_to;

Joining to PO_VENDORS and PO_VENDOR_SITES_ALL produces supplier-level reporting, while joining to FND_CURRENCIES supports currency-aware aggregation. Filtering on ORG_ID is essential in multi-org environments, and excluding rows where CANCELLED_DATE is not null is a standard practice for active-document reporting.

Related Objects

• PO_VENDORS — joined on VENDOR_ID.
• PO_VENDOR_SITES_ALL — joined on VENDOR_SITE_ID.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID.
• FND_CURRENCIES — joined on INVOICE_CURRENCY_CODE.
• AP_INVOICES_ALL — the standard Payables invoice repository, commonly correlated through supplier and period attributes for reconciliation.
• JL_BR_AP_CONSOLID_INVOICE_LINES — the child detail table holding the individual invoice lines consolidated into each header record.