# Rptplanningsopenplanningbudgetresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptplanningsopenplanningbudgetresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualHours` | `int64` | Actual Hours | ☐ | | | `AssignedHours` | `int64` | Assigned Hours | ☐ | | | `AvailableHours` | `int64` | Available Hours | ☐ | | | `Baseline` | `int64` | Baseline | ☐ | | | `CustomerName` | `string` | Customer Name | ☐ | | | `DateFrom` | `datetimeoffset` | Date from | ☐ | | | `DateUntil` | `datetimeoffset` | Date until | ☐ | | | `DifferenceHours` | `int64` | Difference Hours | ☐ | | | `Id` | `int32` | ID | ☑ | | | `NotAssignedHours` | `int64` | Not Assigned Hours | ☐ | | | `OpenBudget` | `int64` | Open Budget | ☐ | | | `PlannedHours` | `int64` | Planned Hours | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectIdName` | `string` | Project ID Name | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ResourceExternalCode` | `string` | Resource External Code | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskName` | `string` | Task Name | ☐ | |