# Purchasequoteshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Purchasequoteshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddresseeId` | `int32` | Addressee ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyConvertorFactor` | `decimal` | Currency Convertor Factor | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DeliveryConditionId` | `int32` | Delivery Condition ID | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `ExchangeRateDate` | `datetimeoffset` | Exchange Rate Date | ☐ | | | `FollowUpDate` | `datetimeoffset` | Follow-up Date | ☐ | | | `GroupLinesByItem` | `boolean` | Group Lines by Item | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InternalMemo` | `string` | Internal Memo | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LanguageId` | `int32` | Language ID | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `MultiCurrencyId` | `int32` | Multi-currency ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `OrderDate` | `datetimeoffset` | Order Date | ☐ | | | `OrderId` | `string` | Order ID | ☐ | | | `OwnerId` | `int32` | Owner ID | ☐ | | | `PaymentConditionId` | `int32` | Payment Condition ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `PurchaseInvoiceId` | `int32` | Purchase Invoice ID | ☐ | | | `PurchaseOrderTemplateId` | `int32` | Purchase Order Template ID | ☐ | | | `QuoteId` | `string` | Quote ID | ☐ | | | `SalesQuoteId` | `int32` | Sales Quote ID | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TemplateId` | `int32` | Template ID | ☐ | | | `WarrantyConditionId` | `int32` | Warranty Condition ID | ☐ | |