# Spgettasksextensionfieldsresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Spgettasksextensionfieldsresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCost` | `decimal` | Actual Cost | ☑ | | | `ActualCostCosts` | `decimal` | Actual Cost Costs | ☑ | | | `ActualCostsTime` | `decimal` | Actual Costs Time | ☑ | | | `Actuals` | `int64` | Actuals | ☑ | | | `ActualSales` | `decimal` | Actual Sales | ☑ | | | `ActualSalesCosts` | `decimal` | Actual Sales Costs | ☑ | | | `ActualSalesInclTaskDiscount` | `decimal` | Actual Sales Incl. Task Discount | ☑ | | | `ActualSalesTime` | `decimal` | Actual Sales Time | ☑ | | | `ActualSalesTimeProfit` | `decimal` | Actual Sales Time Profit | ☑ | | | `AllCostsCosts` | `decimal` | All Costs Costs | ☑ | | | `AllSalesCosts` | `decimal` | All Sales Costs | ☑ | | | `AssignedCosts` | `decimal` | Assigned Costs | ☑ | | | `AssignedSales` | `decimal` | Assigned Sales | ☑ | | | `AssignedTime` | `int64` | Assigned Time | ☐ | | | `AverageCostPricePerHour` | `decimal` | Average Cost Price Per Hour | ☑ | | | `AverageSalesPricePerHour` | `decimal` | Average Sales Price Per Hour | ☑ | | | `Baseline` | `int64` | Baseline | ☑ | | | `BaselineCostsCosts` | `decimal` | Baseline Costs Costs | ☑ | | | `BaselineCostsTime` | `decimal` | Baseline Costs Time | ☑ | | | `BaselineSalesCosts` | `decimal` | Baseline Sales Costs | ☑ | | | `BaselineSalesTime` | `decimal` | Baseline Sales Time | ☑ | | | `BillableHours` | `int64` | Billable Hours | ☑ | | | `CompletedPercent` | `int32` | Completed (%) | ☑ | | | `ConfirmedActuals` | `decimal` | Confirmed Actuals | ☑ | | | `ConfirmedCostsActuals` | `decimal` | Confirmed Costs Actuals | ☑ | | | `ConfirmedSalesActuals` | `decimal` | Confirmed Sales Actuals | ☑ | | | `ConversionFactor` | `decimal` | Conversion Factor | ☑ | | | `CreatorId` | `int32` | Creator ID | ☑ | | | `CurrencyId` | `int32` | Currency ID | ☑ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `CurrentCosts` | `decimal` | Current Costs | ☑ | | | `CurrentCostsCosts` | `decimal` | Current Costs Costs | ☑ | | | `CurrentCostsTime` | `decimal` | Current Costs Time | ☑ | | | `CurrentSales` | `decimal` | Current Sales | ☑ | | | `CurrentSalesCosts` | `decimal` | Current Sales Costs | ☑ | | | `CurrentSalesTime` | `decimal` | Current Sales Time | ☑ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `FuturePlanned` | `int64` | Future Planned | ☑ | | | `Id` | `int32` | ID | ☑ | | | `Initials` | `string` | Initials | ☐ | | | `Invoiced` | `decimal` | Invoiced | ☑ | | | `IsBillable` | `boolean` | Is Billable | ☐ | | | `IsLeaf` | `boolean` | Is Leaf | ☑ | | | `Milestone` | `boolean` | Milestone | ☑ | | | `MinimumMargin` | `int32` | Minimum Margin | ☑ | | | `MinimumMarkup` | `int32` | Minimum Markup | ☑ | | | `Name` | `string` | Name | ☐ | | | `NotBillableHours` | `int64` | Not Billable Hours | ☑ | | | `ParentId` | `int32` | Parentid | ☑ | | | `PastActuals` | `int64` | Past Actuals | ☑ | | | `Planned` | `int64` | Planned | ☑ | | | `PlannedCost` | `decimal` | Planned Cost | ☑ | | | `PlannedSales` | `decimal` | Planned Sales | ☑ | | | `ProjectBudgetAllocation` | `int32` | Project Budget Allocation | ☑ | | | `ProjectDepartmentId` | `int32` | Project Department ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectOverheadFactorCosts` | `decimal` | Project Overhead Factor Costs | ☐ | | | `ProjectOverheadFactorTime` | `decimal` | Project Overhead Factor Time | ☐ | | | `ProjectWorkHoursPerDay` | `decimal` | Project Work Hours Per Day | ☐ | | | `RegisteredCostsTime` | `decimal` | Registered Costs Time | ☑ | | | `RegisteredSalesTime` | `decimal` | Registered Sales Time | ☑ | | | `Sequence` | `int32` | Sequence | ☑ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `StatusId` | `int32` | Status ID | ☑ | | | `SubsequentPlanning` | `decimal` | Subsequent Planning | ☑ | | | `SubsequentPlanningCosts` | `decimal` | Subsequent Planning Costs | ☑ | | | `SubsequentPlanningSales` | `decimal` | Subsequent Planning Sales | ☑ | | | `TaskBudgetAllocation` | `int32` | Task Budget Allocation | ☑ | | | `TaskBudgetType` | `int32` | Task Budget Type | ☑ | | | `TaskDiscountPercentage` | `decimal` | Task Discount Percentage | ☐ | | | `TaskParentId` | `int32` | Task Parent ID | ☐ | | | `TimeToCompletion` | `int64` | Time to Completion | ☑ | | | `ToCompletionCosts` | `decimal` | To Completion Costs | ☑ | | | `ToCompletionSales` | `decimal` | To Completion Sales | ☑ | | | `TotalRegisteredCosts` | `decimal` | Total Registered Costs | ☑ | | | `TotalRegisteredSales` | `decimal` | Total Registered Sales | ☑ | |