# SupplierInvoiceLines: Fortnox Fortnox Supplier Invoice Lines - Catalog: `Fortnox` - Schema: `Views` - Label: Fortnox Supplier Invoice Lines This is a read-only view. The Fortnox API may not support changing the data or the Invantive UniversalSQL driver for Fortnox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Fortnox API. ## View Columns The columns of the view `SupplierInvoiceLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountDescription` | `varchar2` | General Ledger Account Description | ☐ | | | `Account` | `int32` | Account | ☐ | | | `AccountingMethod` | `varchar2` | Accounting Method | ☐ | | | `AdministrationFee` | `varchar2` | Administration Fee | ☐ | | | `ArticleNumber` | `varchar2` | Article Number | ☐ | | | `Balance` | `varchar2` | Balance | ☐ | | | `Booked` | `char` | Booked | ☐ | | | `Cancelled` | `char` | Cancelled | ☐ | | | `Code` | `varchar2` | Code | ☐ | | | `Comments` | `varchar2(1000)` | Comments | ☐ | | | `CostCenter_2` | `varchar2` | Cost Centre 2 | ☐ | | | `CostCenter` | `varchar2` | Cost Centre | ☐ | | | `CreditCurrency` | `double` | Credit Currency | ☐ | | | `CreditReference` | `int32` | Credit Reference | ☐ | | | `Credit_2` | `char` | Credit 2 | ☐ | | | `Credit` | `double` | Credit | ☐ | | | `CurrencyRate` | `varchar2` | Currency Rate | ☐ | | | `CurrencyUnit` | `double` | Currency Unit | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `DebitCurrency` | `double` | Debit Currency | ☐ | | | `Debit` | `double` | Debit | ☐ | | | `DisablePaymentFile` | `char` | Disable Payment File | ☐ | | | `DueDate` | `datetime` | Due Date | ☐ | | | `ExternalInvoiceNumber` | `varchar2` | External Invoice Number | ☐ | | | `ExternalInvoiceSeries` | `varchar2` | External Invoice Series | ☐ | | | `FinalPayDate` | `datetime` | Final Pay Date | ☐ | | | `Freight` | `varchar2` | Freight | ☐ | | | `GivenNumber` | `varchar2` | Given Number | ☐ | | | `InvoiceDate` | `datetime` | Invoice Date | ☐ | | | `InvoiceNumber` | `varchar2(64)` | Invoice Number | ☐ | | | `ItemDescription` | `varchar2` | Item Description | ☐ | | | `OCR` | `varchar2` | Ocr | ☐ | | | `OurReference` | `varchar2(50)` | Ourreference | ☐ | | | `PaymentPending` | `char` | Payment Pending | ☐ | | | `Price` | `double` | Price | ☐ | | | `Project_2` | `varchar2` | Project 2 | ☐ | | | `Project` | `varchar2` | Project | ☐ | | | `Quantity` | `int32` | Quantity | ☐ | | | `RoundOffValue` | `varchar2` | Round Off Value | ☐ | | | `SalesType` | `varchar2` | Sales Type | ☐ | | | `StockLocationCode` | `varchar2` | Stock Location Code | ☐ | | | `StockPointCode` | `varchar2` | Stock Point Code | ☐ | | | `SupplierInvoiceAuthorizerName` | `varchar2` | Authorizer Name | ☐ | | | `SupplierInvoiceBalance` | `varchar2` | Balance | ☐ | | | `SupplierInvoiceBooked` | `char` | Booked | ☐ | | | `SupplierInvoiceCancel` | `char` | Cancel | ☐ | | | `SupplierInvoiceCostCenter` | `varchar2` | Cost Centre | ☐ | | | `SupplierInvoiceCredit` | `char` | Credit | ☐ | | | `SupplierInvoiceCurrencyRate` | `varchar2` | Currency Rate | ☐ | | | `SupplierInvoiceCurrencyUnit` | `double` | Currency Unit | ☐ | | | `SupplierInvoiceCurrency` | `varchar2` | Currency | ☐ | | | `SupplierInvoiceDueDate` | `datetime` | Due Date | ☐ | | | `SupplierInvoiceExternalInvoiceNumber` | `varchar2` | External Invoice Number | ☐ | | | `SupplierInvoiceExternalInvoiceSeries` | `varchar2` | External Invoice Series | ☐ | | | `SupplierInvoiceFinalPayDate` | `datetime` | Final Pay Date | ☐ | | | `SupplierInvoiceGivenNumber` | `varchar2` | Given Number | ☐ | | | `SupplierInvoiceInvoiceDate` | `datetime` | Invoice Date | ☐ | | | `SupplierInvoiceInvoiceNumber` | `varchar2` | Invoice Number | ☐ | | | `SupplierInvoiceProject` | `varchar2` | Project | ☐ | | | `SupplierInvoiceSupplierName` | `varchar2` | Supplier Name | ☐ | | | `SupplierInvoiceSupplierNumber` | `varchar2` | Supplier Number | ☐ | | | `SupplierInvoiceTotal` | `varchar2` | Total | ☐ | | | `SupplierInvoicec_url` | `varchar2` | Call URL | ☐ | | | `SupplierName` | `varchar2` | Supplier Name | ☐ | | | `SupplierNumber` | `varchar2` | Supplier Number | ☐ | | | `Total_2` | `varchar2` | Total 2 | ☐ | | | `Total` | `double` | Total | ☐ | | | `TransactionInformation` | `varchar2(100)` | Transaction Information | ☐ | | | `Unit` | `varchar2` | Unit | ☐ | | | `VATType` | `varchar2` | VAT Type | ☐ | | | `VAT` | `varchar2` | VAT | ☐ | | | `VoucherNumber` | `int32` | Voucher Number | ☐ | | | `VoucherSeries` | `varchar2` | Voucher Series | ☐ | | | `VoucherYear` | `int32` | Voucher Year | ☐ | | | `YourReference` | `varchar2(50)` | Your Reference | ☐ | | | `c_url` | `varchar2` | Call URL | ☐ | |