GL_JE_LINES

-- ============================================================
-- Table  : GL_JE_LINES — General ledger journal lines — the debit/credit grain: one row per line with the account combination, entered and accounted amounts, effective date, and the drill-back link to subledger accounting
-- Purpose: Column-selected read of GL_JE_LINES — auto-generated from field metadata
-- Grain  : One row per JE_HEADER_ID + JE_LINE_NUM
-- Caution: Amounts come in pairs — ENTERED_DR/CR in the journal currency, ACCOUNTED_DR/CR in ledger currency; pick one pair consistently and treat NULLs as zero
-- 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 "The journal — half of the composite key",
  t.JE_LINE_NUM AS "Line number — the other half of the composite key",
  t.LEDGER_ID AS "The ledger, repeated on the lines — a convenient stripe for ledger-scoped extracts",
  t.CODE_COMBINATION_ID AS "The account combination the line posts to",
  t.PERIOD_NAME AS "Accounting period",
  t.EFFECTIVE_DATE AS "Line effective date",
  t.STATUS AS "U unposted, P posted",
  t.ENTERED_DR AS "Debit in the journal's entered currency — NULL means zero",
  t.ENTERED_CR AS "Credit in entered currency",
  t.ACCOUNTED_DR AS "Debit in ledger currency — the pair balance reporting should sum",
  t.ACCOUNTED_CR AS "Credit in ledger currency",
  t.CURRENCY_CODE AS "Entered currency of the line",
  t.DESCRIPTION AS "Line description",
  t.GL_SL_LINK_ID AS "Drill-back link to subledger accounting",
  t.GL_SL_LINK_TABLE AS "Which subledger link table the drill-back goes through",
  t.STAT_AMOUNT AS "Statistical amount on the line"
FROM <catalog>.<schema>.GL_JE_LINES 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.JE_LINE_NUM = <JE_LINE_NUM>
  -- AND t.EFFECTIVE_DATE >= DATE '<DATE_FROM>'
  -- AND t.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;