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 | ||
Account |
varchar2 |
Grootboekrekeningomschrijving | writable | ||
Accounting |
varchar2 |
Boekhoudmethode | writable | ||
Administration |
varchar2 |
Administratiekosten | writable | ||
Article |
varchar2 |
Artikel Nummer | writable | ||
Balance |
varchar2 |
Balance | writable | ||
Booked |
char |
Booked | writable | ||
Cancelled |
char |
Cancelled | writable | ||
Code |
varchar2 |
Code | writable | ||
Comments |
varchar2 |
Comments | writable | ||
Cost |
varchar2 |
Kostenplaats | writable | ||
Cost |
varchar2 |
Kostenplaats 2 | writable | ||
Credit |
double |
Credit | writable | ||
Credit |
double |
Valuta van de kredietrekening | writable | ||
Credit |
int32 |
Kredietinformatie | writable | ||
Credit_ |
char |
Bronvermelding 2 | writable | ||
Currency |
varchar2 |
Currency | writable | ||
Currency |
varchar2 |
Valuta Classificatie | writable | ||
Currency |
double |
Valuta-eenheid | writable | ||
Debit |
double |
Debit | writable | ||
Debit |
double |
Valuta van de afschrijving | writable | ||
Disable |
char |
Betalingsbestand uitschakelen | writable | ||
Due |
datetime |
Vervaldag | writable | ||
External |
varchar2 |
Extern Factuurnummer | writable | ||
External |
varchar2 |
Reeks externe facturen | writable | ||
Final |
datetime |
Laatste betaaldatum | writable | ||
Freight |
varchar2 |
Freight | writable | ||
Given |
varchar2 |
Gegeven getal | writable | ||
Invoice |
datetime |
Factuurdatum | writable | ||
Invoice |
varchar2 |
Factuurnummer | writable | ||
Item |
varchar2 |
Artikelomschrijving | writable | ||
OCR |
varchar2 |
Ocr | writable | ||
Our |
varchar2 |
Ourreference | writable | ||
Payment |
char |
Betaling in behandeling | writable | ||
Price |
double |
Price | writable | ||
Project |
varchar2 |
Project | writable | ||
Project_ |
varchar2 |
Project 2 | writable | ||
Quantity |
int32 |
Quantity | writable | ||
Round |
varchar2 |
Waarde afronden | writable | ||
Sales |
varchar2 |
Verkoopsoort | writable | ||
Stock |
varchar2 |
Voorraadlocatiecode | writable | ||
Stock |
varchar2 |
Voorraadpuntcode | writable | ||
Supplier |
varchar2 |
Autorisatiegevernaam | filters on the platform, writable | ||
Supplier |
varchar2 |
Balance | filters on the platform, writable | ||
Supplier |
char |
Booked | filters on the platform, writable | ||
Supplier |
char |
Cancel | filters on the platform, writable | ||
Supplier |
varchar2 |
Kostenplaats | filters on the platform, writable | ||
Supplier |
char |
Credit | filters on the platform, writable | ||
Supplier |
varchar2 |
Currency | filters on the platform, writable | ||
Supplier |
varchar2 |
Valuta Classificatie | filters on the platform, writable | ||
Supplier |
double |
Valuta-eenheid | filters on the platform, writable | ||
Supplier |
datetime |
Vervaldag | filters on the platform, writable | ||
Supplier |
varchar2 |
Extern Factuurnummer | filters on the platform, writable | ||
Supplier |
varchar2 |
Reeks externe facturen | filters on the platform, writable | ||
Supplier |
datetime |
Laatste betaaldatum | filters on the platform, writable | ||
Supplier |
varchar2 |
Gegeven getal | filters on the platform, writable | ||
Supplier |
datetime |
Factuurdatum | filters on the platform, writable | ||
Supplier |
varchar2 |
Factuurnummer | filters on the platform, writable | ||
Supplier |
varchar2 |
Project | filters on the platform, writable | ||
Supplier |
varchar2 |
Leveranciersnaam | filters on the platform, writable | ||
Supplier |
varchar2 |
Leveranciersnummer | filters on the platform, writable | ||
Supplier |
varchar2 |
Total | filters on the platform, writable | ||
Supplier |
varchar2 |
Aanroep-URL | filters on the platform, writable | ||
Supplier |
varchar2 |
Leveranciersnaam | writable | ||
Supplier |
varchar2 |
Leveranciersnummer | writable | ||
Total |
double |
Total | writable | ||
Total_ |
varchar2 |
Totaal 2 | writable | ||
Transaction |
varchar2 |
Transactiegegevens | writable | ||
Unit |
varchar2 |
Unit | writable | ||
VAT |
varchar2 |
VAT | writable | ||
VAT |
varchar2 |
BTW Soort | writable | ||
Voucher |
int32 |
Vouchernummer | writable | ||
Voucher |
varchar2 |
Bonseries | writable | ||
Voucher |
int32 |
Voucherjaar | writable | ||
Your |
varchar2 |
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: