# Rpttimesheethoursbalancedetailresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rpttimesheethoursbalancedetailresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Date` | `datetimeoffset` | Date | ☐ | | | `Day` | `string` | Day | ☐ | | | `Department` | `string` | Department | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `LT01` | `int64` | Leave Type 1 | ☑ | | | `LT02` | `int64` | Leave Type 2 | ☑ | | | `LT03` | `int64` | Leave Type 3 | ☑ | | | `LT04` | `int64` | Leave Type 4 | ☑ | | | `LT05` | `int64` | Leave Type 5 | ☑ | | | `LT06` | `int64` | Leave Type 6 | ☑ | | | `LT07` | `int64` | Leave Type 7 | ☑ | | | `LT08` | `int64` | Leave Type 8 | ☑ | | | `LT09` | `int64` | Leave Type 9 | ☑ | | | `LT10` | `int64` | Leave Type 10 | ☑ | | | `LT11` | `int64` | Leave Type 11 | ☑ | | | `LT12` | `int64` | Leave Type 12 | ☑ | | | `LT13` | `int64` | Leave Type 13 | ☑ | | | `LT14` | `int64` | Leave Type 14 | ☑ | | | `LT15` | `int64` | Leave Type 15 | ☑ | | | `LT16` | `int64` | Leave Type 16 | ☑ | | | `LT17` | `int64` | Leave Type 17 | ☑ | | | `LT18` | `int64` | Leave Type 18 | ☑ | | | `LT19` | `int64` | Leave Type 19 | ☑ | | | `LT20` | `int64` | Leave Type 20 | ☑ | | | `LT21` | `int64` | Leave Type 21 | ☑ | | | `LT22` | `int64` | Leave Type 22 | ☑ | | | `LT23` | `int64` | Leave Type 23 | ☑ | | | `LT24` | `int64` | Leave Type 24 | ☑ | | | `LT25` | `int64` | Leave Type 25 | ☑ | | | `LT26` | `int64` | Leave Type 26 | ☑ | | | `LT27` | `int64` | Leave Type 27 | ☑ | | | `LT28` | `int64` | Leave Type 28 | ☑ | | | `LT29` | `int64` | Leave Type 29 | ☑ | | | `LT30` | `int64` | Leave Type 30 | ☑ | | | `NormalTime` | `int64` | Normal Time | ☑ | | | `OT01` | `int64` | Overtime Type 1 | ☑ | | | `OT02` | `int64` | Overtime Type 2 | ☑ | | | `OT03` | `int64` | Overtime Type 3 | ☑ | | | `OT04` | `int64` | Overtime Type 4 | ☑ | | | `OT05` | `int64` | Overtime Type 5 | ☑ | | | `OT06` | `int64` | Overtime Type 6 | ☑ | | | `OT07` | `int64` | Overtime Type 7 | ☑ | | | `OT08` | `int64` | Overtime Type 8 | ☑ | | | `OT09` | `int64` | Overtime Type 9 | ☑ | | | `OT10` | `int64` | Overtime Type 10 | ☑ | | | `Overtime` | `int64` | Overtime | ☑ | | | `ParentResourceType` | `string` | Parent Resource Type | ☐ | | | `RegisteredTimes` | `int64` | Registered Times | ☑ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `ResourceType` | `string` | Resource Type | ☐ | | | `TotalLeaves` | `int64` | Total Leaves | ☑ | | | `WorkSchedule` | `int64` | Work Schedule | ☑ | |