GL_LEDGERS

-- ============================================================
-- Table  : GL_LEDGERS — One row per ledger — currency, calendar, chart of accounts, and accounting convention; the ledger context business units and subledgers resolve to
-- Purpose: Column-selected read of GL_LEDGERS — auto-generated from field metadata
-- Grain  : One row per LEDGER_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.LEDGER_ID AS "Surrogate key of the ledger — what business units and subledgers point at",
  t.NAME AS "Ledger name (unique)",
  t.SHORT_NAME AS "Ledger short name (unique)",
  t.DESCRIPTION AS "Ledger description",
  t.OBJECT_TYPE_CODE AS "Ledger vs ledger-set discriminator — filter it or ledger counts inflate",
  t.LEDGER_CATEGORY_CODE AS "Primary, secondary, or reporting-currency ledger — filter to primary for most analytics",
  t.LE_LEDGER_TYPE_CODE AS "Legal vs management ledger",
  t.CURRENCY_CODE AS "The ledger currency",
  t.CHART_OF_ACCOUNTS_ID AS "The chart of accounts (accounting flexfield structure) the ledger posts against",
  t.PERIOD_SET_NAME AS "The accounting calendar the ledger runs on",
  t.ACCOUNTED_PERIOD_TYPE AS "Which period type within the calendar the ledger accounts in",
  t.SLA_ACCOUNTING_METHOD_CODE AS "Subledger accounting method the ledger uses",
  t.COMPLETION_STATUS_CODE AS "Setup completion status of the ledger",
  t.RET_EARN_CODE_COMBINATION_ID AS "Retained earnings account — joins the code combinations table"
FROM <catalog>.<schema>.GL_LEDGERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.LEDGER_ID = <LEDGER_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.LEDGER_ID;