InventLocation

-- ============================================================
-- Table  : InventLocation Warehouse master — one row per warehouse (inventory location) with its site and type
-- Purpose: Column-selected read of InventLocation — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + InventLocationId
-- 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
  loc.inventlocationid AS "The warehouse code",
  loc.inventsiteid AS "Site the warehouse belongs to",
  loc.name AS "Warehouse name",
  loc.inventlocationtype AS "Whether the warehouse is a default, quarantine, or transit location",  -- enum: decode loc.inventlocationtype via GlobalOptionsetMetadata join — see quirks guide #enums
  loc.whsenabled AS "Whether advanced warehouse management (WHS) processes run in this warehouse",  -- enum: decode loc.whsenabled via GlobalOptionsetMetadata join — see quirks guide #enums
  loc.defaultstatusid AS "Default inventory status applied to receipts in this warehouse",
  loc.inventlocationidquarantine AS "Quarantine warehouse paired with this one",
  loc.inventlocationidtransit AS "Transit warehouse used for transfer orders shipping from this one",
  loc.inventlocationidreqmain AS "Main warehouse this one is refilled from in master planning",
  loc.reqrefill AS "Whether master planning refills this warehouse from its main warehouse",  -- enum: decode loc.reqrefill via GlobalOptionsetMetadata join — see quirks guide #enums
  loc.manual AS "Whether items in this warehouse are planned manually rather than by master planning",  -- enum: decode loc.manual via GlobalOptionsetMetadata join — see quirks guide #enums
  loc.reqcalendarid AS "Working-time calendar master planning uses for this warehouse",
  loc.inventlocationlevel AS "Level of the warehouse in a multi-level refill hierarchy",
  loc.vendaccount AS "Vendor account, for externally located (vendor-managed) warehouses",
  loc.branchnumber AS "Branch number used by localizations that report warehouses as branches"
FROM <catalog>.<schema>.inventlocation loc
WHERE
  loc.dataareaid = '<company>'
  -- AND loc.inventlocationid = '<InventLocationId>'
ORDER BY loc.inventlocationid;