# Rptprojectsperiodicfinancialsresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptprojectsperiodicfinancialsresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCost` | `decimal` | Actual Cost | ☐ | | | `CumulNeg` | `decimal` | Cumulative Negative | ☐ | | | `CumulPos` | `decimal` | Cumulative Positive | ☐ | | | `CurrentSalesBudget` | `decimal` | Current Sales Budget | ☐ | | | `Department` | `string` | Department | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☑ | | | `LastActiveDate` | `datetimeoffset` | Last Active Date | ☐ | | | `MonthlyActualCost` | `decimal` | Monthly Actual Cost | ☐ | | | `MonthlyActualSales` | `decimal` | Monthly Actual Sales | ☐ | | | `MonthlyDifference` | `decimal` | Monthly Difference | ☐ | | | `MonthlyInvoice` | `decimal` | Monthly Invoice | ☐ | | | `MonthlyTopUp` | `decimal` | Monthly Top-Up | ☐ | | | `MonthlyTransferred` | `decimal` | Monthly Transferred | ☐ | | | `MonthlyWriteOff` | `decimal` | Monthly Write-Off | ☐ | | | `PrevMonthlyActualCost` | `decimal` | Previous Monthly Actual Cost | ☐ | | | `PrevMonthlyActualSales` | `decimal` | Previous Monthly Actual Sales | ☐ | | | `PrevMonthlyDifference` | `decimal` | Previous Monthly Difference | ☐ | | | `PrevMonthlyInvoice` | `decimal` | Previous Monthly Invoice | ☐ | | | `PrevMonthlyTopUp` | `decimal` | Previous Monthly Top-Up | ☐ | | | `PrevMonthlyTransferred` | `decimal` | Previous Monthly Transferred | ☐ | | | `PrevMonthlyWriteOff` | `decimal` | Previous Monthly Write-Off | ☐ | | | `Project` | `string` | Project | ☐ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `Relation` | `string` | Relation | ☐ | | | `ResourceIntercompany` | `boolean` | Resource Intercompany | ☑ | | | `TotalProfit` | `decimal` | Total Profit | ☐ | |