GL_JE_LINES

-- ============================================================
-- Table  : GL_JE_LINES — Journal lines — the atomic debit/credit rows against account combinations; the source of trial-balance and account-activity analytics
-- Purpose: Column-selected read of GL_JE_LINES — auto-generated from field metadata
-- Grain  : One row per JE_HEADER_ID + JE_LINE_NUM
-- Caution: Meaningless unfiltered — constrain LEDGER_ID, PERIOD_NAME, posted status, and the header's actuals flag, or budgets, encumbrances, unposted work, and secondary ledgers inflate every total; amounts are DR/CR column pairs, never signed
-- 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 "The journal — key together with the line number; no surrogate exists",
  t.JE_LINE_NUM AS "Line number within the journal — part of the key",
  t.LEDGER_ID AS "The ledger, denormalized onto every line — always filter it",
  t.CODE_COMBINATION_ID AS "The account combination the line hits",
  t.PERIOD_NAME AS "The accounting period — always filter it",
  t.EFFECTIVE_DATE AS "The line's effective date — the primary analysis date",
  t.STATUS AS "U unposted, P posted",
  t.ENTERED_DR AS "Entered debit — one side per line; use NVL when netting",
  t.ENTERED_CR AS "Entered credit",
  t.ACCOUNTED_DR AS "Debit in the ledger currency — SUM(DR) − SUM(CR) at your grain for net activity",
  t.ACCOUNTED_CR AS "Credit in the ledger currency",
  t.DESCRIPTION AS "Line description",
  t.GL_SL_LINK_ID AS "The subledger-accounting drill link",
  t.GL_SL_LINK_TABLE AS "Which subledger table the drill link resolves against",
  t.TAX_LINE_FLAG AS "Marks tax lines"
FROM <catalog>.<schema>.GL_JE_LINES 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.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>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.JE_HEADER_ID;