# Itemshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Itemshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `CostCurrencyId` | `int32` | Cost Currency ID | ☐ | | | `CostTypeId` | `int32` | Cost Type ID | ☐ | | | `CountryOfOriginId` | `int32` | Country of Origin ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DefaultCommercialName` | `string` | Default Commercial Name | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `DefaultQuantity` | `decimal` | Default Quantity | ☐ | | | `DefaultShortName` | `string` | Default Short Name | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Dimensions` | `string` | Dimensions | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Height` | `string` | Height | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsAssembly` | `boolean` | Is Assembly | ☐ | | | `IsComposed` | `boolean` | Is Composed | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsLicense` | `boolean` | Is License | ☐ | | | `IsOwnItem` | `boolean` | Is Own Item | ☐ | | | `ItemId` | `string` | Item ID | ☐ | | | `LastUnitCostUpdate` | `datetimeoffset` | Last Unit Cost Update | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `Length` | `string` | Length | ☐ | | | `Memo` | `string` | Memo | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Picture` | `byte[]` | Picture | ☐ | | | `ReliabilityOfLastUnitCost` | `int32` | Reliability of Last Unit Cost | ☐ | | | `ReliabilityOfLastUnitCostType` | `int32` | Reliability of Last Unit Cost Type | ☐ | | | `ReplacementItemId` | `int32` | Replacement Item ID | ☐ | | | `SalesCurrencyId` | `int32` | Sales Currency ID | ☐ | | | `SerialNumber` | `boolean` | Serial Number | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TemplateLabelId` | `int32` | Template Label ID | ☐ | | | `UnitCost` | `decimal` | Unit Cost | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `UnitTypeId` | `int32` | Unit Type ID | ☐ | | | `Weight` | `string` | Weight | ☐ | | | `Width` | `string` | Width | ☐ | |