# DaySchedules: ionBIZ Dagschema's - Catalog: `ionBIZ` - Label: Day Schedules - Retrieve: true ## Table Columns The columns of the table `DaySchedules` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AcertaShowPayrollCodeOnLeaveDays` | `boolean` | Acerta Show Payroll Code on Leave Days | ☐ | | | `Color` | `string` | Colour | ☐ | | | `DayEnd` | `int64` | Day End | ☐ | | | `DayEndNextDay` | `boolean` | Day End Next Day | ☐ | | | `DayPart1` | `int64` | Day Part 1 | ☐ | | | `DayPart2` | `int64` | Day Part 2 | ☐ | | | `ExpectedStartTime` | `datetimeoffset` | Expected Start Time | ☐ | | | `ExpectedStopTime` | `datetimeoffset` | Expected Stop Time | ☐ | | | `Favourite` | `boolean` | Favourite | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastModifiedDate` | `datetimeoffset` | Last Modified Date | ☐ | | | `MinDurationPauses` | `int64` | Minimum Duration Pauses | ☐ | | | `Name` | `string` | Name | ☐ | | | `PayrollCode` | `string` | Payroll Code | ☐ | | | `PlanningCellColor` | `string` | Planning Cell Colour | ☐ | | | `PlanningHourAmount` | `int64` | Planning Hour Amount | ☐ | | | `RequiredStartTime` | `datetimeoffset` | Required Start Time | ☐ | | | `RequiredStopTime` | `datetimeoffset` | Required Stop Time | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `ShortName` | `string` | Short Name | ☐ | | | `ToleranceStartTime` | `int64` | Tolerance Start Time | ☐ | | | `ToleranceStopTime` | `int64` | Tolerance Stop Time | ☐ | |