# Numberrangeshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Numberrangeshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `CostTypeId` | `int32` | Cost Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IDComposition` | `string` | ID Composition | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastNumber` | `string` | Last Number | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Prefix` | `string` | Prefix | ☐ | | | `StartNumber` | `string` | Start Number | ☐ | | | `StopNumber` | `string` | Stop Number | ☐ | | | `Suffix` | `string` | Suffix | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | |