# Rptprojectsperiodicallyrevenueresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptprojectsperiodicallyrevenueresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Activity` | `string` | Activity | ☐ | | | `CumulNeg` | `decimal` | Cumulative Negative | ☐ | | | `CumulPos` | `decimal` | Cumulative Positive | ☐ | | | `CurrentActualHours` | `decimal` | Current Actual Hours | ☐ | | | `CurrentBilCost` | `decimal` | Current Billable Cost | ☐ | | | `CurrentDifference` | `decimal` | Current Difference | ☐ | | | `CurrentInvoiced` | `decimal` | Current Invoiced | ☐ | | | `CurrentNBilCost` | `decimal` | Current Non-Billable Cost | ☐ | | | `CurrentRevenue` | `decimal` | Current Revenue | ☐ | | | `Department` | `string` | Department | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Id` | `int32` | ID | ☑ | | | `LastActiveDate` | `datetimeoffset` | Last Active Date | ☐ | | | `LastActiveDateProject` | `datetimeoffset` | Last Active Date Project | ☐ | | | `LastActiveDateProjectT` | `datetimeoffset` | Last Active Date Project Task | ☐ | | | `OpenBudget` | `decimal` | Open Budget | ☐ | | | `PrevActualHours` | `decimal` | Previous Actual Hours | ☐ | | | `PrevBilCost` | `decimal` | Previous Billable Cost | ☐ | | | `PrevDifference` | `decimal` | Previous Difference | ☐ | | | `PrevInvoiced` | `decimal` | Previous Invoiced | ☐ | | | `PrevNBilCost` | `decimal` | Previous Non-Billable Cost | ☐ | | | `PrevRevenue` | `decimal` | Previous Revenue | ☐ | | | `Project` | `string` | Project | ☐ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `ProjectCost` | `string` | Project Cost | ☐ | | | `ProjectCostId` | `int32` | Project Cost ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `Relation` | `string` | Relation | ☐ | | | `Task` | `string` | Task | ☐ | | | `TaskDescription` | `string` | Task Description | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskStatus` | `string` | Task Status | ☐ | | | `TotalBilCost` | `decimal` | Total Billable Cost | ☐ | | | `TotalNBilCost` | `decimal` | Total Non-Billable Cost | ☐ | | | `TotalProfit` | `decimal` | Total Profit | ☐ | |