# Relationshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Relationshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManagerId` | `int32` | Account Manager ID | ☐ | | | `Active` | `boolean` | Active | ☐ | | | `Blocked` | `int32` | Blocked | ☐ | | | `Comment` | `string` | Comment | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CreditControlComment` | `string` | Credit Control Comment | ☐ | | | `DateBlocked` | `datetimeoffset` | Date Blocked | ☐ | | | `DefaultAddressId` | `int32` | Default Address ID | ☐ | | | `DefaultInvoiceToCustomerId` | `int32` | Default Invoice to Customer ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `EmailDomains` | `string` | Email Domains | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `GeneralDiscountPercent` | `decimal` | General Discount (%) | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InternalStatusCustomer` | `int32` | Internal Status Customer | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `LegalFormId` | `int32` | Legal Form ID | ☐ | | | `Mileage` | `decimal` | Mileage | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `OpenCreditLimit` | `decimal` | Open Credit Limit | ☐ | | | `ProjectCode` | `string` | Project Code | ☐ | | | `Reference` | `string` | Reference | ☐ | | | `RelationCode` | `string` | Relation Code | ☐ | | | `RelationGroupId` | `int32` | Relation Group ID | ☐ | | | `RelationHoldingId` | `int32` | Relation Holding ID | ☐ | | | `RelationId` | `string` | Relation ID | ☐ | | | `RelationLanguageId` | `int32` | Relation Language ID | ☐ | | | `RelationTypeId` | `int32` | Relation Type ID | ☐ | | | `StatusCustomer` | `int32` | Status Customer | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TimesheetRuleInvoicingId` | `int32` | Timesheet Rule Invoicing ID | ☐ | |