AP_INVOICES_ALL

-- ============================================================
-- Table  : AP_INVOICES_ALL — Payables invoice headers — one row per supplier invoice, prepayment, or credit/debit memo, with the supplier, invoice number, amounts, payment status, and approval state; business-unit striped
-- Purpose: Column-selected read of AP_INVOICES_ALL — auto-generated from field metadata
-- Grain  : One row per business unit (ORG_ID) + INVOICE_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.INVOICE_ID AS "Surrogate key of the invoice — the join column, not the invoice number",
  t.ORG_ID AS "The business unit owning the invoice",
  t.INVOICE_NUM AS "Supplier invoice number — unique per supplier + BU (+ party), database-enforced in Fusion",
  t.INVOICE_DATE AS "Invoice date",
  t.VENDOR_ID AS "Supplier",
  t.VENDOR_SITE_ID AS "Supplier site — carries no documented FK in the dictionary, so no site edge ships",
  t.PARTY_ID AS "The invoicing TCA party",
  t.INVOICE_TYPE_LOOKUP_CODE AS "Invoice category (standard, credit memo, prepayment…) — no value list in the dictionary",
  t.SOURCE AS "The feeder system the invoice arrived from",
  t.INVOICE_AMOUNT AS "Invoice amount in transaction currency",
  t.AMOUNT_PAID AS "Amount paid against the invoice",
  t.INVOICE_CURRENCY_CODE AS "Invoice currency",
  t.PAYMENT_STATUS_FLAG AS "Y paid, N unpaid, P partially paid — page-documented trio",
  t.WFAPPROVAL_STATUS AS "Invoice approval-workflow status — values not enumerated in the dictionary",
  t.GL_DATE AS "Accounting date defaulted to the distributions",
  t.TERMS_ID AS "Payment terms",
  t.ACCTS_PAY_CODE_COMBINATION_ID AS "The AP liability account (CCID)",
  t.SET_OF_BOOKS_ID AS "The LEDGER — the legacy column name survives in Fusion AP, re-pointed at the ledger master"
FROM <catalog>.<schema>.AP_INVOICES_ALL t
WHERE
  t.ORG_ID = <business_unit_id>  -- business unit — Fusion _ALL means BU, not the EBS operating unit; see quirks guide #all-means-bu
  -- AND t.INVOICE_ID = <INVOICE_ID>
  -- AND t.INVOICE_DATE >= DATE '<DATE_FROM>'
  -- AND t.INVOICE_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.INVOICE_ID;