SupplierInvoiceLines: Fortnox Fortnox Supplier Invoice Lines
read only
- Katalog:
Fortnox - Schema:
Views - Label: Fortnox Supplier 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 SupplierInvoiceLines 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 |
Account | writable | ||
Account |
varchar2 |
Beschreibung des Kontos im Hauptbuch | writable | ||
Accounting |
varchar2 |
Bilanzierungsmethode | writable | ||
Administration |
varchar2 |
Verwaltungsgebühr | writable | ||
Article |
varchar2 |
Artikelnummer | writable | ||
Balance |
varchar2 |
Balance | writable | ||
Booked |
char |
Booked | writable | ||
Cancelled |
char |
Cancelled | writable | ||
Code |
varchar2 |
Code | writable | ||
Comments |
varchar2 |
Comments | writable | ||
Cost |
varchar2 |
Kostenstelle | writable | ||
Cost |
varchar2 |
Kostenstelle 2 | writable | ||
Credit |
double |
Credit | writable | ||
Credit |
double |
Kreditwährung | writable | ||
Credit |
int32 |
Bonitätsauskunft | writable | ||
Credit_ |
char |
Quelle 2 | writable | ||
Currency |
varchar2 |
Currency | writable | ||
Currency |
varchar2 |
Währung | writable | ||
Currency |
double |
Währungseinheit | writable | ||
Debit |
double |
Debit | writable | ||
Debit |
double |
Belastungswährung | writable | ||
Disable |
char |
Zahlungsdatei deaktivieren | writable | ||
Due |
datetime |
Fälligkeitsdatum | writable | ||
External |
varchar2 |
Externe Rechnungsnummer | writable | ||
External |
varchar2 |
Externe Rechnungsnummernreihe | writable | ||
Final |
datetime |
Letzter Zahlungstermin | writable | ||
Freight |
varchar2 |
Freight | writable | ||
Given |
varchar2 |
Gegebene Zahl | writable | ||
Invoice |
datetime |
Rechnungsdatum | writable | ||
Invoice |
varchar2 |
Rechnungsnummer | writable | ||
Item |
varchar2 |
Artikelbeschreibung | writable | ||
OCR |
varchar2 |
Ocr | writable | ||
Our |
varchar2 |
Ourreference | writable | ||
Payment |
char |
Zahlung ausstehend | writable | ||
Price |
double |
Price | writable | ||
Project |
varchar2 |
Project | writable | ||
Project_ |
varchar2 |
Projekt 2 | writable | ||
Quantity |
int32 |
Quantity | writable | ||
Round |
varchar2 |
Wert runden | writable | ||
Sales |
varchar2 |
Verkaufstyp | writable | ||
Stock |
varchar2 |
Lagerstandortcode | writable | ||
Stock |
varchar2 |
Lager-Artikelnummer | writable | ||
Supplier |
varchar2 |
Name des Genehmigers | 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 |
Kostenstelle | filters on the platform, writable | ||
Supplier |
char |
Credit | filters on the platform, writable | ||
Supplier |
varchar2 |
Currency | filters on the platform, writable | ||
Supplier |
varchar2 |
Währung | filters on the platform, writable | ||
Supplier |
double |
Währungseinheit | filters on the platform, writable | ||
Supplier |
datetime |
Fälligkeitsdatum | filters on the platform, writable | ||
Supplier |
varchar2 |
Externe Rechnungsnummer | filters on the platform, writable | ||
Supplier |
varchar2 |
Externe Rechnungsnummernreihe | filters on the platform, writable | ||
Supplier |
datetime |
Letzter Zahlungstermin | filters on the platform, writable | ||
Supplier |
varchar2 |
Gegebene Zahl | filters on the platform, writable | ||
Supplier |
datetime |
Rechnungsdatum | filters on the platform, writable | ||
Supplier |
varchar2 |
Rechnungsnummer | filters on the platform, writable | ||
Supplier |
varchar2 |
Project | filters on the platform, writable | ||
Supplier |
varchar2 |
Name des Anbieters | filters on the platform, writable | ||
Supplier |
varchar2 |
Lieferantennummer | filters on the platform, writable | ||
Supplier |
varchar2 |
Total | filters on the platform, writable | ||
Supplier |
varchar2 |
URL aufrufen | filters on the platform, writable | ||
Supplier |
varchar2 |
Name des Anbieters | writable | ||
Supplier |
varchar2 |
Lieferantennummer | writable | ||
Total |
double |
Total | writable | ||
Total_ |
varchar2 |
Insgesamt 2 | writable | ||
Transaction |
varchar2 |
Transaktionsdaten | writable | ||
Unit |
varchar2 |
Unit | writable | ||
VAT |
varchar2 |
VAT | writable | ||
VAT |
varchar2 |
USt. Type | writable | ||
Voucher |
int32 |
Gutscheinnummer | writable | ||
Voucher |
varchar2 |
Gutscheinserie | writable | ||
Voucher |
int32 |
Gutscheinjahr | writable | ||
Your |
varchar2 |
Ihre Referenz | writable | ||
c_url |
varchar2 |
URL aufrufen | writable |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: