# Sample orders: data dictionary

Synthetic data created for this guide: 12 rows, one identical duplicate, and one cancelled order.
All amounts are USD. One row represents one order.

quantity: units; unit_price: price per unit; discount: order-level discount; refund: order-level refund.
status: paid, refunded, or cancelled. Empty region becomes Unknown.

Keep one copy of each identical record. Include paid and refunded in totals.
Net = quantity * unit_price - discount - refund. Group by order_date month.

Reference: June 480; July 570; August 550; total 1600 across 10 included orders.