invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceLines: Fortnox Fortnox Invoice Lines

read only

  • Catalog: Fortnox
  • Schema: Views
  • Label: Fortnox Invoice Lines

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Table Columns

The columns of the table InvoiceLines are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: