invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SupplierInvoiceLines: Fortnox Fortnox Supplier Invoice Lines

read only

  • Catalogus: Fortnox
  • Schema: Views
  • Label: Fortnox Supplier Invoice Lines

Kan alleen gegevens ophalen.

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 356
Aantal rijen per minuut bij volledige scan 85,000
Aantal rijen per minuut in een Query 168

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel SupplierInvoiceLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
Account int32 Account writable
AccountDescription varchar2 Grootboekrekeningomschrijving writable
AccountingMethod varchar2 Boekhoudmethode writable
AdministrationFee varchar2 Administratiekosten writable
ArticleNumber varchar2 Artikel Nummer writable
Balance varchar2 Balance writable
Booked char Booked writable
Cancelled char Cancelled writable
Code varchar2 Code writable
Comments varchar2(1000) Comments writable
CostCenter varchar2 Kostenplaats writable
CostCenter_2 varchar2 Kostenplaats 2 writable
Credit double Credit writable
CreditCurrency double Valuta van de kredietrekening writable
CreditReference int32 Kredietinformatie writable
Credit_2 char Bronvermelding 2 writable
Currency varchar2 Currency writable
CurrencyRate varchar2 Valuta Classificatie writable
CurrencyUnit double Valuta-eenheid writable
Debit double Debit writable
DebitCurrency double Valuta van de afschrijving writable
DisablePaymentFile char Betalingsbestand uitschakelen writable
DueDate datetime Vervaldag writable
ExternalInvoiceNumber varchar2 Extern Factuurnummer writable
ExternalInvoiceSeries varchar2 Reeks externe facturen writable
FinalPayDate datetime Laatste betaaldatum writable
Freight varchar2 Freight writable
GivenNumber varchar2 Gegeven getal writable
InvoiceDate datetime Factuurdatum writable
InvoiceNumber varchar2(64) Factuurnummer writable
ItemDescription varchar2 Artikelomschrijving writable
OCR varchar2 Ocr writable
OurReference varchar2(50) Ourreference writable
PaymentPending char Betaling in behandeling writable
Price double Price writable
Project varchar2 Project writable
Project_2 varchar2 Project 2 writable
Quantity int32 Quantity writable
RoundOffValue varchar2 Waarde afronden writable
SalesType varchar2 Verkoopsoort writable
StockLocationCode varchar2 Voorraadlocatiecode writable
StockPointCode varchar2 Voorraadpuntcode writable
SupplierInvoiceAuthorizerName varchar2 Autorisatiegevernaam 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 Kostenplaats filters on the platform, writable
SupplierInvoiceCredit char Credit filters on the platform, writable
SupplierInvoiceCurrency varchar2 Currency filters on the platform, writable
SupplierInvoiceCurrencyRate varchar2 Valuta Classificatie filters on the platform, writable
SupplierInvoiceCurrencyUnit double Valuta-eenheid filters on the platform, writable
SupplierInvoiceDueDate datetime Vervaldag filters on the platform, writable
SupplierInvoiceExternalInvoiceNumber varchar2 Extern Factuurnummer filters on the platform, writable
SupplierInvoiceExternalInvoiceSeries varchar2 Reeks externe facturen filters on the platform, writable
SupplierInvoiceFinalPayDate datetime Laatste betaaldatum filters on the platform, writable
SupplierInvoiceGivenNumber varchar2 Gegeven getal filters on the platform, writable
SupplierInvoiceInvoiceDate datetime Factuurdatum filters on the platform, writable
SupplierInvoiceInvoiceNumber varchar2 Factuurnummer filters on the platform, writable
SupplierInvoiceProject varchar2 Project filters on the platform, writable
SupplierInvoiceSupplierName varchar2 Leveranciersnaam filters on the platform, writable
SupplierInvoiceSupplierNumber varchar2 Leveranciersnummer filters on the platform, writable
SupplierInvoiceTotal varchar2 Total filters on the platform, writable
SupplierInvoicec_url varchar2 Aanroep-URL filters on the platform, writable
SupplierName varchar2 Leveranciersnaam writable
SupplierNumber varchar2 Leveranciersnummer writable
Total double Total writable
Total_2 varchar2 Totaal 2 writable
TransactionInformation varchar2(100) Transactiegegevens writable
Unit varchar2 Unit writable
VAT varchar2 VAT writable
VATType varchar2 BTW Soort writable
VoucherNumber int32 Vouchernummer writable
VoucherSeries varchar2 Bonseries writable
VoucherYear int32 Voucherjaar writable
YourReference varchar2(50) Uw Referentie writable
c_url varchar2 Aanroep-URL writable

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: