WHSWarehouseWorkLineEntity
Warehouse work lines — line-level warehouse work with header context (work ID, status, closed datetime) folded in; the standard export for work execution analysis
This entity is an export-shaped view over the tables below. When you land raw F&O tables instead of the entity, the SQL further down rebuilds it — joining the backing tables on their keys and DataAreaId. When to land tables vs entities
CDM-verified; display name "Warehouse work lines"; introduced 10.0.13. Backing table WHSWorkLine per the CDM BackingTable relationship.
Rebuild-from-tables SQL
Databricks SQLStarting point for reconstructing this entity from landed tables — the backing tables joined on their keys and DataAreaId. Set your Unity Catalog location, company, and filter values below.
3 parameters not filled: <catalog>, <schema>, <company>
-- ============================================================
-- Entity : WHSWarehouseWorkLineEntity
-- Purpose: Rebuild WHSWarehouseWorkLineEntity from landed F&O tables — auto-generated from table-entity-map
-- Grain : One row per WHSWorkLine record
-- Tables : WHSWorkLine
-- 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. Company-partitioned tables are joined on DataAreaId to prevent cross-company fan-out. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
h.workid AS "Work order this line belongs to",
h.linenum AS "Line number within the work order — pick and put steps in execution sequence"
FROM <catalog>.<schema>.whsworkline h
LEFT JOIN <catalog>.<schema>.whsworktable w
ON w.workid = h.workid
AND w.dataareaid = h.dataareaid
WHERE
h.dataareaid = '<company>'
ORDER BY h.workid;Backing Tables
How these tables connect — join details in the list below.
Join details
ON whsworktable.workid = whsworkline.workid AND whsworktable.dataareaid = whsworkline.dataareaid