Custom SQL Query

✓ Ready — click Run Query to execute orders, customers, order_lines referenced

No results yet.

Run the query above to see live order data from the dERP database.

▸ orders 847,293

□ id bigint

□ order_number varchar

□ customer_id bigint

□ channel varchar

□ status varchar

□ warehouse_id bigint

□ created_at timestamp

□ ship_by_date date

□ total decimal

▸ order_lines 2.1M

□ id bigint

□ order_id bigint

□ sku varchar

□ product_name varchar

□ quantity integer

□ unit_price decimal

▸ customers 1,284

□ id bigint

□ name varchar

□ type varchar

□ credit_limit decimal

▸ products 342

□ id bigint

□ sku varchar

□ name varchar

□ category varchar

□ upc varchar

▸ inventory 1,026

□ id bigint

□ product_id bigint

□ warehouse_id bigint

□ on_hand integer

□ allocated integer

□ available integer

▸ warehouses 3

□ id bigint

□ code varchar

□ name varchar

□ location varchar