GL_CODE_COMBINATIONS

-- ============================================================
-- Table  : GL_CODE_COMBINATIONS — Every chart-of-accounts segment combination (CCID) stored once — the account string behind each SEGMENTn set; accounting distributions and journal lines reference accounts through CODE_COMBINATION_ID
-- Purpose: Column-selected read of GL_CODE_COMBINATIONS — auto-generated from field metadata
-- Grain  : One row per CODE_COMBINATION_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.CODE_COMBINATION_ID AS "The CCID — the surrogate key every accounting distribution and journal line carries",
  t.CHART_OF_ACCOUNTS_ID AS "The chart of accounts this combination belongs to — segment meaning is defined per chart",
  t.ACCOUNT_TYPE AS "Asset, liability, equity, revenue, or expense — from the natural-account segment",
  t.ENABLED_FLAG AS "Whether the combination is active",
  t.SUMMARY_FLAG AS "Whether this is a summary (rollup) account rather than a detail account",
  t.DETAIL_POSTING_ALLOWED_FLAG AS "Whether journals may post to the combination directly",
  t.FINANCIAL_CATEGORY AS "Financial-statement category tag on the combination",
  t.DESCRIPTION AS "Description of the combination — on the base table in Fusion, unlike EBS",
  t.CONCATENATED_SEGMENTS AS "The full delimited account string — ready-made, no segment concatenation needed",
  t.START_DATE_ACTIVE AS "Effectivity start date",
  t.END_DATE_ACTIVE AS "Effectivity end date",
  t.SEGMENT1 AS "Accounting flexfield segment 1 — meaning depends on the chart's configuration",  -- flexfield segment: concatenation is configuration-defined
  t.SEGMENT2 AS "Accounting flexfield segment 2",  -- flexfield segment: concatenation is configuration-defined
  t.SEGMENT3 AS "Accounting flexfield segment 3",  -- flexfield segment: concatenation is configuration-defined
  t.SEGMENT4 AS "Accounting flexfield segment 4",  -- flexfield segment: concatenation is configuration-defined
  t.SEGMENT5 AS "Accounting flexfield segment 5",  -- flexfield segment: concatenation is configuration-defined
  t.SEGMENT6 AS "Accounting flexfield segment 6 (SEGMENT7–30 exist physically; catalog shows the first six)"  -- flexfield segment: concatenation is configuration-defined
FROM <catalog>.<schema>.GL_CODE_COMBINATIONS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.CODE_COMBINATION_ID = <CODE_COMBINATION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.CODE_COMBINATION_ID;