RA_CUSTOMER_TRX_ALL

-- ============================================================
-- Table  : RA_CUSTOMER_TRX_ALL — Receivables transaction headers — invoices, credit and debit memos, chargebacks, and deposits share the table, classified by transaction type; the revenue-document anchor of order-to-cash
-- Purpose: Column-selected read of RA_CUSTOMER_TRX_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + CUSTOMER_TRX_ID
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. 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.CUSTOMER_TRX_ID AS "Surrogate key of the transaction — the join key; the display number is not unique alone",
  t.ORG_ID AS "Operating unit",
  t.TRX_NUMBER AS "The document number users see — unique only per batch source",
  t.TRX_DATE AS "The invoice date — the primary analysis date",
  t.CUST_TRX_TYPE_ID AS "The transaction type — invoice vs credit memo vs debit memo classification (type table not cataloged)",
  t.BATCH_SOURCE_ID AS "The batch source the document arrived through",
  t.COMPLETE_FLAG AS "Y once the document is complete — filter incomplete documents out of revenue",
  t.BILL_TO_CUSTOMER_ID AS "The bill-to customer ACCOUNT (TCA id)",
  t.BILL_TO_SITE_USE_ID AS "The bill-to site use",
  t.SHIP_TO_CUSTOMER_ID AS "The ship-to customer account",
  t.SHIP_TO_SITE_USE_ID AS "The ship-to site use",
  t.INVOICE_CURRENCY_CODE AS "Document currency",
  t.EXCHANGE_RATE AS "Currency conversion rate",
  t.TERM_ID AS "Payment terms on the document",
  t.TERM_DUE_DATE AS "Due date from the terms",
  t.PURCHASE_ORDER AS "The customer's PO reference — free text",
  t.PREVIOUS_CUSTOMER_TRX_ID AS "For credit memos, the credited transaction",
  t.INTERFACE_HEADER_CONTEXT AS "AutoInvoice source context — which feeder wrote the document; attribute semantics are source-defined"
FROM <catalog>.<schema>.RA_CUSTOMER_TRX_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.CUSTOMER_TRX_ID = <CUSTOMER_TRX_ID>
  -- AND t.TRX_DATE >= DATE '<DATE_FROM>'
  -- AND t.TRX_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CUSTOMER_TRX_ID;