# Projectinvoicelineshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Projectinvoicelineshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Advance` | `boolean` | Advance | ☐ | | | `AdvanceClosed` | `boolean` | Advance Closed | ☐ | | | `DateFrom` | `datetimeoffset` | Date from | ☐ | | | `DateTo` | `datetimeoffset` | Date to | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `DiscountPercentage` | `decimal` | Discount (%) | ☐ | | | `DiscountType` | `int32` | Discount Type | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IssueId` | `int32` | Issue ID | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `LineType` | `int32` | Line Type | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `OvertimeDetail` | `decimal` | Overtime Detail | ☐ | | | `PercentageBillableDescription` | `string` | Percentage Billable Description | ☐ | | | `ProjectActivityTypeId` | `int32` | Project Activity Type ID | ☐ | | | `ProjectCostId` | `int32` | Project Cost ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceFeeId` | `int32` | Project Invoice Fee ID | ☐ | | | `ProjectInvoiceId` | `int32` | Project Invoice ID | ☐ | | | `ProjectInvoiceProposalLineId` | `int32` | Project Invoice Proposal Line ID | ☐ | | | `RevenueMonths` | `int32` | Revenue Months | ☐ | | | `RevenueStart` | `int32` | Revenue Start | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TransferFromProjectId` | `int32` | Transfer from Project ID | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `UnitQuantity` | `decimal` | Unit Quantity | ☐ | | | `UnitTypeId` | `int32` | Unit Type ID | ☐ | | | `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | |