dbo.optimoRoutePlan

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.optimoRoutePlan.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	PlanDate	datetime	no		Date of the OptimoRoute route plan (one row per planning day).
2	OptimoRoutePlaningID	bigint	yes		ID of the route planning run in OptimoRoute for this plan date.
3	PlanStatus	nvarchar(50)	no		Current status of the route planning run (e.g. queued, running, completed).

Referenced by

Procedures: dbo.spOptimoRoutePlanGetQueue, dbo.spOptimoRoutePlanGetRoutesQueue, dbo.spOptimoRoutePlanGetRoutesRefreshQueue, dbo.spOptimoRoutePlanGetStatusQueue, dbo.spOptimoRoutePlanSetID, dbo.spOptimoRoutePlanSetStatus, dbo.spOptimoRoutePlanUpsert