Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 ![Foreign Keys FK_Schedule_Dates_ScheduleID_Schedule_ID: [dbo].[Schedule].ScheduleID Foreign Keys FK_Schedule_Dates_ScheduleID_Schedule_ID: [dbo].[Schedule].ScheduleID](../../../../Images/fk.png) ![Check Constraints CKScheduleDatesScheduleID : ([ScheduleID]>(0)) Check Constraints CKScheduleDatesScheduleID : ([ScheduleID]>(0))](../../../../Images/c-constraint.png) | ScheduleID | [dbo].[uniqueid] | 9 | NOT NULL | Schedule. Link to Schedule.ID |
 | ScheduleDTTM | datetime | 8 | NOT NULL | The Scheduled date for the associated Scheduled Order |
![Check Constraints CK_Schedule_Dates_IsCancelledFlag_Yes_Or_No : ([IsCancelledFlag]='N' OR [IsCancelledFlag]='Y') Check Constraints CK_Schedule_Dates_IsCancelledFlag_Yes_Or_No : ([IsCancelledFlag]='N' OR [IsCancelledFlag]='Y')](../../../../Images/c-constraint.png) | IsCancelledFlag | [dbo].[BOOL] | 1 | NOT NULL | Cancel flag for the particular schedule date. Y = Cancel N = Not cancelled |
 ![Check Constraints CK_Schedule_Dates_IsDeferredFlag_Yes_Or_No : ([IsDeferredFlag]='N' OR [IsDeferredFlag]='Y') Check Constraints CK_Schedule_Dates_IsDeferredFlag_Yes_Or_No : ([IsDeferredFlag]='N' OR [IsDeferredFlag]='Y')](../../../../Images/c-constraint.png) | IsDeferredFlag | [dbo].[BOOL] | 1 | NOT NULL | Deferred flag for the particular schedule date. Y = Deferred N = Not Deferred |
| OrderActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Order. Link to Order_Activity_Header.ID |
| LastUpdatedDTTM | datetime | 8 | NOT NULL | Date the Scheduled Date was last updated |
| LastUpdatedByID | [dbo].[uniqueid] | 9 | NOT NULL | The User that made the Last Update |