# Spgetprojectprofitpergroupresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Spgetprojectprofitpergroupresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCosts` | `decimal` | Actual Costs | ☑ | | | `Budget` | `decimal` | Budget | ☐ | | | `BudgettedMargin` | `decimal` | Budgeted Margin | ☐ | | | `BudgettedMarginColor` | `string` | Budgeted Margin Color | ☐ | | | `BudgettedMarkup` | `decimal` | Budgeted Markup | ☐ | | | `BudgettedMarkupColor` | `string` | Budgeted Markup Color | ☐ | | | `BudgettedProfit` | `decimal` | Budgeted Profit | ☐ | | | `BudgettedProfitColor` | `string` | Budgeted Profit Color | ☐ | | | `BudgetType` | `int32` | Budget Type | ☐ | | | `CurrentCostsTime` | `decimal` | Current Costs Time | ☑ | | | `GrossMargin` | `decimal` | Gross Margin | ☐ | | | `GrossMarginColor` | `string` | Gross Margin Color | ☐ | | | `GrossMarkup` | `decimal` | Gross Markup | ☐ | | | `GrossMarkupColor` | `string` | Gross Markup Color | ☐ | | | `GrossProfit` | `decimal` | Gross Profit | ☐ | | | `GrossProfitColor` | `string` | Gross Profit Color | ☐ | | | `Group` | `int32` | Group | ☑ | | | `MinimumMargin` | `decimal` | Minimum Margin | ☐ | | | `MinimumMarkup` | `decimal` | Minimum Markup | ☐ | | | `MinimumProfit` | `decimal` | Minimum Profit | ☐ | | | `Name` | `string` | Name | ☐ | | | `ProjectActivityTypeId` | `int32` | Project Activity Type ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `TaskId` | `int32` | Task ID | ☑ | | | `ToCompletionCosts` | `decimal` | To Completion Costs | ☐ | | | `ToCompletionMargin` | `decimal` | To Completion Margin | ☐ | | | `ToCompletionMarginColor` | `string` | To Completion Margin Color | ☐ | | | `ToCompletionMarkup` | `decimal` | To Completion Markup | ☐ | | | `ToCompletionMarkupColor` | `string` | To Completion Markup Color | ☐ | | | `ToCompletionProfit` | `decimal` | To Completion Profit | ☑ | | | `ToCompletionProfitColor` | `string` | To Completion Profit Color | ☐ | |