# Spgettaskslist_Result - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Spgettaskslist_Result` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Activity` | `string` | Activity | ☐ | | | `ActivityType` | `string` | Activity Type | ☐ | | | `ActualCostInclOH` | `decimal` | Actual Cost in CLOH | ☐ | | | `ActualCostsCosts` | `decimal` | Actual Costs Costs | ☐ | | | `ActualCostsOfCostsInclOH` | `decimal` | Actual Costs of Costs in CLOH | ☐ | | | `ActualCostsOfTimeInclOH` | `decimal` | Actual Costs of Time in CLOH | ☐ | | | `ActualCostsTime` | `decimal` | Actual Costs Time | ☐ | | | `ActualSalesCosts` | `decimal` | Actual Sales Costs | ☐ | | | `ActualSalesTime` | `decimal` | Actual Sales Time | ☐ | | | `ClosedTickets` | `string` | Closed Tickets | ☐ | | | `Contact` | `string` | Contact | ☐ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `CurrentCostsCostsInclOH` | `decimal` | Current Costs Costs in CLOH | ☐ | | | `CurrentCostsInclOH` | `decimal` | Current Costs in CLOH | ☐ | | | `CurrentCostsTimeInclOH` | `decimal` | Current Costs Time in CLOH | ☐ | | | `Customer` | `string` | Customer | ☐ | | | `CustomerDocumentStatus` | `int32` | Customer Document Status | ☐ | | | `CustomFields` | `string` | Custom Fields | ☐ | | | `Invoiced` | `decimal` | Invoiced | ☐ | | | `OverheadFactorCosts` | `decimal` | Overhead Factor Costs | ☐ | | | `OverheadFactorTime` | `decimal` | Overhead Factor Time | ☐ | | | `ProjectAccountManager` | `string` | Project Account Manager | ☐ | | | `ProjectBaselineHours` | `int64` | Project Baseline Hours | ☑ | | | `ProjectBillable` | `boolean` | Project Billable | ☐ | | | `ProjectBudgetAllocation` | `int32` | Project Budget Allocation | ☐ | | | `ProjectBudgetType` | `int32` | Project Budget Type | ☐ | | | `ProjectCurrency` | `string` | Project Currency | ☐ | | | `ProjectCustomerRef` | `string` | Project Customer Reference | ☐ | | | `ProjectDepartment` | `string` | Project Department | ☐ | | | `ProjectDepartmentId` | `int32` | Project Department ID | ☐ | | | `ProjectEndDate` | `datetimeoffset` | Project End Date | ☐ | | | `ProjectGroup` | `string` | Project Group | ☐ | | | `ProjectManager` | `string` | Project Manager | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ProjectProjectId` | `string` | Project Project ID | ☑ | | | `ProjectStartDate` | `datetimeoffset` | Project Start Date | ☐ | | | `ProjectStatus` | `string` | Project Status | ☐ | | | `ProjectSupervisor` | `string` | Project Supervisor | ☐ | | | `ProjectType` | `string` | Project Type | ☐ | | | `ProjectWorkHoursPerDay` | `decimal` | Project Work Hours Per Day | ☐ | | | `RegisteredCostsTime` | `decimal` | Registered Costs Time | ☐ | | | `RegisteredSalesTime` | `decimal` | Registered Sales Time | ☐ | | | `ResourceDocumentStatus` | `int32` | Resource Document Status | ☐ | | | `TaskActualHours` | `int64` | Task Actual Hours | ☐ | | | `TaskBaselineHours` | `int64` | Task Baseline Hours | ☑ | | | `TaskBillable` | `boolean` | Task Billable | ☐ | | | `TaskCompletedPct` | `int32` | Task Completed % | ☐ | | | `TaskCurrentCostCosts` | `decimal` | Task Current Cost Costs | ☐ | | | `TaskCurrentCostTime` | `decimal` | Task Current Cost Time | ☐ | | | `TaskCurrentCostTotal` | `decimal` | Task Current Cost Total | ☐ | | | `TaskCurrentSalesCosts` | `decimal` | Task Current Sales Costs | ☐ | | | `TaskCurrentSalesTime` | `decimal` | Task Current Sales Time | ☐ | | | `TaskCurrentSalesTotal` | `decimal` | Task Current Sales Total | ☐ | | | `TaskCustomerRef` | `string` | Task Customer Reference | ☐ | | | `TaskDescription` | `string` | Task Description | ☐ | | | `TaskEndDate` | `datetimeoffset` | Task End Date | ☐ | | | `TaskFunction` | `string` | Task Function | ☐ | | | `TaskHourlyCost` | `decimal` | Task Hourly Cost | ☐ | | | `TaskHourlyRate` | `decimal` | Task Hourly Rate | ☐ | | | `TaskInternalRef` | `string` | Task Internal Reference | ☐ | | | `TaskName` | `string` | Task Name | ☐ | | | `TaskPlannedHours` | `int64` | Task Planned Hours | ☐ | | | `TaskStartDate` | `datetimeoffset` | Task Start Date | ☐ | | | `TaskStatus` | `string` | Task Status | ☐ | | | `TaskTimeToCompletion` | `int64` | Task Time to Completion | ☑ | | | `TimesheetDocumentStatus` | `int32` | Timesheet Document Status | ☐ | | | `TotalActualCosts` | `decimal` | Total Actual Costs | ☐ | | | `TotalActualSales` | `decimal` | Total Actual Sales | ☐ | |