GL_JE_HEADERS

-- ============================================================
-- Table  : GL_JE_HEADERS — General ledger journal headers — one row per journal within a batch, with the ledger, category, source, period, currency, posting status, and running debit/credit totals
-- 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 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.JE_HEADER_ID AS "Surrogate key of the journal",
  t.LEDGER_ID AS "The ledger — GL's stripe; there is no ORG_ID in the GL layer",
  t.JE_BATCH_ID AS "The journal batch (batch table not cataloged)",
  t.NAME AS "Journal name",
  t.PERIOD_NAME AS "Accounting period",
  t.JE_CATEGORY AS "Journal category — what kind of transaction the journal represents",
  t.JE_SOURCE AS "Journal source — where the journal came from (Payables, Receivables, Manual…)",
  t.STATUS AS "U unposted, P posted — plus documented error codes; no named lookup type",
  t.ACTUAL_FLAG AS "Balance type — actual, budget, or encumbrance; filter it or totals mix",
  t.CURRENCY_CODE AS "Journal currency",
  t.DEFAULT_EFFECTIVE_DATE AS "Default effective date for the journal's lines",
  t.POSTED_DATE AS "When the journal posted",
  t.RUNNING_TOTAL_ACCOUNTED_DR AS "Journal debit total in ledger currency",
  t.RUNNING_TOTAL_ACCOUNTED_CR AS "Journal credit total in ledger currency",
  t.REVERSED_JE_HEADER_ID AS "The journal this one reverses (self-referencing)",
  t.JE_FROM_SLA_FLAG AS "Whether the journal arrived from subledger accounting"
FROM <catalog>.<schema>.GL_JE_HEADERS t
WHERE
  t.LEDGER_ID = <LEDGER_ID>  -- ledger — the GL stripe; no ORG_ID exists in the GL layer; one ledger or currencies mix
  -- 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>'  -- the column incremental BICC extracts key on
ORDER BY t.JE_HEADER_ID;