AR_PAYMENT_SCHEDULES_ALL

-- ============================================================
-- Table  : AR_PAYMENT_SCHEDULES_ALL — The open-receivables engine — one row per transaction installment AND one row per receipt, carrying original and remaining amounts, due date, and closure state; what aging, DSO, and collections analytics read
-- Purpose: Column-selected read of AR_PAYMENT_SCHEDULES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + PAYMENT_SCHEDULE_ID
-- Caution: Transactions AND receipts both write rows here, with opposite signs (debits positive, credits and receipts negative), and split terms produce several installments per transaction — filter CLASS before aging AR
-- 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.PAYMENT_SCHEDULE_ID AS "Surrogate key of the schedule row",
  t.ORG_ID AS "Operating unit",
  t.CUSTOMER_TRX_ID AS "The transaction — populated on transaction rows, NULL on receipt rows",
  t.CASH_RECEIPT_ID AS "The receipt — populated on receipt rows",
  t.CUSTOMER_ID AS "The customer account",
  t.CUSTOMER_SITE_USE_ID AS "The bill-to site use",
  t.CLASS AS "Row kind — INV, DM, GUAR, CM, DEP, CB, PMT, BR (per the data dictionary's enumeration); PMT rows are receipts",
  t.STATUS AS "OP while open, CL once the remaining amount reaches zero",
  t.DUE_DATE AS "When the installment falls due — the aging date",
  t.TRX_DATE AS "The transaction date, denormalized",
  t.TRX_NUMBER AS "The document number, denormalized",
  t.AMOUNT_DUE_ORIGINAL AS "Original amount — debits positive, credits and receipts NEGATIVE (the sign convention)",
  t.AMOUNT_DUE_REMAINING AS "The open amount — stored, not arithmetic; what aging sums",
  t.AMOUNT_APPLIED AS "Amount applied to date",
  t.TERMS_SEQUENCE_NUMBER AS "The installment number — split terms produce several rows per transaction",
  t.INVOICE_CURRENCY_CODE AS "Currency of the amounts",
  t.GL_DATE AS "The accounting date",
  t.ACTUAL_DATE_CLOSED AS "When the row actually closed"
FROM <catalog>.<schema>.AR_PAYMENT_SCHEDULES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.PAYMENT_SCHEDULE_ID = <PAYMENT_SCHEDULE_ID>
  -- AND t.DUE_DATE >= DATE '<DATE_FROM>'
  -- AND t.DUE_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.PAYMENT_SCHEDULE_ID;