WHSShipmentTable

-- ============================================================
-- Table  : WHSShipmentTable Warehouse shipment header — one row per shipment built from released order lines, carrying its load, status, carrier, and ship-confirm timestamp; the outbound unit customers track
-- Purpose: Column-selected read of WHSShipmentTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + ShipmentId
-- 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.shipmentid AS "The shipment number — the natural key work and load lines reference",
  w.loadid AS "Load the shipment is grouped onto — the join to WHSLoadTable; one load carries many shipments",
  w.shipmentstatus AS "Shipment status across its life cycle (open through shipped)",  -- enum: decode w.shipmentstatus via GlobalOptionsetMetadata join — see quirks guide #enums
  w.loaddirection AS "Whether the shipment is outbound or inbound",  -- enum: decode w.loaddirection via GlobalOptionsetMetadata join — see quirks guide #enums
  w.ordernum AS "Source order number the shipment fulfills (sales or transfer order, per direction)",
  w.accountnum AS "Customer or vendor account behind the shipment, depending on direction",
  w.customerref AS "Customer's own reference for the shipment",
  w.inventsiteid AS "Site the shipment ships from",
  w.inventlocationid AS "Warehouse the shipment ships from",
  w.carriercode AS "Carrier assigned to the shipment",
  w.modecode AS "Transportation mode of the shipment",
  w.dlvtermid AS "Delivery terms for the shipment",
  w.shipconfirmutcdatetime AS "When the shipment was ship-confirmed, stored in UTC — the on-time-shipment timestamp",  -- stored in UTC
  w.shipmentarrivalutcdatetime AS "Planned arrival at the destination, stored in UTC",  -- stored in UTC
  w.waveid AS "Wave that released the shipment to the warehouse floor",
  w.billofladingid AS "Bill of lading issued for the shipment"
FROM <catalog>.<schema>.whsshipmenttable w
WHERE
  w.dataareaid = '<company>'
  -- AND w.shipconfirmutcdatetime >= '<DATE_FROM>'  -- yyyy-MM-dd (UTC)
  -- AND w.shipconfirmutcdatetime <= '<DATE_TO>'  -- yyyy-MM-dd (UTC)
ORDER BY w.shipmentid;