WHSLoadTable

-- ============================================================
-- Table  : WHSLoadTable Warehouse load header — one row per load (a truck, trailer, or container worth of goods); shipments are grouped onto loads, and ship confirmation happens at this level
-- Purpose: Column-selected read of WHSLoadTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + LoadId
-- 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.loadid AS "The load number — the natural key shipments and load lines join on",
  w.loadstatus AS "Load status across its life cycle (open, in process, shipped…)",  -- enum: decode w.loadstatus via GlobalOptionsetMetadata join — see quirks guide #enums
  w.loaddirection AS "Whether the load is outbound or inbound",  -- enum: decode w.loaddirection via GlobalOptionsetMetadata join — see quirks guide #enums
  w.inventsiteid AS "Site the load ships from or arrives at",
  w.inventlocationid AS "Warehouse the load ships from or arrives at",
  w.carriercode AS "Carrier assigned to the load",
  w.carrierservicecode AS "Carrier service level for the load",
  w.modecode AS "Transportation mode of the load",
  w.loadtemplateid AS "Load template (equipment type / capacity profile) the load was built with",
  w.trailernumber AS "Trailer assigned to the load",
  w.loadweight AS "Total weight on the load",
  w.loadshipconfirmutcdatetime AS "When the load was ship-confirmed, stored in UTC — the outbound completion timestamp",  -- stored in UTC
  w.loadschedshiputcdatetime AS "Scheduled ship datetime for the load, stored in UTC — compare to the confirm timestamp for schedule adherence",  -- stored in UTC
  w.loadarrivalutcdatetime AS "Planned arrival datetime of the load, stored in UTC",  -- stored in UTC
  w.accountnum AS "Customer or vendor account behind a single-order load, depending on direction",
  w.ordernum AS "Source order number for a single-order load",
  w.billofladingid AS "Master bill of lading for the load"
FROM <catalog>.<schema>.whsloadtable w
WHERE
  w.dataareaid = '<company>'
  -- AND w.loadshipconfirmutcdatetime >= '<DATE_FROM>'  -- yyyy-MM-dd (UTC)
  -- AND w.loadshipconfirmutcdatetime <= '<DATE_TO>'  -- yyyy-MM-dd (UTC)
ORDER BY w.loadid;