# Projectextensionfieldsresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Projectextensionfieldsresult` 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 | ☑ | | | `ActualCostCostsInclOH` | `decimal` | Actual Cost Costs in CLOH | ☑ | | | `ActualCostTime` | `decimal` | Actual Cost Time | ☑ | | | `ActualCostTimeInclOH` | `decimal` | Actual Cost Time in CLOH | ☑ | | | `ActualMinusRegistered` | `decimal` | Actual Minus Registered | ☑ | | | `Actuals` | `int64` | Actuals | ☑ | | | `ActualSales` | `decimal` | Actual Sales | ☑ | | | `ActualSalesCosts` | `decimal` | Actual Sales Costs | ☑ | | | `ActualSalesCostsNotClosedExpensesInclOH` | `decimal` | Actual Sales Costs Not Closed Expenses in CLOH | ☑ | | | `ActualSalesCostsNotClosedItemsInclOH` | `decimal` | Actual Sales Costs Not Closed Items in CLOH | ☑ | | | `ActualSalesInclTaskDiscount` | `decimal` | Actual Sales Incl. Task Discount | ☑ | | | `ActualSalesTime` | `decimal` | Actual Sales Time | ☑ | | | `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 | ☑ | | | `BillableActuals` | `int64` | Billable Actuals | ☐ | | | `BudgetAllocation` | `int32` | Budget Allocation | ☑ | | | `CompanyAddressId` | `int32` | Company Address ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☑ | | | `CurrentCosts` | `decimal` | Current Costs | ☑ | | | `CurrentCostsCosts` | `decimal` | Current Costs Costs | ☑ | | | `CurrentCostsTime` | `decimal` | Current Costs Time | ☑ | | | `CurrentMinusRegistered` | `decimal` | Current Minus Registered | ☑ | | | `CurrentSales` | `decimal` | Current Sales | ☑ | | | `CurrentSalesCosts` | `decimal` | Current Sales Costs | ☑ | | | `CurrentSalesTime` | `decimal` | Current Sales Time | ☑ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `DeclarableActuals` | `int64` | Declarable Actuals | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `FixedBudget` | `decimal` | Fixed Budget | ☐ | | | `FuturePlanned` | `int64` | Future Planned | ☐ | | | `GrossMargin` | `decimal` | Gross Margin | ☑ | | | `GrossMarginAfter` | `decimal` | Gross Margin After | ☑ | | | `GrossMarginAfterColor` | `string` | Gross Margin After Color | ☐ | | | `GrossMarginColor` | `string` | Gross Margin Color | ☐ | | | `GrossMarkup` | `decimal` | Gross Markup | ☑ | | | `GrossMarkupColor` | `string` | Gross Markup Color | ☐ | | | `Intercompany` | `boolean` | Intercompany | ☑ | | | `InvoicedAmountWithoutVAT` | `decimal` | Invoiced Amount Without VAT | ☑ | | | `InvoicedMinusRegistered` | `decimal` | Invoiced Minus Registered | ☑ | | | `InvoiceText` | `string` | Invoice Text | ☐ | | | `InvoiceToAddressId` | `int32` | Invoice to Address ID | ☐ | | | `InvoiceToAddressName` | `string` | Invoice to Address Name | ☐ | | | `LastAction` | `datetimeoffset` | Last Action | ☐ | | | `LastActionMonths` | `int32` | Last Action Months | ☐ | | | `MileageCosts` | `decimal` | Mileage Costs | ☑ | | | `MinimumMargin` | `decimal` | Minimum Margin | ☑ | | | `MinimumMarkup` | `decimal` | Minimum Markup | ☑ | | | `Name` | `string` | Name | ☐ | | | `NonBillableActuals` | `int64` | Non-Billable Actuals | ☐ | | | `NonDeclarableActuals` | `int64` | Non-Declarable Actuals | ☐ | | | `PastActuals` | `int64` | Past Actuals | ☐ | | | `Planned` | `int64` | Planned | ☐ | | | `PlannedCost` | `decimal` | Planned Cost | ☑ | | | `PlannedSales` | `decimal` | Planned Sales | ☑ | | | `ProfitToCompletionPlanning` | `decimal` | Profit to Completion Planning | ☑ | | | `ProfitToCompletionPlanningCosts` | `decimal` | Profit to Completion Planning Costs | ☑ | | | `ProfitToCompletionPlanningPctDivider` | `decimal` | Profit to Completion Planning % Divider | ☑ | | | `ProfitToCompletionPlanningSales` | `decimal` | Profit to Completion Planning Sales | ☑ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectProjectId` | `string` | Project Project ID | ☐ | | | `RegisteredCosts` | `decimal` | Registered Costs | ☑ | | | `RegisteredCostsCosts` | `decimal` | Registered Costs Costs | ☑ | | | `RegisteredCostsTime` | `decimal` | Registered Costs Time | ☑ | | | `RegisteredSales` | `decimal` | Registered Sales | ☑ | | | `RegisteredSalesCosts` | `decimal` | Registered Sales Costs | ☑ | | | `RegisteredSalesTime` | `decimal` | Registered Sales Time | ☑ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationContactName` | `string` | Relation Contact Name | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationName` | `string` | Relation Name | ☐ | | | `SendToAddressId` | `int32` | Send to Address ID | ☐ | | | `SendToAddressName` | `string` | Send to Address Name | ☐ | | | `TimeToCompletion` | `int64` | Time to Completion | ☑ | | | `TMBudget` | `decimal` | T&M Budget | ☐ | | | `ToCompletionCosts` | `decimal` | To Completion Costs | ☑ | | | `ToCompletionMargin` | `decimal` | To Completion Margin | ☑ | | | `ToCompletionMarginColor` | `string` | To Completion Margin Color | ☐ | | | `ToCompletionProfit` | `decimal` | To Completion Profit | ☑ | | | `ToCompletionSales` | `decimal` | To Completion Sales | ☑ | | | `TopUp` | `decimal` | Top-up | ☑ | | | `TotalActualCostExpensesInclOH` | `decimal` | Total Actual Cost Expenses in CLOH | ☑ | | | `TotalActualCostItemInclOH` | `decimal` | Total Actual Cost Item in CLOH | ☑ | | | `Transferred` | `decimal` | Transferred | ☑ | | | `UsedBudget` | `int32` | Used Budget | ☑ | | | `UsedBudgetColor` | `string` | Used Budget Color | ☐ | | | `WIP` | `decimal` | WIP | ☑ | | | `WIPAlert` | `boolean` | WIP Alert | ☑ | | | `WipCorrections` | `decimal` | WIP Corrections | ☐ | | | `WIPMinus` | `decimal` | WIP Minus | ☐ | | | `WIPPlus` | `decimal` | WIP Plus | ☐ | | | `WorkHoursPerDay` | `decimal` | Workhours per Day | ☐ | | | `WriteOff` | `decimal` | Write off | ☑ | |