# Rptprojectsopenbudgetresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptprojectsopenbudgetresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCosts` | `decimal` | Actual Costs | ☑ | | | `ActualMargin` | `decimal` | Actual Margin | ☑ | | | `ActualSales` | `decimal` | Actual Sales | ☑ | | | `CurrentCostsBudget` | `decimal` | Current Costs Budget | ☑ | | | `CurrentSales` | `decimal` | Current Sales | ☑ | | | `CurrentSalesCosts` | `decimal` | Current Sales Costs | ☑ | | | `CurrentSalesTime` | `decimal` | Current Sales Time | ☑ | | | `CurrVsActualCosts` | `decimal` | Current Vs Actual Costs | ☑ | | | `CurrVsActualSales` | `decimal` | Current Vs Actual Sales | ☑ | | | `Department` | `string` | Department | ☐ | | | `HoldingName` | `string` | Holding Name | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Invoiced` | `decimal` | Invoiced | ☑ | | | `NotInvoiced` | `decimal` | Not Invoiced | ☑ | | | `PlannedCost` | `decimal` | Planned Cost | ☑ | | | `PlannedSales` | `decimal` | Planned Sales | ☑ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectManager` | `string` | Project Manager | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `Relation` | `string` | Relation | ☐ | | | `RelationGroup` | `string` | Relation Group | ☐ | | | `WIPAlert` | `boolean` | WIP Alert | ☑ | | | `WIPMinus` | `decimal` | WIP Minus | ☐ | | | `WIPPlus` | `decimal` | WIP Plus | ☐ | |