InvoiceLines: Fortnox Fortnox Invoice Lines
read only
- Katalog:
Fortnox - Schema:
Views - Label: Fortnox Invoice Lines
Es können nur Daten abgerufen werden.
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 356 |
| Anzahl der Vollscan-Zeilen pro Minute | 85,000 |
| Anzahl der Query-Zeilen pro Minute | 168 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle InvoiceLines sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
int32 |
Kontonummer | writable | ||
Accounting |
varchar2 |
Bilanzierungsmethode | writable | ||
Address1 |
varchar2 |
Adresszeile 1 | writable | ||
Address2 |
varchar2 |
Adresszeile 2 | writable | ||
Administration |
double |
Verwaltungsgebühr | writable | ||
Administration |
double |
Administration Fee VAT | writable | ||
Article |
varchar2 |
Artikelnummer | writable | ||
Balance |
double |
Balance | writable | ||
Basis |
double |
Steuerermäßigung auf der Bemessungsgrundlage | writable | ||
Booked |
char |
Booked | writable | ||
Cancelled |
char |
Cancelled | writable | ||
City |
varchar2 |
City | writable | ||
Comments |
varchar2 |
Comments | writable | ||
Contract |
int32 |
Geschäftszeichen / Bezug | writable | ||
Contribution |
varchar2 |
Beitragsprozentsatz | writable | ||
Contribution |
double |
Beitragsprozentsatz 2 | writable | ||
Contribution |
varchar2 |
Beitragswert | writable | ||
Contribution |
double |
Beitragswert 2 | writable | ||
Cost |
varchar2 |
Kostenstelle | writable | ||
Cost |
varchar2 |
Kostenstelle 2 | writable | ||
Country |
varchar2 |
Country | writable | ||
Credit |
varchar2 |
Credit | writable | ||
Credit |
varchar2 |
Geschäftszeichen der Gutschriftsrechnung | writable | ||
Currency |
varchar2 |
Currency | writable | ||
Currency |
double |
Währung | writable | ||
Currency |
int32 |
Währungseinheit | writable | ||
Customer |
varchar2 |
Name des Kunden | writable | ||
Customer |
varchar2 |
Kundennummer | writable | ||
Delivered |
varchar2 |
Gelieferte Menge | writable | ||
Delivery |
varchar2 |
Lieferadresse 1 | writable | ||
Delivery |
varchar2 |
Lieferadresse 2 | writable | ||
Delivery |
varchar2 |
Stadt der Lieferung | writable | ||
Delivery |
varchar2 |
Land der Lieferung | writable | ||
Delivery |
datetime |
Liefertermin | writable | ||
Delivery |
varchar2 |
Name des Lieferanten | writable | ||
Delivery |
varchar2 |
Postleitzahl für die Lieferung | writable | ||
Description |
varchar2 |
Description | writable | ||
Discount |
double |
Discount | writable | ||
Discount |
varchar2 |
Rabatttyp | writable | ||
Document |
varchar2 |
Dokumentnummer | writable | ||
Due |
datetime |
Fälligkeitsdatum | writable | ||
EDI |
varchar2 |
EDI-Informationen – Globale EDI-Standortnummer | writable | ||
EDI |
varchar2 |
EDI-Informationen – EDI Global Location Number – Übermittlung | writable | ||
EDI |
varchar2 |
EDI-Informationen – EDI-Rechnung Extra 1 | writable | ||
EDI |
varchar2 |
EDI-Informationen – EDI-Rechnung Extra 2 | writable | ||
EDI |
varchar2 |
EDI-Informationen EDI – Unser elektronisches Geschäftszeichen / Bezug | writable | ||
EDI |
varchar2 |
EDI-Informationen EDI-Status | writable | ||
EDI |
varchar2 |
EDI-Informationen – EDI: Ihr elektronisches Geschäftszeichen / Bezug | writable | ||
EU |
char |
EU-Quartalsbericht | writable | ||
Email |
varchar2 |
E-Mail-Informationen E-Mail-Adresse Bcc | writable | ||
Email |
varchar2 |
E-Mail-Informationen E-Mail-Adresse CC | writable | ||
Email |
varchar2 |
E-Mail-Informationen Absender-E-Mail-Adresse | writable | ||
Email |
varchar2 |
E-Mail-Informationen E-Mail-Adresse An | writable | ||
Email |
varchar2 |
E-Mail-Informationen E-Mail-Text | writable | ||
Email |
varchar2 |
E-Mail-Informationen E-Mail-Betreff | writable | ||
External |
varchar2 |
Externe Geschäftszeichen / Bezug 1 | writable | ||
External |
varchar2 |
Externe Geschäftszeichen / Bezug 2 | writable | ||
Final |
datetime |
Letzter Zahlungstermin | writable | ||
Freight |
double |
Freight | writable | ||
Freight |
double |
Mehrwertsteuer auf Frachtkosten | writable | ||
Gross |
double |
Gross | writable | ||
House |
char |
Hausarbeit | writable | ||
House |
int32 |
Zu erstellenden Berichten über die im Haushalt zu meldenden Arbeitsstunden | writable | ||
House |
varchar2 |
Haus-Arbeitstyp | writable | ||
House |
char |
Hausarbeit 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 |
Kostenstelle | filters on the platform, writable | ||
Invoice |
varchar2 |
Currency | filters on the platform, writable | ||
Invoice |
double |
Währung | filters on the platform, writable | ||
Invoice |
double |
Währungseinheit | filters on the platform, writable | ||
Invoice |
varchar2 |
Name des Kunden | filters on the platform, writable | ||
Invoice |
varchar2 |
Kundennummer | filters on the platform, writable | ||
Invoice |
datetime |
Rechnungsdatum | writable | ||
Invoice |
varchar2 |
Dokumentnummer | filters on the platform, writable | ||
Invoice |
datetime |
Fälligkeitsdatum | filters on the platform, writable | ||
Invoice |
varchar2 |
Externe Geschäftszeichen / Bezug 1 | filters on the platform, writable | ||
Invoice |
varchar2 |
Externe Geschäftszeichen / Bezug 2 | filters on the platform, writable | ||
Invoice |
datetime |
Letzter Zahlungstermin | filters on the platform, writable | ||
Invoice |
datetime |
Rechnungsdatum | filters on the platform, writable | ||
Invoice |
varchar2 |
Rechnungsart | filters on the platform, writable | ||
Invoice |
char |
Nox Finans | filters on the platform, writable | ||
Invoice |
varchar2 |
Ocr | filters on the platform, writable | ||
Invoice |
datetime |
Ende des Abrechnungszeitraums | writable | ||
Invoice |
varchar2 |
Geschäftszeichen / Bezug zum Rechnungszeitraum | writable | ||
Invoice |
datetime |
Beginn des Abrechnungszeitraums | writable | ||
Invoice |
varchar2 |
Project | filters on the platform, writable | ||
Invoice |
char |
Sent | filters on the platform, writable | ||
Invoice |
varchar2 |
Zahlungsbedingungen | filters on the platform, writable | ||
Invoice |
double |
Total | filters on the platform, writable | ||
Invoice |
varchar2 |
Rechnungsart | writable | ||
Invoice |
int32 |
Gutscheinnummer | filters on the platform, writable | ||
Invoice |
varchar2 |
Gutscheinserie | filters on the platform, writable | ||
Invoice |
int32 |
Gutscheinjahr | filters on the platform, writable | ||
Invoice |
varchar2 |
Versandart | filters on the platform, writable | ||
Invoicec_ |
varchar2 |
URL aufrufen | filters on the platform, writable | ||
Language |
varchar2 |
Language | writable | ||
Last |
datetime |
Letzter Termin zur Erinnerung | writable | ||
Net |
double |
Net | writable | ||
Not |
char |
Notcompleted | writable | ||
Nox |
char |
Nox Finans | writable | ||
OCR |
varchar2 |
Ocr | writable | ||
Offer |
varchar2 |
Angebotsgeschäftszeichen / Bezug | writable | ||
Order |
varchar2 |
Auftragsreferenz | writable | ||
Organisation |
varchar2 |
Organisationsnummer | writable | ||
Our |
varchar2 |
Ourreference | writable | ||
Outbound |
datetime |
Versanddatum | writable | ||
Payment |
varchar2 |
Zahlungsart | writable | ||
Phone1 |
varchar2 |
Telefon 1 | writable | ||
Phone2 |
varchar2 |
Telefon 2 | writable | ||
Price |
double |
Price | writable | ||
Price |
double |
Preis ohne Mehrwertsteuer | writable | ||
Price |
varchar2 |
Preisliste | writable | ||
Print |
varchar2 |
Druck-Schablone | writable | ||
Project |
varchar2 |
Project | writable | ||
Project_ |
varchar2 |
Projekt 2 | writable | ||
Remarks |
varchar2 |
Remarks | writable | ||
Reminders |
int32 |
Reminders | writable | ||
Round |
double |
Abrunden | writable | ||
RowId |
int32 |
Zeilen-ID | writable | ||
Sent |
char |
Sent | writable | ||
Stock |
varchar2 |
Lager-Artikelnummer | writable | ||
Tax |
int32 |
Steuersenkung | writable | ||
Tax |
varchar2 |
Art der Steuerermäßigung | writable | ||
Terms |
varchar2 |
Lieferbedingungen | writable | ||
Terms |
varchar2 |
Zahlungsbedingungen | writable | ||
Time |
int32 |
Zeitliche Bezugsgrundlage | writable | ||
Total |
double |
Total | writable | ||
Total |
double |
Gesamtbetrag ohne Mehrwertsteuer | writable | ||
Total |
double |
Zu zahlender Gesamtbetrag | writable | ||
Total |
double |
Total VAT | writable | ||
Total_ |
double |
Insgesamt 2 | writable | ||
Unit |
varchar2 |
Unit | writable | ||
VAT |
int32 |
VAT | writable | ||
VAT |
varchar2 |
Umsatzsteuer-IDNr. | writable | ||
VAT |
char |
Vatincluded | writable | ||
Voucher |
int32 |
Gutscheinnummer | writable | ||
Voucher |
varchar2 |
Gutscheinserie | writable | ||
Voucher |
int32 |
Gutscheinjahr | writable | ||
Warehouse |
char |
Auf Lager | writable | ||
Way |
varchar2 |
Versandart | writable | ||
Your |
varchar2 |
Ihre Bestellnummer | writable | ||
Your |
varchar2 |
Ihre Referenz | writable | ||
Zip |
varchar2 |
Postleitzahl | writable | ||
c_url |
varchar2 |
URL aufrufen | writable | ||
c_ |
varchar2 |
Liste der URL-Steuerermäßigungen | writable |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: