F0902

-- ============================================================
-- Table  : F0902 Account balances: one row per account, ledger type, fiscal year, and subledger holding the beginning balance and fourteen period net-posting buckets.
-- Purpose: Column-selected read of F0902 — auto-generated from field metadata
-- Grain  : One row per GBAID + GBCTRY + GBFY + GBFQ + GBLT + GBSBL + GBSBLT + GBCRCD
-- 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.GBAID AS "Account ID; joins to F0901 for the account's BU.Object.Subsidiary and attributes.",
  f.GBCTRY AS "Century component of the fiscal year key.",
  f.GBFY AS "Two-digit fiscal year of the balance row.",
  f.GBFQ AS "Fiscal quarter key column (obsolete but still part of the unique key; typically blank).",
  f.GBLT AS "Ledger type (AA actual, CA foreign, BA budget, etc.); always filter on it when aggregating.",
  f.GBSBL AS "Subledger value splitting balances below the account, blank when unused.",
  f.GBSBLT AS "Type of the subledger value (address, item, work order, etc.).",
  f.GBCRCD AS "Transaction currency of the balance row; part of the key when balances are kept by currency.",
  f.GBCO AS "Company owning the account, denormalized for filtering.",
  TRIM(f.GBMCU) AS "Business unit of the account, denormalized from F0901 (right-justified).",
  f.GBOBJ AS "Object account, denormalized from F0901.",
  f.GBSUB AS "Subsidiary, denormalized from F0901.",
  f.GBAPYC / POWER(10, 2) AS "Balance brought forward from prior year-end close.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN01 / POWER(10, 2) AS "Net amount posted in period 1.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN02 / POWER(10, 2) AS "Net amount posted in period 2.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN03 / POWER(10, 2) AS "Net amount posted in period 3.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN04 / POWER(10, 2) AS "Net amount posted in period 4.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN05 / POWER(10, 2) AS "Net amount posted in period 5.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN06 / POWER(10, 2) AS "Net amount posted in period 6.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN07 / POWER(10, 2) AS "Net amount posted in period 7.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN08 / POWER(10, 2) AS "Net amount posted in period 8.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN09 / POWER(10, 2) AS "Net amount posted in period 9.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN10 / POWER(10, 2) AS "Net amount posted in period 10.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN11 / POWER(10, 2) AS "Net amount posted in period 11.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN12 / POWER(10, 2) AS "Net amount posted in period 12.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN13 / POWER(10, 2) AS "Net amount posted in period 13.",  -- implied decimals: 2 (verify in F9210)
  f.GBAN14 / POWER(10, 2) AS "Net amount posted in period 14.",  -- implied decimals: 2 (verify in F9210)
  f.GBAPYN / POWER(10, 2) AS "Total net postings for the prior year.",  -- implied decimals: 2 (verify in F9210)
  f.GBAWTD / POWER(10, 2) AS "Week-to-date posting amount.",  -- implied decimals: 2 (verify in F9210)
  f.GBBORG / POWER(10, 2) AS "Original/beginning budget amount for budget ledgers.",  -- implied decimals: 2 (verify in F9210)
  f.GBPOU / POWER(10, 2) AS "Cumulative memo budget change amount.",  -- implied decimals: 2 (verify in F9210)
  f.GBTKER / POWER(10, 2) AS "Cumulative memo commitment change amount.",  -- implied decimals: 2 (verify in F9210)
  f.GBBREQ / POWER(10, 2) AS "Requested budget amount.",  -- implied decimals: 2 (verify in F9210)
  f.GBBAPR / POWER(10, 2) AS "Approved budget amount.",  -- implied decimals: 2 (verify in F9210)
  f.GBCRCX AS "Currency the stored amounts are denominated in."
FROM <catalog>.<schema_data>.f0902 f
ORDER BY f.GBAID;