WMSLocation

-- ============================================================
-- Table  : WMSLocation Warehouse location (bin) master — one row per storage location within a warehouse, with its aisle/rack/level coordinates, zone, profile, and capacity limits
-- Purpose: Column-selected read of WMSLocation — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + wMSLocationId + 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
  w.wmslocationid AS "The location (bin) code within the warehouse — referenced by InventDim.wMSLocationId",
  w.inventlocationid AS "Warehouse the location belongs to — locations are unique per warehouse, so joins need both columns",
  w.locationtype AS "What the location is used for (picking, bulk, inbound/outbound dock…)",  -- enum: decode w.locationtype via GlobalOptionsetMetadata join — see quirks guide #enums
  w.zoneid AS "Warehouse zone the location is grouped into for work and location directives",
  w.locprofileid AS "Location profile controlling mixing, license-plate tracking, and capacity behavior",
  w.aisleid AS "Aisle the location sits in",
  w.rack AS "Rack coordinate within the aisle",
  w.level AS "Level (shelf height) coordinate of the location",
  w.position AS "Position coordinate within the rack and level",
  w.sortcode AS "Sort code driving the picking route sequence through the warehouse",
  w.checktext AS "Check text a worker confirms to prove they are at the right location",
  w.inputblockingcauseid AS "Blocking cause preventing put-away into the location, when set",
  w.outputblockingcauseid AS "Blocking cause preventing picking from the location, when set",
  w.maxvolume AS "Maximum volume the location can hold",
  w.maxweight AS "Maximum weight the location can hold",
  w.volume AS "Calculated volume of the location from its physical dimensions",
  w.lastcountedutcdatetime AS "When the location was last cycle counted, stored in UTC"  -- stored in UTC
FROM <catalog>.<schema>.wmslocation w
WHERE
  w.dataareaid = '<company>'
  -- AND w.inventlocationid = '<InventLocationId>'
ORDER BY w.wmslocationid;