Tables [dbo].[Schedule_Dates]
List of Scheduled dates associated with a Scheduled Order
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_CIX_Schedule_Dates_SchID_SchDt: ScheduleID\ScheduleDTTMForeign Keys FK_Schedule_Dates_ScheduleID_Schedule_ID: [dbo].[Schedule].ScheduleIDCheck Constraints CKScheduleDatesScheduleID : ([ScheduleID]>(0))ScheduleID[dbo].[uniqueid]9NOT NULLSchedule. Link to Schedule.ID
Cluster Primary Key PK_CIX_Schedule_Dates_SchID_SchDt: ScheduleID\ScheduleDTTMScheduleDTTMdatetime8NOT NULLThe Scheduled date for the associated Scheduled Order
Check Constraints CK_Schedule_Dates_IsCancelledFlag_Yes_Or_No : ([IsCancelledFlag]='N' OR [IsCancelledFlag]='Y')IsCancelledFlag[dbo].[BOOL]1NOT NULLCancel flag for the particular schedule date. Y = Cancel N = Not cancelled
Indexes TWstat_Schedule_Dates_IsDeferredFlagCheck Constraints CK_Schedule_Dates_IsDeferredFlag_Yes_Or_No : ([IsDeferredFlag]='N' OR [IsDeferredFlag]='Y')IsDeferredFlag[dbo].[BOOL]1NOT NULLDeferred flag for the particular schedule date. Y = Deferred N = Not Deferred
OrderActivityHeaderID[dbo].[uniqueid]9NOT NULLOrder. Link to Order_Activity_Header.ID
LastUpdatedDTTMdatetime8NOT NULLDate the Scheduled Date was last updated
LastUpdatedByID[dbo].[uniqueid]9NOT NULLThe User that made the Last Update