# Rptiteminventoryperstockresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptiteminventoryperstockresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CommercialName` | `string` | Commercial Name | ☐ | | | `CostType` | `string` | Cost Type | ☐ | | | `CustomFields` | `string` | Custom Fields | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InStock` | `decimal` | In Stock | ☑ | | | `ItemId` | `string` | Item ID | ☐ | | | `LastUnitCostUpdate` | `datetimeoffset` | Last Unit Cost Update | ☐ | | | `MinimumStock` | `decimal` | Minimum Stock | ☐ | | | `Name` | `string` | Name | ☐ | | | `ReliabilityOfLastUnitCost` | `int32` | Reliability of Last Unit Cost | ☐ | | | `ReliabilityOfLastUnitCostType` | `int32` | Reliability of Last Unit Cost Type | ☐ | | | `RotationIndex1Year` | `decimal` | Rotation Index 1 Year | ☐ | | | `RotationIndex3Years` | `decimal` | Rotation Index 3 Years | ☐ | | | `ShortName` | `string` | Short Name | ☐ | | | `Status` | `string` | Status | ☐ | | | `StockLocationName` | `string` | Stock Location Name | ☐ | | | `TotalCosts` | `decimal` | Total Costs | ☐ | | | `TotalSales` | `decimal` | Total Sales | ☐ | | | `TotalWeightedCost` | `decimal` | Total Weighted Cost | ☐ | | | `UnitCost` | `decimal` | Unit Cost | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `WeightedUnitCost` | `decimal` | Weighted Unit Cost | ☐ | |