AR_CASH_RECEIPTS_ALL

-- ============================================================
-- Table  : AR_CASH_RECEIPTS_ALL — Cash receipts — one row per receipt entered, with receipt number, date, amount, status, and the paying customer account; the cash side that payment schedules apply against
-- Purpose: Column-selected read of AR_CASH_RECEIPTS_ALL — auto-generated from field metadata
-- Grain  : One row per business unit (ORG_ID) + CASH_RECEIPT_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.CASH_RECEIPT_ID AS "Surrogate key of the receipt",
  t.ORG_ID AS "The business unit owning the receipt",
  t.RECEIPT_NUMBER AS "Receipt number",
  t.RECEIPT_DATE AS "Receipt date",
  t.AMOUNT AS "Receipt amount — denormalized here for query convenience",
  t.CURRENCY_CODE AS "Receipt currency",
  t.STATUS AS "APP, UNAPP, UNID, NSF, REV, or STOP — page-enumerated, no named lookup type",
  t.TYPE AS "CASH or MISC — the dictionary itself says filter on MISC, not CASH",
  t.PAY_FROM_CUSTOMER AS "The paying customer account — an id column without the _ID suffix",
  t.CUSTOMER_SITE_USE_ID AS "The customer site use the receipt is tied to",
  t.RECEIPT_METHOD_ID AS "Receipt method",
  t.EXCHANGE_RATE AS "Conversion rate to the ledger currency",
  t.REVERSAL_DATE AS "When the receipt was reversed",
  t.REVERSAL_CATEGORY AS "System category of the reversal",
  t.LEGAL_ENTITY_ID AS "Legal entity receiving the receipt"
FROM <catalog>.<schema>.AR_CASH_RECEIPTS_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.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>'  -- the column incremental BICC extracts key on
ORDER BY t.CASH_RECEIPT_ID;