Data Map
See how warehouse tables connect. Verified joins are safer; inferred joins are clearly marked.
Find a table
Orders connections
Shipping / FELOrdersverified
ORDERID = ORDERIDSHIPID = SHIPID
Existing FEL query used in workplace reporting
OrdersOrder Itemsverified
CUSTID = CUSTIDFROMFACILITY = FROMFACILITYORDERID = ORDERIDSHIPID = SHIPID
User-supplied working Superset Missing Pick Front query
OrdersWavesinferred
WAVE = WAVE
Common key WAVE on inferred ORDERHDR.WAVE
OrdersLoadsinferred
LOADNO = LOADNO
Common key LOADNO