FGLEDG

-- ============================================================
-- Table  : FGLEDG — The general ledger — one row per voucher line, with the accounting date, accounting-dimension string, and amounts; the voucher is identified by division, fiscal year, voucher series, and voucher number, and carries one or more lines below that key; every subledger posting lands here
-- Purpose: Column-selected read of FGLEDG — auto-generated from field metadata
-- Grain  : Transaction-grain — finer than company (CONO) + EGDIVI + EGYEA4 + EGVSER + EGVONO; the full row key is not yet cataloged (see the table description)
-- Notes  : Auto-generated skeleton for a prefixed physical M3 schema or a landing schema normalized to the prefixed names in this catalog. Raw Data Lake property names vary with the published object: map them through Data Catalog before running this SQL. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); all curated status values are decoded inline. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  f.EGCONO AS "Company",
  f.EGDIVI AS "Division the voucher posted in",
  f.EGYEA4 AS "Fiscal year",
  f.EGVSER AS "Voucher number series",
  f.EGVONO AS "Voucher number",
  f.EGJRNO AS "Journal number",
  CASE WHEN f.EGACDT = 0 THEN NULL ELSE TO_DATE(CAST(CAST(f.EGACDT AS BIGINT) AS STRING), 'yyyyMMdd') END AS "Accounting date",  -- YYYYMMDD, 0 → NULL
  f.EGAIT1 AS "Accounting dimension 1 — the account, first of the seven accounting dimensions; dimensions 2–7 below carry the configurable analysis slices",
  f.EGACAM AS "Amount in local currency, signed",
  f.EGCUAM AS "Amount in transaction currency, signed",
  f.EGAIT2 AS "Accounting dimension 2 — one of the six configurable analysis slices alongside the account (AIT1)",
  f.EGAIT3 AS "Accounting dimension 3 — configurable analysis slice",
  f.EGAIT4 AS "Accounting dimension 4 — configurable analysis slice",
  f.EGAIT5 AS "Accounting dimension 5 — configurable analysis slice",
  f.EGAIT6 AS "Accounting dimension 6 — configurable analysis slice",
  f.EGAIT7 AS "Accounting dimension 7 — configurable analysis slice"
FROM <catalog>.<schema>.FGLEDG f
WHERE
  f.EGCONO = <company>
  -- AND f.EGDIVI = '<DIVI>'
  -- AND f.EGACDT >= <DATE_FROM>  -- yyyyMMdd numeric
  -- AND f.EGACDT <= <DATE_TO>  -- yyyyMMdd numeric
ORDER BY f.EGYEA4;