InventDim

-- ============================================================
-- Table  : InventDim The inventory dimension hub — one row per unique combination of site, warehouse, location, batch, and serial that every stock quantity hangs off by InventDimId
-- Purpose: Column-selected read of InventDim — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + inventDimId
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  id.inventdimid AS "The key that identifies one unique combination of inventory dimensions; every stock quantity carries it",
  id.inventsiteid AS "Site (the highest inventory dimension) for the combination",
  id.inventlocationid AS "Warehouse for the combination",
  id.wmslocationid AS "Storage location (bin) within the warehouse",
  id.inventbatchid AS "Batch number for batch-tracked items",
  id.configid AS "Product configuration for the combination",
  id.inventserialid AS "Serial number for serial-tracked items",
  id.inventstatusid AS "Inventory status (available, blocked…) used by warehouse management",
  id.licenseplateid AS "License plate (pallet/container id) holding the stock, in WMS-enabled warehouses",
  id.inventcolorid AS "Color product dimension of the combination",
  id.inventsizeid AS "Size product dimension of the combination",
  id.inventstyleid AS "Style product dimension of the combination",
  id.inventversionid AS "Version product dimension of the combination",
  id.inventdimension1 AS "Custom inventory dimension slot 1 (unused unless activated in the deployment)",
  id.inventdimension2 AS "Custom inventory dimension slot 2",
  id.inventdimension3 AS "Custom inventory dimension slot 3",
  id.inventdimension4 AS "Custom inventory dimension slot 4",
  id.inventdimension5 AS "Custom inventory dimension slot 5",
  id.inventdimension6 AS "Custom inventory dimension slot 6",
  id.inventdimension7 AS "Custom inventory dimension slot 7",
  id.inventdimension8 AS "Custom inventory dimension slot 8",
  id.inventdimension9 AS "Custom inventory dimension slot 9 (the CDM schema types this slot as a date)",
  id.inventdimension10 AS "Custom inventory dimension slot 10 (the CDM schema types this slot as a decimal)",
  id.inventdimension11 AS "Custom inventory dimension slot 11",
  id.inventdimension12 AS "Custom inventory dimension slot 12"
FROM <catalog>.<schema>.inventdim id
WHERE
  id.dataareaid = '<company>'
ORDER BY id.inventdimid;