# TimesheetRules: ionBIZ Timesheet Lines - Catalog: `ionBIZ` - Label: Timesheet Lines - Retrieve: true ## Table Columns The columns of the table `TimesheetRules` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `AllowTimesheetsPlusLeavesGreaterThenWorkSchedule` | `boolean` | Allow Timesheets plus Leaves Greater then Work Schedule | ☐ | | | `AllowTimesheetsPlusLeavesLessThenWorkSchedule` | `boolean` | Allow Timesheets plus Leaves Less then Work Schedule | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InterruptedShift` | `decimal` | Interrupted Shift | ☐ | | | `IsDefault` | `boolean` | Is Default | ☐ | | | `IsDefaultWages` | `boolean` | Is Default Wages | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `MaxFlexCounter` | `int64` | Maximum Flex Counter | ☐ | | | `MaxFlexCounterType` | `int32` | Maximum Flex Counter Type | ☐ | | | `MinimumCounter` | `int32` | Minimum Counter | ☐ | | | `OvertimeMode` | `int32` | Overtime Mode | ☐ | | | `PayrollCode` | `string` | Payroll Code | ☐ | | | `PayrollDescription` | `string` | Payroll Description | ☐ | | | `UseOnProjects` | `boolean` | Use on Projects | ☐ | | | `UseOnResources` | `boolean` | Use on Resources | ☐ | | | `UseWorkScheduleForOvertime` | `boolean` | Use Workschedule for Overtime | ☐ | | | `WeekNumbers` | `int32` | Week Numbers | ☐ | |