AR_CASH_RECEIPTS_ALL

-- ============================================================
-- Table  : AR_CASH_RECEIPTS_ALL — Cash receipts — one row per customer or miscellaneous receipt with amount, date, status, and reversal detail; application detail against invoices lives in companion tables
-- Purpose: Column-selected read of AR_CASH_RECEIPTS_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + CASH_RECEIPT_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.CASH_RECEIPT_ID AS "Surrogate key of the receipt",
  t.ORG_ID AS "Operating unit",
  t.RECEIPT_NUMBER AS "The receipt number users see — not unique",
  t.AMOUNT AS "Receipt amount",
  t.RECEIPT_DATE AS "When the receipt was taken — the primary analysis date",
  t.PAY_FROM_CUSTOMER AS "The paying customer ACCOUNT id — despite the name",
  t.CUSTOMER_SITE_USE_ID AS "The customer site use",
  t.STATUS AS "APP, UNAPP, UNID, NSF, REV, or STOP (per the data dictionary's comment) — receipt-level state that lags application detail",
  t.TYPE AS "CASH or MISC — exclude MISC from customer-cash analytics",
  t.CURRENCY_CODE AS "Receipt currency",
  t.EXCHANGE_RATE AS "Currency conversion rate",
  t.RECEIPT_METHOD_ID AS "The receipt method",
  t.REVERSAL_DATE AS "When the receipt was reversed — NULL if never",
  t.REVERSAL_CATEGORY AS "Why the receipt was reversed"
FROM <catalog>.<schema>.AR_CASH_RECEIPTS_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.CASH_RECEIPT_ID = <CASH_RECEIPT_ID>
  -- AND t.RECEIPT_DATE >= DATE '<DATE_FROM>'
  -- AND t.RECEIPT_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.CASH_RECEIPT_ID;