invantive documentation
Invantive Support ForumsLog In / Sign Up

SupplierInvoiceLines: Fortnox Fortnox Supplier Invoice Lines

read only

  • Catalog: Fortnox
  • Schema: Views
  • Label: Fortnox Supplier 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 SupplierInvoiceLines 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
Account int32 Account writable
AccountDescription varchar2 General Ledger Account Description writable
AccountingMethod varchar2 Accounting Method writable
AdministrationFee varchar2 Administration Fee writable
ArticleNumber varchar2 Article Number writable
Balance varchar2 Balance writable
Booked char Booked writable
Cancelled char Cancelled writable
Code varchar2 Code writable
Comments varchar2(1000) Comments writable
CostCenter varchar2 Cost Centre writable
CostCenter_2 varchar2 Cost Centre 2 writable
Credit double Credit writable
CreditCurrency double Credit Currency writable
CreditReference int32 Credit Reference writable
Credit_2 char Credit 2 writable
Currency varchar2 Currency writable
CurrencyRate varchar2 Currency Rate writable
CurrencyUnit double Currency Unit writable
Debit double Debit writable
DebitCurrency double Debit Currency writable
DisablePaymentFile char Disable Payment File writable
DueDate datetime Due Date writable
ExternalInvoiceNumber varchar2 External Invoice Number writable
ExternalInvoiceSeries varchar2 External Invoice Series writable
FinalPayDate datetime Final Pay Date writable
Freight varchar2 Freight writable
GivenNumber varchar2 Given Number writable
InvoiceDate datetime Invoice Date writable
InvoiceNumber varchar2(64) Invoice Number writable
ItemDescription varchar2 Item Description writable
OCR varchar2 Ocr writable
OurReference varchar2(50) Ourreference writable
PaymentPending char Payment Pending writable
Price double Price writable
Project varchar2 Project writable
Project_2 varchar2 Project 2 writable
Quantity int32 Quantity writable
RoundOffValue varchar2 Round Off Value writable
SalesType varchar2 Sales Type writable
StockLocationCode varchar2 Stock Location Code writable
StockPointCode varchar2 Stock Point Code writable
SupplierInvoiceAuthorizerName varchar2 Authorizer Name filters on the platform, writable
SupplierInvoiceBalance varchar2 Balance filters on the platform, writable
SupplierInvoiceBooked char Booked filters on the platform, writable
SupplierInvoiceCancel char Cancel filters on the platform, writable
SupplierInvoiceCostCenter varchar2 Cost Centre filters on the platform, writable
SupplierInvoiceCredit char Credit filters on the platform, writable
SupplierInvoiceCurrency varchar2 Currency filters on the platform, writable
SupplierInvoiceCurrencyRate varchar2 Currency Rate filters on the platform, writable
SupplierInvoiceCurrencyUnit double Currency Unit filters on the platform, writable
SupplierInvoiceDueDate datetime Due Date filters on the platform, writable
SupplierInvoiceExternalInvoiceNumber varchar2 External Invoice Number filters on the platform, writable
SupplierInvoiceExternalInvoiceSeries varchar2 External Invoice Series filters on the platform, writable
SupplierInvoiceFinalPayDate datetime Final Pay Date filters on the platform, writable
SupplierInvoiceGivenNumber varchar2 Given Number filters on the platform, writable
SupplierInvoiceInvoiceDate datetime Invoice Date filters on the platform, writable
SupplierInvoiceInvoiceNumber varchar2 Invoice Number filters on the platform, writable
SupplierInvoiceProject varchar2 Project filters on the platform, writable
SupplierInvoiceSupplierName varchar2 Supplier Name filters on the platform, writable
SupplierInvoiceSupplierNumber varchar2 Supplier Number filters on the platform, writable
SupplierInvoiceTotal varchar2 Total filters on the platform, writable
SupplierInvoicec_url varchar2 Call URL filters on the platform, writable
SupplierName varchar2 Supplier Name writable
SupplierNumber varchar2 Supplier Number writable
Total double Total writable
Total_2 varchar2 Total 2 writable
TransactionInformation varchar2(100) Transaction Information writable
Unit varchar2 Unit writable
VAT varchar2 VAT writable
VATType varchar2 VAT Type writable
VoucherNumber int32 Voucher Number writable
VoucherSeries varchar2 Voucher Series writable
VoucherYear int32 Voucher Year writable
YourReference varchar2(50) Your Reference writable
c_url varchar2 Call URL writable

Release Notes

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