WMS SQL Studio

Oracle / SupersetHostedOpenCode Go

Build SQL for SQL Lab · No direct WMS connection

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