# PurchaseQuoteLines: ionBIZ Purchase Quote Lines - Catalog: `ionBIZ` - Label: Purchase Quote Lines - Retrieve: true ## Table Columns The columns of the table `PurchaseQuoteLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Billable` | `boolean` | Billable | ☐ | | | `CostTypeId` | `int32` | Cost Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DateRequired` | `datetimeoffset` | Date Required | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DeliveredNo` | `decimal` | Delivered Quantity | ☐ | | | `DeliveryDate` | `datetimeoffset` | Delivery Date | ☐ | | | `DeliveryStatusId` | `int32` | Delivery Status ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `ExpectedDeliveryDate` | `datetimeoffset` | Expected Delivery Date | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoicingStatusId` | `int32` | Invoicing Status ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `ItemId` | `int32` | Item ID | ☐ | | | `ItemSupplierVolumeCostMemo` | `string` | Item Supplier Volume Cost Memo | ☐ | | | `LastUnitCostUpdate` | `datetimeoffset` | Last Unit Cost Update | ☐ | | | `Memo` | `string` | Memo | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `ProjectCostId` | `int32` | Project Cost ID | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `SalesQuoteLine_Id` | `int32` | Sales Quote Line ID | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `StockId` | `int32` | Stock ID | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `UnitAmount` | `decimal` | Unit Amount | ☐ | | | `UnitCost` | `decimal` | Unit Cost | ☐ | | | `UnitTypeId` | `int32` | Unit Type ID | ☐ | | | `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | |