# Relationleadshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Relationleadshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManagerId` | `int32` | Account Manager ID | ☐ | | | `Active` | `boolean` | Active | ☐ | | | `ClosingDate` | `datetimeoffset` | Closing Date | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `DecisionMakerId` | `int32` | Decision Maker ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `EstimatedAmount` | `decimal` | Estimated Amount | ☐ | | | `EstimatedDecisionDate` | `datetimeoffset` | Estimated Decision Date | ☐ | | | `ExpectedEndDate` | `datetimeoffset` | Expected End Date | ☐ | | | `ExpectedStartDate` | `datetimeoffset` | Expected Start Date | ☐ | | | `ExternalID` | `string` | External ID | ☐ | | | `FollowUpDate` | `datetimeoffset` | Follow-up Date | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `HourlyRate` | `decimal` | Hourly Rate | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceToAddressId` | `int32` | Invoice to Address ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LeadSourceId` | `int32` | Lead Source ID | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Notes` | `string` | Notes | ☐ | | | `Project_Id` | `int32` | Project ID | ☐ | | | `ProjectAddressId` | `int32` | Project Address ID | ☐ | | | `ProjectGroupId` | `int32` | Project Group ID | ☐ | | | `ProjectTypeId` | `int32` | Project Type ID | ☐ | | | `QuoteDate` | `datetimeoffset` | Quote Date | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `ReasonLostId` | `int32` | Reason Lost ID | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationLeadId` | `string` | Relation Lead ID | ☐ | | | `SalesManagerId` | `int32` | Sales Manager ID | ☐ | | | `Scoring` | `int32` | Scoring | ☐ | | | `Source` | `string` | Source | ☐ | | | `Status` | `int32` | Status | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | |