Scheduled Order Item

• File Name: scheduledorderitem.parquet
• Type: Incremental (Delta)
• Schema Version: 01.00
• Last Updated: 2026-02-25

Description

Contains scheduled order line items showing product-level order details, suggested quantities, delivery information, and stock levels. Each record represents a single product on a scheduled order.

Delta Filter

• Incremental Updates: Only records modified since your last export
• First Run: Includes up to 1 month of historical data
• Gap Handling: If more than 1 month has passed since last export, limited to most recent month

Fields

📋 Includes Common Fields: Client Information, Location Information, Asset Information, Product Information, Audit Fields

Core ScheduledOrderItem Fields

Column Name	Data Type	Nullable	Description
ScheduledOrderItemId	int	NOT NULL	Unique identifier for the order item
ScheduledOrderId	int	NOT NULL	Scheduled order identifier
UnitsNeeded	numeric(5,2)	NOT NULL	Number of units needed
UnitPrice	decimal(18,2)	NOT NULL	Price per unit
Amount	numeric(10,2)	NULL	Total amount
CaseSize	int	NOT NULL	Case size
StockLevel	numeric(5,2)	NOT NULL	Current stock level
AssetPurityId	int	NOT NULL	Asset purity record ID
SuggestedUnitsNeeded	numeric(5,2)	NULL	Suggested units needed
DeliveredUnits	numeric(5,2)	NULL	Number of units delivered

ScheduledOrder Fields (from parent record)

Column Name	Data Type	Nullable	Description
ReorderDate	datetime	NULL	Reorder date (from ScheduledOrder)
StatusId	int	NULL	Order status identifier (from ScheduledOrder)
DeliveryDate	datetime	NULL	Delivery date (from ScheduledOrder)
ExternalOrderNo	varchar(500)	NULL	External order number (from ScheduledOrder)
OrderSize	int	NULL	Total order size (from ScheduledOrder)
TotalCaseSize	int	NULL	Total case size (from ScheduledOrder)
OutOfStock	int	NULL	Out of stock count (from ScheduledOrder)
RestockIn	varchar(500)	NULL	Restock timing (from ScheduledOrder)