GL_JE_HEADERS

-- ============================================================
-- Table  : GL_JE_HEADERS — Journal headers — one row per journal within a batch, carrying ledger, source, category, period, posting status, and control totals; where every subledger's accounting lands
-- Purpose: Column-selected read of GL_JE_HEADERS — auto-generated from field metadata
-- Grain  : One row per JE_HEADER_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.JE_HEADER_ID AS "Surrogate key of the journal",
  t.LEDGER_ID AS "The ledger — the partition that matters here (no operating-unit striping)",
  t.JE_BATCH_ID AS "The journal batch (batch table not cataloged)",
  t.NAME AS "Journal name — unique within the batch",
  t.JE_SOURCE AS "Where the journal came from — the subledger source name",
  t.JE_CATEGORY AS "The journal category",
  t.PERIOD_NAME AS "The accounting period",
  t.STATUS AS "U unposted, P posted (per the data dictionary); other single characters are error states",
  t.ACTUAL_FLAG AS "Actuals vs budget vs encumbrance — filter 'A' for actuals",
  t.CURRENCY_CODE AS "Journal currency",
  t.DEFAULT_EFFECTIVE_DATE AS "The journal's effective date — the primary analysis date",
  t.POSTED_DATE AS "When the journal posted",
  t.ACCRUAL_REV_FLAG AS "Whether the journal auto-reverses",
  t.REVERSED_JE_HEADER_ID AS "The reversing journal, once reversed",
  t.RUNNING_TOTAL_DR AS "Control total of entered debits",
  t.RUNNING_TOTAL_CR AS "Control total of entered credits"
FROM <catalog>.<schema>.GL_JE_HEADERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.JE_HEADER_ID = <JE_HEADER_ID>
  -- AND t.DEFAULT_EFFECTIVE_DATE >= DATE '<DATE_FROM>'
  -- AND t.DEFAULT_EFFECTIVE_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.JE_HEADER_ID;