# Vwpurchaseinvoicelines - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Vwpurchaseinvoicelines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CurrencyId` | `int32` | Currency ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `ProjectCostCurrencyId` | `int32` | Project Cost Currency ID | ☐ | | | `ProjectCostId` | `int32` | Project Cost ID | ☐ | | | `PurchaseInvoiceCurrencyId` | `int32` | Purchase Invoice Currency ID | ☐ | | | `PurchaseInvoiceId` | `int32` | Purchase Invoice ID | ☐ | | | `PurchaseQuoteLineId` | `int32` | Purchase Quote Line ID | ☐ | | | `Quantity` | `decimal` | Quantity | ☐ | | | `Rate` | `decimal` | Rate | ☐ | | | `TotalCosts` | `decimal` | Total Costs | ☐ | | | `TotalSales` | `decimal` | Total Sales | ☐ | | | `TotalVATCosts` | `decimal` | Total VAT Costs | ☐ | | | `TotalVATSales` | `decimal` | Total VAT Sales | ☐ | | | `VatPercentage` | `decimal` | VAT Percentage | ☐ | |