# Quotelineshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Quotelineshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Baseline` | `int64` | Baseline | ☐ | | | `Billable` | `boolean` | Billable | ☐ | | | `BudgetAllocation` | `int32` | Budget Allocation | ☐ | | | `BudgetType` | `int32` | Budget Type | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CostTypeId` | `int32` | Cost Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `Discount` | `decimal` | Discount | ☐ | | | `DiscountType` | `int32` | Discount Type | ☐ | | | `DurationType` | `int32` | Duration Type | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `Group` | `int32` | Group | ☐ | | | `HourlyCost` | `decimal` | Hourly Cost | ☐ | | | `HourlyRate` | `decimal` | Hourly Rate | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `ItemId` | `int32` | Item ID | ☐ | | | `LineType` | `int32` | Line Type | ☐ | | | `MarginType` | `int32` | Margin Type | ☐ | | | `Memo` | `string` | Memo | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `Optional` | `boolean` | Optional | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `ParentQuantity` | `int32` | Parent Quantity | ☐ | | | `Print` | `int32` | Print | ☐ | | | `PrintCode` | `string` | Print Code | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `ProjectActivityTypeId` | `int32` | Project Activity Type ID | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `UnitAmount` | `decimal` | Unit Amount | ☐ | | | `UnitCost` | `decimal` | Unit Cost | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `UnitTypeId` | `int32` | Unit Type ID | ☐ | |