F1202

-- ============================================================
-- Table  : F1202 Asset account balances: one row per asset, account, ledger type, subledger, and fiscal year holding the beginning balance and fourteen period net-posting buckets — the fixed-asset mirror of F0902.
-- Purpose: Column-selected read of F1202 — auto-generated from field metadata
-- Grain  : One row per FLAID + FLCTRY + FLFY + FLFQ + FLLT + FLSBL + FLNUMB + FLSBLT
-- 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.FLAID AS "Short account ID of the cost, accumulated depreciation, or expense account",
  f.FLCTRY AS "Century of the fiscal year",
  f.FLFY AS "Fiscal year of the balance row",
  f.FLFQ AS "Fiscal quarter — obsolete but still part of the primary key, normally blank",
  f.FLLT AS "Ledger type (AA actual, plus tax and alternate depreciation ledgers like D1-D9)",
  f.FLSBL AS "Subledger value, part of the key; usually blank for asset balances",
  f.FLNUMB AS "Asset item number — joins to F1201",
  f.FLSBLT AS "Subledger type qualifying the subledger value",
  f.FLCO AS "Company of the account",
  f.FLAPYC / POWER(10, 2) AS "Beginning balance carried forward from the prior-year close",  -- implied decimals: 2 (verify in F9210)
  f.FLAN01 / POWER(10, 2) AS "Net postings for period 1",  -- implied decimals: 2 (verify in F9210)
  f.FLAN02 / POWER(10, 2) AS "Net postings for period 2",  -- implied decimals: 2 (verify in F9210)
  f.FLAN03 / POWER(10, 2) AS "Net postings for period 3",  -- implied decimals: 2 (verify in F9210)
  f.FLAN04 / POWER(10, 2) AS "Net postings for period 4",  -- implied decimals: 2 (verify in F9210)
  f.FLAN05 / POWER(10, 2) AS "Net postings for period 5",  -- implied decimals: 2 (verify in F9210)
  f.FLAN06 / POWER(10, 2) AS "Net postings for period 6",  -- implied decimals: 2 (verify in F9210)
  f.FLAN07 / POWER(10, 2) AS "Net postings for period 7",  -- implied decimals: 2 (verify in F9210)
  f.FLAN08 / POWER(10, 2) AS "Net postings for period 8",  -- implied decimals: 2 (verify in F9210)
  f.FLAN09 / POWER(10, 2) AS "Net postings for period 9",  -- implied decimals: 2 (verify in F9210)
  f.FLAN10 / POWER(10, 2) AS "Net postings for period 10",  -- implied decimals: 2 (verify in F9210)
  f.FLAN11 / POWER(10, 2) AS "Net postings for period 11",  -- implied decimals: 2 (verify in F9210)
  f.FLAN12 / POWER(10, 2) AS "Net postings for period 12",  -- implied decimals: 2 (verify in F9210)
  f.FLAN13 / POWER(10, 2) AS "Net postings for period 13",  -- implied decimals: 2 (verify in F9210)
  f.FLAN14 / POWER(10, 2) AS "Net postings for period 14",  -- implied decimals: 2 (verify in F9210)
  f.FLAPYN / POWER(10, 2) AS "Prior year net postings total",  -- implied decimals: 2 (verify in F9210)
  TRIM(f.FLMCU) AS "Business unit of the account",
  f.FLOBJ AS "Object account",
  f.FLSUB AS "Subsidiary account",
  f.FLADLM AS "Depreciable life in months for this ledger",
  f.FLADM AS "Depreciation method code",
  f.FLADMP AS "Depreciation method percentage",
  CASE WHEN f.FLDSD IS NULL OR f.FLDSD = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.FLDSD AS INT) DIV 1000, 1, 1), CAST(f.FLDSD AS INT) % 1000 - 1) END AS "Date depreciation started",  -- CYYDDD Julian → DATE
  f.FLCRCD AS "Currency of the balance amounts",
  f.FLCHCD AS "Asset account type flag distinguishing cost, accumulated depreciation, and expense rows"
FROM <catalog>.<schema_data>.f1202 f
ORDER BY f.FLAID;