Transfer order dataset

Transfers dataset containing details of inventory transfers between internal locations, used by Inventory Management to represent internal stock movements.

The transfers dataset contains details of inventory transfers between internal locations, such as distribution centres and stores. It represents internal stock movements used to replenish inventory within the customer's supply chain.

This dataset is optional if internal transfers are already captured in the purchase orders dataset. When provided separately, it enables the inventory management solution to more accurately project future inventory levels across locations.

Purpose

The solution uses the transfers dataset to:

• Track internal inventory movements between locations
• Project future stock availability based on expected transfers
• Evaluate how internal supply flows affect inventory positions and replenishment decisions

This dataset complements external purchase order data by representing internal supply movements.

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
product_id	Unique identifier for the product SKU.	string	Primary key
location_id	Identifier for the destination store or distribution centre.	string	Primary key
order_number	Unique identifier for each transfer order.	string	Primary key
source_id	Identifier for the supplying location or distribution centre.	string	Non-null
ordered_at	Date and time (UTC) when the transfer order was placed.	datetime	Non-null
ordered_units	Number of units ordered for the transfer line item.	float	Non-null
expected_departure_date	Date and time (UTC) when the transfer is expected to leave the source location.	datetime	Non-null
actual_departure_date	Date and time (UTC) when the transfer actually left the source location.	datetime	Nullable
expected_delivery_date	Date and time (UTC) when the transfer is expected to arrive at the destination.	datetime	Non-null
actual_delivery_date	Date and time (UTC) when the transfer arrived at the destination.	datetime	Nullable
delivered_units	Number of units delivered for the transfer line item.	float	Nullable
status	Status of the transfer line item (for example, Open, Pending approval, Closed).	string	Nullable

Usage notes

• Transfers should be provided at line-item level to support accurate inventory projections.
• Both planned and completed transfers should be included to preserve historical context.
• Partial transfers should be reflected using delivered quantities and actual delivery dates.
• Identifiers (product_id, location_id, source_id) must align with the corresponding Products and Locations datasets.
• Units of measure must be consistent across transfers, stock, and demand datasets.