# Projecttaskresource - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Projecttaskresource` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Actuals` | `int64` | Actuals | ☐ | | | `AllowCosts` | `boolean` | Allow Costs | ☑ | | | `AssignedTime` | `int64` | Assigned Time | ☑ | | | `CostPrice` | `decimal` | Cost Price | ☐ | | | `DurationWeeks` | `decimal` | Duration Weeks | ☐ | | | `Intercompany` | `boolean` | Intercompany | ☑ | | | `IntercompanyCostPrice` | `decimal` | Intercompany Cost Price | ☐ | | | `IsActive` | `boolean` | Is Active | ☑ | | | `LinkPlanningPercent` | `decimal` | Link Planning Percent | ☐ | | | `PlanningIsLinked` | `boolean` | Planning is Linked | ☑ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `SalesPrice` | `decimal` | Salesprice | ☐ | | | `TaskBaseline` | `int64` | Task Baseline | ☑ | | | `TaskEndDate` | `datetimeoffset` | Task End Date | ☐ | | | `TaskId` | `int32` | Task ID | ☑ | | | `TaskName` | `string` | Task Name | ☐ | | | `TaskResourceId` | `int32` | Task Resource ID | ☑ | | | `TaskStartDate` | `datetimeoffset` | Task Start Date | ☐ | | | `TimeToCompletion` | `int64` | Time to Completion | ☑ | |