# ProjectInvoiceProposalLines: ionBIZ Project Invoice Proposal Lines
- Catalog: `ionBIZ`
- Label: Project Invoice Proposal Lines
- Retrieve: true
## Table Columns
The columns of the table `ProjectInvoiceProposalLines` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `Action` | `int32` | Action | ☐ | |
| `Advance` | `boolean` | Advance | ☐ | |
| `AdvanceClosed` | `boolean` | Advance Closed | ☐ | |
| `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 | ☐ | |
| `LineTypeDisplay` | `int32` | Line Type Display | ☐ | |
| `LinkToInvoiceId` | `int32` | Link to Invoice ID | ☐ | |
| `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 | ☐ | |
| `ProjectInvoiceLineId` | `int32` | Project Invoice Line ID | ☐ | |
| `ProjectInvoiceProposalId` | `int32` | Project Invoice Proposal ID | ☐ | |
| `RevenueMonths` | `int32` | Revenue Months | ☐ | |
| `RevenueStart` | `int32` | Revenue Start | ☐ | |
| `Sequence` | `int32` | Sequence | ☐ | |
| `TaskId` | `int32` | Task ID | ☐ | |
| `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | |
| `UnitPrice` | `decimal` | Unit Price | ☐ | |
| `UnitQuantity` | `decimal` | Unit Quantity | ☐ | |
| `UnitTypeId` | `int32` | Unit Type ID | ☐ | |
| `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | |