# Rptprojectsactualsperresourceresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptprojectsactualsperresourceresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualHours` | `int64` | Actual Hours | ☐ | | | `BillableHours` | `int64` | Billable Hours | ☐ | | | `CompanyAddress` | `string` | Company Address | ☐ | | | `CostsTotal` | `decimal` | Costs Total | ☐ | | | `CostTotalCosts` | `decimal` | Cost Total Costs | ☐ | | | `CostTotalHours` | `decimal` | Cost Total Hours | ☐ | | | `CostTotalMileage` | `decimal` | Cost Total Mileage | ☐ | | | `CostUnitCostPerDay` | `decimal` | Cost Unit Cost Per Day | ☐ | | | `CostUnitCostPerHour` | `decimal` | Cost Unit Cost Per Hour | ☐ | | | `Customer` | `string` | Customer | ☐ | | | `Department` | `string` | Department | ☐ | | | `Difference` | `decimal` | Difference | ☐ | | | `DifferencePct` | `int32` | Difference % | ☐ | | | `FunctionName` | `string` | Function Name | ☐ | | | `HoursToBeInvoiced` | `int64` | Hours To Be Invoiced | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☑ | | | `InvoicedHours` | `int64` | Invoiced Hours | ☐ | | | `Month` | `datetimeoffset` | Month | ☐ | | | `NotBillableHours` | `int64` | Not Billable Hours | ☐ | | | `Profit` | `decimal` | Profit | ☐ | | | `ProfitPct` | `int32` | Profit % | ☐ | | | `Project` | `string` | Project | ☐ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `ProjectGroup` | `string` | Project Group | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `RelationGroup` | `string` | Relation Group | ☐ | | | `RequiredSkill` | `string` | Required Skill | ☐ | | | `Resource` | `string` | Resource | ☐ | | | `ResourceExternalCode` | `string` | Resource External Code | ☐ | | | `ResourceFunction` | `string` | Resource Function | ☐ | | | `ResourceIntercompany` | `boolean` | Resource Intercompany | ☑ | | | `ResourceType` | `string` | Resource Type | ☐ | | | `SalesTotal` | `decimal` | Sales Total | ☐ | | | `SalesTotalCosts` | `decimal` | Sales Total Costs | ☐ | | | `SalesTotalHours` | `decimal` | Sales Total Hours | ☐ | | | `SalesTotalMileage` | `decimal` | Sales Total Mileage | ☐ | | | `SalesUnitPricePerDay` | `decimal` | Sales Unit Price Per Day | ☐ | | | `SalesUnitPricePerHour` | `decimal` | Sales Unit Price Per Hour | ☐ | | | `Task` | `string` | Task | ☐ | | | `TotalInvoicedExclVat` | `decimal` | Total Invoiced Excl. VAT | ☐ | |