# Rptcostscostsresult
- Catalog: `ionBIZ`
- Retrieve: true
## Table Columns
The columns of the table `Rptcostscostsresult` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `Billable` | `boolean` | Billable | ☐ | |
| `Category` | `int32` | Category | ☐ | |
| `Comment` | `string` | Comment | ☐ | |
| `CostStatusId` | `int32` | Cost Status ID | ☐ | |
| `CostType` | `string` | Cost Type | ☐ | |
| `CostTypeCode` | `string` | Cost Type Code | ☐ | |
| `CurrencySymbol` | `string` | Currency Symbol | ☐ | |
| `Date` | `datetimeoffset` | Date | ☐ | |
| `DepartmentShortName` | `string` | Department Short Name | ☐ | |
| `Description` | `string` | Description | ☐ | |
| `IconId` | `int32` | Icon ID | ☐ | |
| `LedgerAccountCostsAccountNo` | `string` | Ledger Account Costs Account Number | ☐ | |
| `LedgerAccountCostsName` | `string` | Ledger Account Costs Name | ☐ | |
| `LedgerAccountTurnoverAccountNo` | `string` | Ledger Account Turnover Account Number | ☐ | |
| `LedgerAccountTurnoverName` | `string` | Ledger Account Turnover Name | ☐ | |
| `LocalCurrencySymbol` | `string` | Local Currency Symbol | ☐ | |
| `LocalTotalCostPrice` | `decimal` | Local Total Cost Price | ☐ | |
| `LocalTotalSalesPrice` | `decimal` | Local Total Sales Price | ☐ | |
| `Month` | `string` | Month | ☐ | |
| `ProjectCostId` | `int32` | Project Cost ID | ☑ | |
| `Reimburse` | `boolean` | Reimburse | ☐ | |
| `ReimbursedAmount` | `decimal` | Reimbursed Amount | ☐ | |
| `ReimbursedOn` | `datetimeoffset` | Reimbursed on | ☐ | |
| `ReimburseStatus` | `string` | Reimburse Status | ☐ | |
| `ResourceBIC` | `string` | Resource BIC | ☐ | |
| `ResourceDepartmentName` | `string` | Resource Department Name | ☐ | |
| `ResourceExternalCode` | `string` | Resource External Code | ☐ | |
| `ResourceIBAN` | `string` | Resource IBAN | ☐ | |
| `ResourceId` | `int32` | Resource ID | ☐ | |
| `ResourceName` | `string` | Resource Name | ☐ | |
| `TotalCostPrice` | `decimal` | Total Cost Price | ☐ | |
| `TotalSalesPrice` | `decimal` | Total Sales Price | ☐ | |
| `UnitAmountDiez` | `decimal` | Unit Amount DIEZ | ☐ | |
| `UnitCostPrice` | `decimal` | Unit Cost Price | ☐ | |
| `UnitSalesPrice` | `decimal` | Unit Sales Price | ☐ | |
| `UnitType` | `string` | Unit Type | ☐ | |
| `Year` | `int32` | Year | ☐ | |