F0901

-- ============================================================
-- Table  : F0901 Chart of accounts master: one row per account with its business unit, object, and subsidiary segments, posting controls, and reporting category codes.
-- Purpose: Column-selected read of F0901 — auto-generated from field metadata
-- Grain  : One row per GMAID
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  f.GMAID AS "System-assigned account ID; the stable join key to F0902 balances and F0911 detail.",
  f.GMCO AS "Company that owns the account.",
  TRIM(f.GMMCU) AS "Business unit segment of the account (right-justified in the database).",
  f.GMOBJ AS "Object account segment (the natural account).",
  f.GMSUB AS "Subsidiary segment providing further detail below the object.",
  f.GMANS AS "Alternate (third) account number format.",
  f.GMDL01 AS "Account description.",
  f.GMLDA AS "Level of detail (1-9) placing the account in the rollup hierarchy.",
  f.GMBPC AS "Budget pattern code controlling budget spreads.",
  f.GMPEC AS "Posting edit code: controls whether and how the account accepts postings (header, detail, inactive).",
  f.GMBILL AS "Flag marking the account as billable for job/service billing.",
  f.GMCRCD AS "Currency restriction on the account, when used.",
  f.GMUM AS "Unit of measure for unit ledger postings to the account.",
  f.GMR001 AS "Account category code 1 (alternate rollups/statutory charts).",
  f.GMR002 AS "Account category code 2.",
  f.GMR003 AS "Account category code 3.",
  f.GMR004 AS "Account category code 4.",
  f.GMR005 AS "Account category code 5.",
  f.GMR006 AS "Account category code 6.",
  f.GMR007 AS "Account category code 7.",
  f.GMR008 AS "Account category code 8.",
  f.GMR009 AS "Account category code 9.",
  f.GMR010 AS "Account category code 10.",
  f.GMOBJA AS "Alternate object account for statutory reporting.",
  f.GMSUBA AS "Alternate subsidiary for statutory reporting.",
  f.GMHTC AS "Header type code distinguishing title/rollup rows.",
  f.GMFMOD AS "Flags model accounts and consolidation accounts.",
  f.GMTXA1 AS "Default tax rate/area tied to the account."
FROM <catalog>.<schema_data>.f0901 f
ORDER BY f.GMAID;