# TimesheetRuleShifts: ionBIZ Timesheet Line Shifts - Catalog: `ionBIZ` - Label: Timesheet Line Shifts - Retrieve: true ## Table Columns The columns of the table `TimesheetRuleShifts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AllowancePerHour` | `decimal` | Allowance per Hour | ☐ | | | `Color` | `string` | Colour | ☐ | | | `DayType` | `int32` | Day Type | ☐ | | | `From` | `int64` | From | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Nightshift` | `boolean` | Nightshift | ☐ | | | `PayOutPercentage` | `decimal` | Payout Percentage | ☐ | | | `PayrollCode` | `string` | Payroll Code | ☐ | | | `PayrollDescription` | `string` | Payroll Description | ☐ | | | `Percentage` | `decimal` | Percentage | ☐ | | | `PercentageBillableDescription` | `string` | Percentage Billable Description | ☐ | | | `TimesheetRuleId` | `int32` | Timesheet Rule ID | ☐ | | | `To` | `int64` | To | ☐ | |