InvoiceLines: Fortnox Fortnox Invoice Lines
read only
- Catalogus:
Fortnox - Schema:
Views - Label: Fortnox 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 InvoiceLines 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 |
Rekeningnummer | writable | ||
Accounting |
varchar2 |
Boekhoudmethode | writable | ||
Address1 |
varchar2 |
Adresregel 1 | writable | ||
Address2 |
varchar2 |
Adresregel 2 | writable | ||
Administration |
double |
Administratiekosten | writable | ||
Administration |
double |
Administratiekosten BTW | writable | ||
Article |
varchar2 |
Artikel Nummer | writable | ||
Balance |
double |
Balance | writable | ||
Basis |
double |
Basisbelastingvermindering | writable | ||
Booked |
char |
Booked | writable | ||
Cancelled |
char |
Cancelled | writable | ||
City |
varchar2 |
City | writable | ||
Comments |
varchar2 |
Comments | writable | ||
Contract |
int32 |
Contractnummer | writable | ||
Contribution |
varchar2 |
Bijdragepercentage | writable | ||
Contribution |
double |
Bijdragepercentage 2 | writable | ||
Contribution |
varchar2 |
Bijdragewaarde | writable | ||
Contribution |
double |
Bijdragewaarde 2 | writable | ||
Cost |
varchar2 |
Kostenplaats | writable | ||
Cost |
varchar2 |
Kostenplaats 2 | writable | ||
Country |
varchar2 |
Country | writable | ||
Credit |
varchar2 |
Credit | writable | ||
Credit |
varchar2 |
Verwijzing kredietfactuur | writable | ||
Currency |
varchar2 |
Currency | writable | ||
Currency |
double |
Valuta Classificatie | writable | ||
Currency |
int32 |
Valuta-eenheid | writable | ||
Customer |
varchar2 |
Naam Klant | writable | ||
Customer |
varchar2 |
Klantnummer | writable | ||
Delivered |
varchar2 |
Geleverde Hoeveelheid | writable | ||
Delivery |
varchar2 |
Afleveradres 1 | writable | ||
Delivery |
varchar2 |
Afleveradres 2 | writable | ||
Delivery |
varchar2 |
Afleverstad | writable | ||
Delivery |
varchar2 |
Leveringsland | writable | ||
Delivery |
datetime |
Leveringsdatum | writable | ||
Delivery |
varchar2 |
Naam van de afzender | writable | ||
Delivery |
varchar2 |
Postcode voor levering | writable | ||
Description |
varchar2 |
Description | writable | ||
Discount |
double |
Discount | writable | ||
Discount |
varchar2 |
Kortingssoort | writable | ||
Document |
varchar2 |
Documentnummer | writable | ||
Due |
datetime |
Vervaldag | writable | ||
EDI |
varchar2 |
EDI-informatie EDI Global Location Number | writable | ||
EDI |
varchar2 |
EDI-informatie EDI Global Location Number-verzending | writable | ||
EDI |
varchar2 |
EDI-informatie EDI-factuur Extra 1 | writable | ||
EDI |
varchar2 |
EDI-informatie EDI-factuur Extra 2 | writable | ||
EDI |
varchar2 |
EDI-informatie EDI Onze elektronische verwijzing | writable | ||
EDI |
varchar2 |
EDI-informatie EDI-status | writable | ||
EDI |
varchar2 |
EDI-informatie EDI: uw elektronische verwijzing | writable | ||
EU |
char |
EU-kwartaalrapport | writable | ||
Email |
varchar2 |
E-mailgegevens E-mailadres Bcc | writable | ||
Email |
varchar2 |
E-mailgegevens CC-e-mail | writable | ||
Email |
varchar2 |
E-mailgegevens E-mailadres Van | writable | ||
Email |
varchar2 |
E-mailgegevens E-mailadres Aan | writable | ||
Email |
varchar2 |
E-mailgegevens E-mailtekst | writable | ||
Email |
varchar2 |
E-mailgegevens Onderwerp van de e-mail | writable | ||
External |
varchar2 |
Externe factuurnummer 1 | writable | ||
External |
varchar2 |
Externe factuurnummer 2 | writable | ||
Final |
datetime |
Laatste betaaldatum | writable | ||
Freight |
double |
Freight | writable | ||
Freight |
double |
BTW op vrachtvervoer | writable | ||
Gross |
double |
Gross | writable | ||
House |
char |
Huishoudelijk werk | writable | ||
House |
int32 |
Rapport over werkuren thuis | writable | ||
House |
varchar2 |
Type woning | writable | ||
House |
char |
Huishoudelijk werk 2 | writable | ||
Invoice |
double |
Balance | filters on the platform, writable | ||
Invoice |
char |
Booked | filters on the platform, writable | ||
Invoice |
char |
Cancelled | filters on the platform, writable | ||
Invoice |
varchar2 |
Kostenplaats | filters on the platform, writable | ||
Invoice |
varchar2 |
Currency | filters on the platform, writable | ||
Invoice |
double |
Valuta Classificatie | filters on the platform, writable | ||
Invoice |
double |
Valuta-eenheid | filters on the platform, writable | ||
Invoice |
varchar2 |
Naam Klant | filters on the platform, writable | ||
Invoice |
varchar2 |
Klantnummer | filters on the platform, writable | ||
Invoice |
datetime |
Factuurdatum | writable | ||
Invoice |
varchar2 |
Documentnummer | filters on the platform, writable | ||
Invoice |
datetime |
Vervaldag | filters on the platform, writable | ||
Invoice |
varchar2 |
Externe factuurnummer 1 | filters on the platform, writable | ||
Invoice |
varchar2 |
Externe factuurnummer 2 | filters on the platform, writable | ||
Invoice |
datetime |
Laatste betaaldatum | filters on the platform, writable | ||
Invoice |
datetime |
Factuurdatum | filters on the platform, writable | ||
Invoice |
varchar2 |
Factuur Soort | filters on the platform, writable | ||
Invoice |
char |
Nox Finans | filters on the platform, writable | ||
Invoice |
varchar2 |
Ocr | filters on the platform, writable | ||
Invoice |
datetime |
Einde factuurperiode | writable | ||
Invoice |
varchar2 |
Referentie factuurperiode | writable | ||
Invoice |
datetime |
Begin factuurperiode | writable | ||
Invoice |
varchar2 |
Project | filters on the platform, writable | ||
Invoice |
char |
Sent | filters on the platform, writable | ||
Invoice |
varchar2 |
Betalingsvoorwaarden | filters on the platform, writable | ||
Invoice |
double |
Total | filters on the platform, writable | ||
Invoice |
varchar2 |
Factuur Soort | writable | ||
Invoice |
int32 |
Vouchernummer | filters on the platform, writable | ||
Invoice |
varchar2 |
Bonseries | filters on the platform, writable | ||
Invoice |
int32 |
Voucherjaar | filters on the platform, writable | ||
Invoice |
varchar2 |
Wijze van levering | filters on the platform, writable | ||
Invoicec_ |
varchar2 |
Aanroep-URL | filters on the platform, writable | ||
Language |
varchar2 |
Language | writable | ||
Last |
datetime |
Uiterste herinneringsdatum | writable | ||
Net |
double |
Net | writable | ||
Not |
char |
Notcompleted | writable | ||
Nox |
char |
Nox Finans | writable | ||
OCR |
varchar2 |
Ocr | writable | ||
Offer |
varchar2 |
Verwijzing van de aanbieding | writable | ||
Order |
varchar2 |
Order Referentie | writable | ||
Organisation |
varchar2 |
Organisatienummer | writable | ||
Our |
varchar2 |
Ourreference | writable | ||
Outbound |
datetime |
Verzenddatum | writable | ||
Payment |
varchar2 |
Betaalwijze | writable | ||
Phone1 |
varchar2 |
Telefoon 1 | writable | ||
Phone2 |
varchar2 |
Telefoon 2 | writable | ||
Price |
double |
Price | writable | ||
Price |
double |
Prijs exclusief BTW | writable | ||
Price |
varchar2 |
Prijslijst | writable | ||
Print |
varchar2 |
Afdruksjabloon | writable | ||
Project |
varchar2 |
Project | writable | ||
Project_ |
varchar2 |
Project 2 | writable | ||
Remarks |
varchar2 |
Remarks | writable | ||
Reminders |
int32 |
Reminders | writable | ||
Round |
double |
Afronden | writable | ||
RowId |
int32 |
Rij ID | writable | ||
Sent |
char |
Sent | writable | ||
Stock |
varchar2 |
Voorraadpuntcode | writable | ||
Tax |
int32 |
Belastingvermindering | writable | ||
Tax |
varchar2 |
Soort belastingvermindering | writable | ||
Terms |
varchar2 |
Leveringsvoorwaarden | writable | ||
Terms |
varchar2 |
Betalingsvoorwaarden | writable | ||
Time |
int32 |
Tijdbasisverwijzing | writable | ||
Total |
double |
Total | writable | ||
Total |
double |
Totaal Exclusief BTW | writable | ||
Total |
double |
Totaal te betalen bedrag | writable | ||
Total |
double |
Totaal BTW | writable | ||
Total_ |
double |
Totaal 2 | writable | ||
Unit |
varchar2 |
Unit | writable | ||
VAT |
int32 |
VAT | writable | ||
VAT |
varchar2 |
BTW-code | writable | ||
VAT |
char |
Vatincluded | writable | ||
Voucher |
int32 |
Vouchernummer | writable | ||
Voucher |
varchar2 |
Bonseries | writable | ||
Voucher |
int32 |
Voucherjaar | writable | ||
Warehouse |
char |
Klaar voor opslag | writable | ||
Way |
varchar2 |
Wijze van levering | writable | ||
Your |
varchar2 |
Uw bestelnummer | writable | ||
Your |
varchar2 |
Uw Referentie | writable | ||
Zip |
varchar2 |
Postcode | writable | ||
c_url |
varchar2 |
Aanroep-URL | writable | ||
c_ |
varchar2 |
Lijst met belastingverminderingen voor URL’s | writable |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: