Unleashed model
Open sales orders
Sales orders placed but not yet completed: the order book, with how late each order is against its required date. A snapshot as of the last sync.
- Grain
- sales order
- Built from
- 1Raw tables
- 1Staging
- 1Core
- 1Analytics
- Reads from Unleashed
- sales_order
- Ships as
- Weld and dbt SQL, open source on GitHub
core.unleashed.open_sales_orders
1-- core.unleashed.open_sales_orders
2-- Sales orders placed but not yet completed: the order book, with how late each
3-- order is against its required date. A snapshot as of the last sync.
4-- Grain: sales order.
5--
6-- Open means Placed or Backordered. Parked orders are drafts and are left out.
7-- Value is in base currency, before tax.
8
9SELECT
10 o.sales_order_id,
11 o.order_number,
12 o.order_status,
13 o.custom_order_status,
14 o.customer_code,
15 o.customer_name,
16 o.warehouse_name,
17 o.salesperson_name,
18 o.order_date,
19 o.required_date,
20 DATE_DIFF(CURRENT_DATE(), o.order_date, DAY) AS days_open,
21 GREATEST(DATE_DIFF(CURRENT_DATE(), o.required_date, DAY), 0) AS days_past_required,
22 o.required_date < CURRENT_DATE() AS is_late,
23 o.currency,
24 o.sub_total,
25 o.bc_sub_total AS value_base_currency
26FROM {{staging.unleashed.sales_order}} o
27WHERE o.order_status IN ('Placed', 'Backordered')This model and the 2 it depends on. Deploy them together; refs like {{staging.…}} resolve to the matching folders in Weld, and the dbt view uses source() and ref().
Notes
How it counts. And where it stops.
Open means Placed or Backordered. Parked orders are drafts and are left out. Value is in base currency, before tax.
Raw tables it reads
- raw.unleashed.sales_order
More Unleashed models
Put Unleashed in front
of your agents.
Connect Unleashed, deploy the models, and ask questions in Claude, Cursor or ChatGPT. Free for 14 days, no credit card.