Purchase orders dataset

Purchase orders dataset for the Markdown & Promotions module, tracking ordered, delivered, and receipted units per product and location.

The Purchase orders dataset tracks supplier orders, including ordered, delivered, and receipted units per product and location. It represents incoming supply used to project future availability.

Purpose

The Markdown & Promotions module uses the Purchase orders dataset to:

• Represent incoming supply from suppliers
• Track order progress from placement through receipt
• Support availability projections for markdown and promotion decisions

Required fields

About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.

Field	Description	Type	Constraint
order_number	Purchase order number.	string	Primary key
product_id	Unique identifier for the product SKU.	string	Primary key Foreign key to product
actual_departure_at	Timestamp when the order actually departed the supplier.	timestamp	Nullable
created_at	Timestamp when the record was created.	timestamp	Nullable
delivered_units	Number of units delivered against the order.	integer	Nullable
expected_departure_at	Timestamp when the order was expected to depart the supplier.	timestamp	Nullable
location_id	Unique identifier for the store or location.	string	Foreign key to location Non-null
order_due_date_at	Date the order is due to be received.	timestamp	Non-null
ordered_at	Timestamp when the order was placed.	timestamp	Non-null
ordered_units	Number of units ordered.	integer	Non-null
purchase_order_id	Source-system identifier for the purchase order.	string	Nullable
receipt_date	Date the order was received.	date	Nullable
receipted_units	Number of units receipted into stock.	integer	Nullable
status	Current status of the purchase order.	string	Nullable
updated_at	Timestamp when the record was last updated.	timestamp	Nullable

Usage notes

• Product and location identifiers must align with the Products and Locations datasets.
• Units should use the same unit of measure as related datasets.

Why this dataset matters

Incoming supply affects future availability, which informs whether products are candidates for clearance or promotion.