# Vwprojectinvoicelines - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Vwprojectinvoicelines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CreditNote` | `boolean` | Credit Note | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `Discount` | `decimal` | Discount | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☐ | | | `InvoiceContractCurrencyId` | `int32` | Invoice Contract Currency ID | ☐ | | | `InvoiceContractId` | `int32` | Invoice Contract ID | ☐ | | | `InvoiceCurrencyId` | `int32` | Invoice Currency ID | ☐ | | | `InvoiceDocDate` | `datetimeoffset` | Invoice Document Date | ☐ | | | `InvoiceId` | `int32` | Invoice ID | ☐ | | | `InvoiceQuoteId` | `int32` | Invoice Quote ID | ☐ | | | `InvoiceQuoteMultiCurrencyId` | `int32` | Invoice Quote Multi Currency ID | ☐ | | | `InvoiceRelationDefaultCurrencyId` | `int32` | Invoice Relation Default Currency ID | ☐ | | | `InvoiceRelationId` | `int32` | Invoice Relation ID | ☐ | | | `IssueId` | `int32` | Issue ID | ☐ | | | `ProjectCostCurrencyId` | `int32` | Project Cost Currency ID | ☐ | | | `ProjectCostId` | `int32` | Project Cost ID | ☐ | | | `ProjectCurrencyId` | `int32` | Project Currency ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TotalAfterLineDiscount` | `decimal` | Total After Line Discount | ☐ | | | `TotalExclVAT` | `decimal` | Total Excl. VAT | ☐ | | | `TotalInclVAT` | `decimal` | Total Incl. VAT | ☐ | | | `TotalLine` | `decimal` | Total Line | ☐ | | | `TotalLineDiscount` | `decimal` | Total Line Discount | ☐ | | | `TotalVAT` | `decimal` | Total VAT | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `UnitQuantity` | `decimal` | Unit Quantity | ☐ | | | `VatCode` | `string` | VAT Code | ☐ | | | `VatPercentage` | `decimal` | VAT Percentage | ☐ | |