# Contractshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Contractshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManagerId` | `int32` | Account Manager ID | ☐ | | | `ApplyContractIndexation` | `boolean` | Apply Contract Indexation | ☐ | | | `BudgetType` | `int32` | Budget Type | ☐ | | | `ContractId` | `string` | Contract ID | ☐ | | | `ContractTypeId` | `int32` | Contract Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `DefaultSla` | `boolean` | Default SLA | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `ExpiryDate` | `datetimeoffset` | Expiry Date | ☐ | | | `ExternalReminderTemplateId` | `int32` | External Reminder Template ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InternalMemo` | `string` | Internal Memo | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LanguageId` | `int32` | Language ID | ☐ | | | `LastExpiryDateUpdate` | `datetimeoffset` | Last Expiry Date Update | ☐ | | | `Location` | `string` | Location | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `OwnerId` | `int32` | Owner ID | ☐ | | | `ProjectTypeId` | `int32` | Project Type ID | ☐ | | | `RelationAddressId` | `int32` | Relation Address ID | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `ReminderTemplateId` | `int32` | Reminder Template ID | ☐ | | | `SendToAddressId` | `int32` | Send to Address ID | ☐ | | | `SlaTemplateId` | `int32` | SLA Template ID | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TotalBudgetOfLines` | `decimal` | Total Budget of Lines | ☐ | |