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 Infor Data Lake-landed M3 data. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); status ladders decoded inline where verified. 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; dimensions 2–7 carry the configurable analysis slices",
  f.EGACAM AS "Amount in local currency, signed",
  f.EGCUAM AS "Amount in transaction currency, signed"
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;