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	Description
ScheduledOrderItemId	int	Unique identifier for the order item
ScheduledOrderId	int	Scheduled order identifier
UnitsNeeded	int	Number of units needed
UnitPrice	decimal(18,2)	Price per unit
Amount	decimal(18,2)	Total amount
CaseSize	int	Case size
StockLevel	int	Current stock level
AssetPurityId	int	Asset purity record ID
SuggestedUnitsNeeded	int	Suggested units needed
DeliveredUnits	int	Number of units delivered

ScheduledOrder Fields (from parent record)

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