# Taskresourceplain - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Taskresourceplain` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCostsTime` | `decimal` | Actual Costs Time | ☐ | | | `Actuals` | `int64` | Actuals | ☐ | | | `ActualSalesTime` | `decimal` | Actual Sales Time | ☐ | | | `AllowCosts` | `boolean` | Allow Costs | ☐ | | | `ApprovedLeaves` | `int64` | Approved Leaves | ☐ | | | `AssignedDiezColor` | `string` | Assigned DIEZ Color | ☐ | | | `AssignedPercent` | `decimal` | Assigned Percent | ☐ | | | `AssignedTime` | `int64` | Assigned Time | ☐ | | | `CanBeUnassign` | `boolean` | Can Be Unassigned | ☐ | | | `CompletedPercent` | `decimal` | Completed (%) | ☐ | | | `CompletedPercentColor` | `string` | Completed Percent Color | ☐ | | | `CostPrice` | `decimal` | Cost Price | ☐ | | | `CostPriceEditable` | `boolean` | Cost Price Editable | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `Creator` | `string` | Creator | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CurrencyIdName` | `string` | Currency ID Name | ☐ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `CustomerId` | `int32` | Customer ID | ☐ | | | `CustomerName` | `string` | Customer Name | ☐ | | | `DailyRate` | `decimal` | Daily Rate | ☐ | | | `DateDurationWeek` | `decimal` | Date Duration Week | ☐ | | | `DeleteFuturePlannings` | `boolean` | Delete Future Plannings | ☐ | | | `DurationWeeks` | `decimal` | Duration Weeks | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `FunctionName` | `string` | Function Name | ☐ | | | `FuturePlanning` | `int64` | Future Planning | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☐ | | | `IntercompanyCostPrice` | `decimal` | Intercompany Cost Price | ☐ | | | `IntercompanyCostPriceEditable` | `boolean` | Intercompany Cost Price Editable | ☐ | | | `IntercompanyCostPriceHidden` | `boolean` | Intercompany Cost Price Hidden | ☐ | | | `IntercompanyEditable` | `boolean` | Intercompany Editable | ☐ | | | `IntercompanyHidden` | `boolean` | Intercompany Hidden | ☐ | | | `IsActive` | `boolean` | Is Active | ☐ | | | `IsHided` | `boolean` | Is Hidden | ☐ | | | `LinkPlanningPercent` | `decimal` | Link Planning Percent | ☐ | | | `ModifiedBy` | `string` | Modified By | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `OldAssignedTime` | `int64` | Old Assigned Time | ☐ | | | `OldCompletedPercent` | `decimal` | Old Completed Percent | ☐ | | | `OldCostPrice` | `decimal` | Old Cost Price | ☐ | | | `OldFunctionId` | `decimal` | Old Function ID | ☐ | | | `OldIntercompanyCostPrice` | `decimal` | Old Intercompany Cost Price | ☐ | | | `OldResourceId` | `int32` | Old Resource ID | ☐ | | | `OldTimeToCompletion` | `int64` | Old Time to Completion | ☐ | | | `PermissionsDelete` | `boolean` | Permissions Delete | ☐ | | | `PermissionsEdit` | `boolean` | Permissions Edit | ☐ | | | `PhantomId` | `string` | Phantom ID | ☐ | | | `Planned` | `int64` | Planned | ☐ | | | `PlannedNotLinked` | `int64` | Planned Not Linked | ☐ | | | `PlanningIsLinked` | `boolean` | Planning is Linked | ☐ | | | `PlanningIsLinkedWarning` | `boolean` | Planning Is Linked Warning | ☐ | | | `PlanningToBeLinked` | `int32` | Planning To Be Linked | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `ProjectActivityIdHidden` | `boolean` | Project Activity ID Hidden | ☐ | | | `ProjectCompanyAddressId` | `int32` | Project Company Address ID | ☐ | | | `ProjectDepartmentId` | `int32` | Project Department ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectManagerId` | `int32` | Project Manager ID | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ProjectSalesManagerId` | `int32` | Project Sales Manager ID | ☐ | | | `ProjectSupervisorId` | `int32` | Project Supervisor ID | ☐ | | | `ProjectWorkHoursPerDay` | `decimal` | Project Work Hours Per Day | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `QuoteLineId` | `int32` | Quote Line ID | ☐ | | | `ResourceCompanyAddressId` | `int32` | Resource Company Address ID | ☐ | | | `ResourceCostDate` | `datetimeoffset` | Resource Cost Date | ☐ | | | `ResourceDepartmentId` | `int32` | Resource Department ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `SalesPrice` | `decimal` | Salesprice | ☐ | | | `Status` | `int32` | Status | ☐ | | | `StatusIcon` | `string` | Status Icon | ☐ | | | `TaskBaseline` | `int64` | Task Baseline | ☐ | | | `TaskBillable` | `boolean` | Task Billable | ☐ | | | `TaskDailyRate` | `decimal` | Task Daily Rate | ☐ | | | `TaskDeclarable` | `boolean` | Task Declarable | ☐ | | | `TaskDepartmentId` | `int32` | Task Department ID | ☐ | | | `TaskEndDate` | `datetimeoffset` | Task End Date | ☐ | | | `TaskHourlyRate` | `decimal` | Task Hourly Rate | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskIsClosed` | `boolean` | Task Is Closed | ☐ | | | `TaskIsCompleted` | `boolean` | Task Is Completed | ☐ | | | `TaskIsInProgress` | `boolean` | Task Is In Progress | ☐ | | | `TaskIsLeaf` | `boolean` | Task Is Leaf | ☐ | | | `TaskName` | `string` | Task Name | ☐ | | | `TaskStartDate` | `datetimeoffset` | Task Start Date | ☐ | | | `TimeToCompletion` | `int64` | Time to Completion | ☐ | | | `TotalAssignedCurrentCost` | `decimal` | Total Assigned Current Cost | ☐ | | | `TotalAssignedRate` | `decimal` | Total Assigned Rate | ☐ | | | `TotalPlannedCost` | `decimal` | Total Planned Cost | ☐ | | | `TotalPlannedRate` | `decimal` | Total Planned Rate | ☐ | | | `WorkHoursPerDay` | `decimal` | Workhours per Day | ☐ | | | `WorkScheduleDuration` | `int64` | Work Schedule Duration | ☐ | |