F1201

-- ============================================================
-- Table  : F1201 Asset master: one row per fixed asset or piece of equipment with its company, responsible business unit, classification codes, account mapping, and acquisition/disposal dates.
-- Purpose: Column-selected read of F1201 — auto-generated from field metadata
-- Grain  : One row per FANUMB
-- 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.FANUMB AS "Asset item number — the internal short key every F1202 balance row points at",
  f.FACO AS "Company that owns the asset",
  f.FAAPID AS "Unit or tag number — the physical label identifier for the asset",
  f.FAAAID AS "Parent asset number for component/parent hierarchies",
  f.FAASID AS "Serial number of the asset",
  f.FAACL1 AS "Major accounting class — the top-level asset classification (category code 12/C1)",
  f.FAACL2 AS "Major equipment class (category code 12/C2)",
  f.FAACL3 AS "Manufacturer category code",
  f.FAACL4 AS "Model year category code",
  f.FAACL5 AS "Usage basis category code (miles or hours)",
  TRIM(f.FAMCU) AS "Responsible business unit that carries the asset",
  f.FADL01 AS "Asset description line 1",
  CASE WHEN f.FADAJ IS NULL OR f.FADAJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.FADAJ AS INT) DIV 1000, 1, 1), CAST(f.FADAJ AS INT) % 1000 - 1) END AS "Acquisition date",  -- CYYDDD Julian → DATE
  CASE WHEN f.FADSP IS NULL OR f.FADSP = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.FADSP AS INT) DIV 1000, 1, 1), CAST(f.FADSP AS INT) % 1000 - 1) END AS "Disposal or retirement date; blank while the asset is still in service",  -- CYYDDD Julian → DATE
  f.FAEQST AS "Equipment status code (available, down, disposed, etc.)",
  f.FANORU AS "Whether the asset was new or used when acquired",
  f.FAAESV / POWER(10, 2) AS "Estimated salvage value",  -- implied decimals: 2 (verify in F9210)
  f.FAARPC / POWER(10, 2) AS "Replacement cost estimate",  -- implied decimals: 2 (verify in F9210)
  TRIM(f.FAAMCU) AS "Business unit of the asset cost account",
  f.FAAOBJ AS "Object account where asset cost is capitalized",
  f.FAASUB AS "Subsidiary of the asset cost account",
  TRIM(f.FADMCU) AS "Business unit of the accumulated depreciation account",
  f.FADOBJ AS "Object account for accumulated depreciation",
  f.FADSUB AS "Subsidiary of the accumulated depreciation account",
  TRIM(f.FAXMCU) AS "Business unit of the depreciation expense account",
  f.FAXOBJ AS "Object account for depreciation expense",
  f.FAXSUB AS "Subsidiary of the depreciation expense account",
  f.FAARCQ / POWER(10, 2) AS "Current quantity when the asset row represents multiple units",  -- implied decimals: 2 (verify in F9210)
  f.FAAROQ / POWER(10, 2) AS "Original quantity at acquisition",  -- implied decimals: 2 (verify in F9210)
  f.FAFINC AS "Financing method (owned, leased, rented)",
  f.FALANO AS "Lessor/mortgagor address number for financed assets",
  TRIM(f.FALOC) AS "Current location business unit of the asset",
  f.FAAN8 AS "Address book number associated with the asset (e.g. assigned employee or operator)",
  f.FAACL0 AS "Category code F/A 10, conventionally the depreciation rate group",
  f.FAUNIT AS "Unit number cross-reference to the responsible business unit",
  f.FAWRFL AS "Warranty flag indicating active warranty coverage",
  CASE WHEN f.FAWARJ IS NULL OR f.FAWARJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.FAWARJ AS INT) DIV 1000, 1, 1), CAST(f.FAWARJ AS INT) % 1000 - 1) END AS "Warranty expiration date"  -- CYYDDD Julian → DATE
FROM <catalog>.<schema_data>.f1201 f
ORDER BY f.FANUMB;