# Quotes: ionBIZ Quotes - Catalog: `ionBIZ` - Label: Quotes - Retrieve: true ## Table Columns The columns of the table `Quotes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManagerId` | `int32` | Account Manager ID | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CompanyAddressId` | `int32` | Company Address ID | ☐ | | | `ContractId` | `int32` | Contract ID | ☐ | | | `ContractTypeId` | `int32` | Contract Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyConvertorFactor` | `decimal` | Currency Convertor Factor | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `DateWon` | `datetimeoffset` | Date Won | ☐ | | | `DecisionMakerId` | `int32` | Decision Maker ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Deposit` | `decimal` | Deposit | ☐ | | | `DepositPayedOn` | `datetimeoffset` | Deposit Paid on | ☐ | | | `Discount` | `decimal` | Discount | ☐ | | | `DiscountType` | `int32` | Discount Type | ☐ | | | `EstimatedStartDate` | `datetimeoffset` | Estimated Start Date | ☐ | | | `ExpectedEndDate` | `datetimeoffset` | Expected End Date | ☐ | | | `ExpectedOrderDate` | `datetimeoffset` | Expected Order Date | ☐ | | | `ExposeToRelationPortal` | `boolean` | Expose to Relation Portal | ☐ | | | `FollowUpDate` | `datetimeoffset` | Follow-up Date | ☐ | | | `GroupId` | `int32` | Group ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InternalMemo` | `string` | Internal Memo | ☐ | | | `InvoiceToCustomerId` | `int32` | Invoice to Customer ID | ☐ | | | `IsActive` | `boolean` | Is Active | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LanguageId` | `int32` | Language ID | ☐ | | | `LastModifiedDate` | `datetimeoffset` | Last Modified Date | ☐ | | | `LastStatusUpdate` | `datetimeoffset` | Last Status Update | ☐ | | | `LeadId` | `int32` | Lead ID | ☐ | | | `Location` | `string` | Location | ☐ | | | `Locked` | `boolean` | Locked | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `MultiCurrencyId` | `int32` | Multi-currency ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `OwnerId` | `int32` | Owner ID | ☐ | | | `ProjectAddressId` | `int32` | Project Address ID | ☐ | | | `ProjectId` | `string` | Project ID | ☐ | | | `ProjectKey` | `int32` | Project Key | ☐ | | | `ProjectTypeId` | `int32` | Project Type ID | ☐ | | | `QuoteId` | `string` | Quote ID | ☐ | | | `QuoteTextTypeId` | `int32` | Quote Text Type ID | ☐ | | | `ReasonLostId` | `int32` | Reason Lost ID | ☐ | | | `RelationAddressId` | `int32` | Relation Address ID | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `ScoringPercentage` | `int32` | Scoring Percentage | ☐ | | | `SLATemplateId` | `int32` | SLA Template ID | ☐ | | | `SourceId` | `int32` | Source ID | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TemplateId` | `int32` | Template ID | ☐ | | | `TotalPriceAfterLinesDiscount` | `decimal` | Total Price after Lines Discount | ☐ | | | `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | |