RouteTable

-- ============================================================
-- Table  : RouteTable Route header — one row per route identifier with its name and approval state; route versions assign it to items, and Route rows hold its operation sequence
-- Purpose: Column-selected read of RouteTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + RouteId
-- 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
  r.routeid AS "The route identifier — the natural key operations and versions join on",
  r.name AS "Route name",
  r.itemgroupid AS "Item group used to filter and organize routes",
  r.approved AS "Whether the route header is approved for use",  -- enum: decode r.approved via GlobalOptionsetMetadata join — see quirks guide #enums
  r.approver AS "RecId of the worker who approved the route",
  r.checkroute AS "Whether route network validation is enforced"  -- enum: decode r.checkroute via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.routetable r
WHERE
  r.dataareaid = '<company>'
ORDER BY r.routeid;