P1201

-- ============================================================
-- Program: P1201 Asset Master Information — the screen where fixed assets are created and maintained: descriptions, responsible business unit, category codes, and account coding.
-- Purpose: Asset Master Information — the screen where fixed assets are created and maintained: descriptions, responsible business unit, category codes, and account coding. — auto-generated boilerplate from program-table-map
-- Grain  : F1201 × F1202, F0101 — 1:N joins yield one row per detail line
-- Tables : F1201, F1202, F0101
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). 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
  h.FANUMB AS "Asset item number — the internal short key every F1202 balance row points at",
  h.FADL01 AS "Asset description line 1",
  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.FLSBLT AS "Subledger type qualifying the subledger value"
FROM <catalog>.<schema_data>.f1201 h
LEFT JOIN <catalog>.<schema_data>.f1202 f
  ON f.FLNUMB = h.FANUMB
LEFT JOIN <catalog>.<schema_data>.f0101 ab
  ON ab.ABAN8 = h.FAAN8
ORDER BY h.FANUMB;