# InvoiceLines: Fortnox Fortnox Invoice Lines - Catalog: `Fortnox` - Schema: `Views` - Label: Fortnox 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 `InvoiceLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountNumber` | `int32` | Account Number | ☐ | | | `AccountingMethod` | `varchar2` | Accounting Method | ☐ | | | `Address1` | `varchar2` | Address Line 1 | ☐ | | | `Address2` | `varchar2` | Address Line 2 | ☐ | | | `AdministrationFeeVAT` | `double` | Administration Fee VAT | ☐ | | | `AdministrationFee` | `double` | Administration Fee | ☐ | | | `ArticleNumber` | `varchar2` | Article Number | ☐ | | | `Balance` | `double` | Balance | ☐ | | | `BasisTaxReduction` | `double` | Basis Tax Reduction | ☐ | | | `Booked` | `char` | Booked | ☐ | | | `Cancelled` | `char` | Cancelled | ☐ | | | `City` | `varchar2(1024)` | City | ☐ | | | `Comments` | `varchar2(1024)` | Comments | ☐ | | | `ContractReference` | `int32` | Contract Reference | ☐ | | | `ContributionPercent_2` | `double` | Contribution Percent 2 | ☐ | | | `ContributionPercent` | `varchar2` | Contribution Percent | ☐ | | | `ContributionValue_2` | `double` | Contribution Value 2 | ☐ | | | `ContributionValue` | `varchar2` | Contribution Value | ☐ | | | `CostCenter_2` | `varchar2` | Cost Centre 2 | ☐ | | | `CostCenter` | `varchar2` | Cost Centre | ☐ | | | `Country` | `varchar2` | Country | ☐ | | | `CreditInvoiceReference` | `varchar2` | Credit Invoice Reference | ☐ | | | `Credit` | `varchar2` | Credit | ☐ | | | `CurrencyRate` | `double` | Currency Rate | ☐ | | | `CurrencyUnit` | `int32` | Currency Unit | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `CustomerName` | `varchar2` | Customer Name | ☐ | | | `CustomerNumber` | `varchar2` | Customer Number | ☐ | | | `DeliveredQuantity` | `varchar2` | Delivered Quantity | ☐ | | | `DeliveryAddress1` | `varchar2(1024)` | Delivery Address 1 | ☐ | | | `DeliveryAddress2` | `varchar2(1024)` | Delivery Address 2 | ☐ | | | `DeliveryCity` | `varchar2(1024)` | Delivery City | ☐ | | | `DeliveryCountry` | `varchar2` | Delivery Country | ☐ | | | `DeliveryDate` | `datetime` | Delivery Date | ☐ | | | `DeliveryName` | `varchar2(1024)` | Delivery Name | ☐ | | | `DeliveryZipCode` | `varchar2(1024)` | Delivery Zip Code | ☐ | | | `Description` | `varchar2(255)` | Description | ☐ | | | `DiscountType` | `varchar2` | Discount Type | ☐ | | | `Discount` | `double` | Discount | ☐ | | | `DocumentNumber` | `varchar2` | Document Number | ☐ | | | `DueDate` | `datetime` | Due Date | ☐ | | | `EDIInformation_EDIGlobalLocationNumberDelivery` | `varchar2(13)` | EDI Information EDI Global Location Number Delivery | ☐ | | | `EDIInformation_EDIGlobalLocationNumber` | `varchar2(13)` | EDI Information EDI Global Location Number | ☐ | | | `EDIInformation_EDIInvoiceExtra1` | `varchar2` | EDI Information EDI Invoice Extra 1 | ☐ | | | `EDIInformation_EDIInvoiceExtra2` | `varchar2` | EDI Information EDI Invoice Extra 2 | ☐ | | | `EDIInformation_EDIOurElectronicReference` | `varchar2` | EDI Information EDI Our Electronic Reference | ☐ | | | `EDIInformation_EDIStatus` | `varchar2` | EDI Information EDI Status | ☐ | | | `EDIInformation_EDIYourElectronicReference` | `varchar2` | EDI Information EDI Your Electronic Reference | ☐ | | | `EUQuarterlyReport` | `char` | EU Quarterly Report | ☐ | | | `EmailInformation_EmailAddressBCC` | `varchar2` | Email Information Email Address Bcc | ☐ | | | `EmailInformation_EmailAddressCC` | `varchar2` | Email Information Email Address CC | ☐ | | | `EmailInformation_EmailAddressFrom` | `varchar2` | Email Information Email Address From | ☐ | | | `EmailInformation_EmailAddressTo` | `varchar2` | Email Information Email Address To | ☐ | | | `EmailInformation_EmailBody` | `varchar2(20000)` | Email Information Email Body | ☐ | | | `EmailInformation_EmailSubject` | `varchar2(100)` | Email Information Email Subject | ☐ | | | `ExternalInvoiceReference1` | `varchar2(80)` | External Invoice Reference 1 | ☐ | | | `ExternalInvoiceReference2` | `varchar2(80)` | External Invoice Reference 2 | ☐ | | | `FinalPayDate` | `datetime` | Final Pay Date | ☐ | | | `FreightVAT` | `double` | Freight VAT | ☐ | | | `Freight` | `double` | Freight | ☐ | | | `Gross` | `double` | Gross | ☐ | | | `HouseWorkHoursToReport` | `int32` | House Work Hours to Report | ☐ | | | `HouseWorkType` | `varchar2` | House Worktype | ☐ | | | `HouseWork_2` | `char` | House Work 2 | ☐ | | | `HouseWork` | `char` | House Work | ☐ | | | `InvoiceBalance` | `double` | Balance | ☐ | | | `InvoiceBooked` | `char` | Booked | ☐ | | | `InvoiceCancelled` | `char` | Cancelled | ☐ | | | `InvoiceCostCenter` | `varchar2` | Cost Centre | ☐ | | | `InvoiceCurrencyRate` | `double` | Currency Rate | ☐ | | | `InvoiceCurrencyUnit` | `double` | Currency Unit | ☐ | | | `InvoiceCurrency` | `varchar2` | Currency | ☐ | | | `InvoiceCustomerName` | `varchar2` | Customer Name | ☐ | | | `InvoiceCustomerNumber` | `varchar2` | Customer Number | ☐ | | | `InvoiceDate` | `datetime` | Invoice Date | ☐ | | | `InvoiceDocumentNumber` | `varchar2` | Document Number | ☐ | | | `InvoiceDueDate` | `datetime` | Due Date | ☐ | | | `InvoiceExternalInvoiceReference1` | `varchar2` | External Invoice Reference 1 | ☐ | | | `InvoiceExternalInvoiceReference2` | `varchar2` | External Invoice Reference 2 | ☐ | | | `InvoiceFinalPayDate` | `datetime` | Final Pay Date | ☐ | | | `InvoiceInvoiceDate` | `datetime` | Invoice Date | ☐ | | | `InvoiceInvoiceType` | `varchar2` | Invoice Type | ☐ | | | `InvoiceNoxFinans` | `char` | Nox Finans | ☐ | | | `InvoiceOCR` | `varchar2` | Ocr | ☐ | | | `InvoicePeriodEnd` | `datetime` | Invoice Period End | ☐ | | | `InvoicePeriodReference` | `varchar2` | Invoice Period Reference | ☐ | | | `InvoicePeriodStart` | `datetime` | Invoice Period Start | ☐ | | | `InvoiceProject` | `varchar2` | Project | ☐ | | | `InvoiceSent` | `char` | Sent | ☐ | | | `InvoiceTermsOfPayment` | `varchar2` | Terms of Payment | ☐ | | | `InvoiceTotal` | `double` | Total | ☐ | | | `InvoiceType` | `varchar2` | Invoice Type | ☐ | | | `InvoiceVoucherNumber` | `int32` | Voucher Number | ☐ | | | `InvoiceVoucherSeries` | `varchar2` | Voucher Series | ☐ | | | `InvoiceVoucherYear` | `int32` | Voucher Year | ☐ | | | `InvoiceWayOfDelivery` | `varchar2` | Way of Delivery | ☐ | | | `Invoicec_url` | `varchar2` | Call URL | ☐ | | | `Language` | `varchar2` | Language | ☐ | | | `LastRemindDate` | `datetime` | Last Remind Date | ☐ | | | `Net` | `double` | Net | ☐ | | | `NotCompleted` | `char` | Notcompleted | ☐ | | | `NoxFinans` | `char` | Nox Finans | ☐ | | | `OCR` | `varchar2` | Ocr | ☐ | | | `OfferReference` | `varchar2` | Offer Reference | ☐ | | | `OrderReference` | `varchar2` | Order Reference | ☐ | | | `OrganisationNumber` | `varchar2` | Organisation Number | ☐ | | | `OurReference` | `varchar2(50)` | Ourreference | ☐ | | | `OutboundDate` | `datetime` | Outbound Date | ☐ | | | `PaymentWay` | `varchar2` | Payment Way | ☐ | | | `Phone1` | `varchar2(1024)` | Phone 1 | ☐ | | | `Phone2` | `varchar2(1024)` | Phone 2 | ☐ | | | `PriceExcludingVAT` | `double` | Price excluding VAT | ☐ | | | `PriceList` | `varchar2` | Price List | ☐ | | | `Price` | `double` | Price | ☐ | | | `PrintTemplate` | `varchar2` | Print Template | ☐ | | | `Project_2` | `varchar2` | Project 2 | ☐ | | | `Project` | `varchar2` | Project | ☐ | | | `Remarks` | `varchar2(1024)` | Remarks | ☐ | | | `Reminders` | `int32` | Reminders | ☐ | | | `RoundOff` | `double` | Round Off | ☐ | | | `RowId` | `int32` | Row ID | ☐ | | | `Sent` | `char` | Sent | ☐ | | | `StockPointCode` | `varchar2` | Stock Point Code | ☐ | | | `TaxReductionType` | `varchar2` | Tax Reduction Type | ☐ | | | `TaxReduction` | `int32` | Tax Reduction | ☐ | | | `TermsOfDelivery` | `varchar2` | Terms of Delivery | ☐ | | | `TermsOfPayment` | `varchar2` | Terms of Payment | ☐ | | | `TimeBasisReference` | `int32` | Time Basis Reference | ☐ | | | `TotalExcludingVAT` | `double` | Total Excluding VAT | ☐ | | | `TotalToPay` | `double` | Total to Pay | ☐ | | | `TotalVAT` | `double` | Total VAT | ☐ | | | `Total_2` | `double` | Total 2 | ☐ | | | `Total` | `double` | Total | ☐ | | | `Unit` | `varchar2` | Unit | ☐ | | | `VATCode` | `varchar2` | VAT Code | ☐ | | | `VATIncluded` | `char` | Vatincluded | ☐ | | | `VAT` | `int32` | VAT | ☐ | | | `VoucherNumber` | `int32` | Voucher Number | ☐ | | | `VoucherSeries` | `varchar2` | Voucher Series | ☐ | | | `VoucherYear` | `int32` | Voucher Year | ☐ | | | `WarehouseReady` | `char` | Warehouse Ready | ☐ | | | `WayOfDelivery` | `varchar2` | Way of Delivery | ☐ | | | `YourOrderNumber` | `varchar2(75)` | Your Order Number | ☐ | | | `YourReference` | `varchar2(50)` | Your Reference | ☐ | | | `ZipCode` | `varchar2(1024)` | ZIP Code | ☐ | | | `c_urlTaxReductionList` | `varchar2` | URL Tax Reduction List | ☐ | | | `c_url` | `varchar2` | Call URL | ☐ | |