OfferByDocumentNumber: Fortnox Offer by Document Number
read only REST
- Katalog:
Fortnox - Schema:
Offers - Label: Offer by Document Number
Retrieve a single offer
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/3/offers/{DocumentNumber} - Operation:
get /3/offers/{DocumentNumber}
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.
Parameter
| Name | Datentyp | Required | Default | Documentation |
|---|---|---|---|---|
Document |
`` | identifies the offer | ||
financialyear |
`` | Selects what financial year that should be used (does not work on every table). | ||
financialyeardate |
`` | Selects by date, what financial year that should be used (does not work on every table). | ||
fromdate |
`` | Defines a selection based on a start date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). | ||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
todate |
`` | Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). |
Tabellenspalten
Die Spalten der Tabelle OfferByDocumentNumber 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 |
|---|---|---|---|---|---|
Offer_ |
varchar2 |
Angebotsadresse 1 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebotsadresse 2 | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Verwaltungsgebühr für das Angebot | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Offer Administration Fee VAT | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Steuerermäßigung auf der Grundlage des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Angebot storniert | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebotsort | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Kommentare zum Angebot | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Angebotsprozentsatz | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Wert des Angebotsbeitrags | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Anzeigentext – Anmerkungen | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Kostenstelle für Angebote | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebotsland | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Währung des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Angebotswechselkurs für die Währung | filters on the platform, writable, Offer. |
||
Offer_ |
int32 |
Angebotswährungseinheit | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot – Name des Kunden | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Kundennummer angeben | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Lieferadresse 1 für das Angebot | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Lieferadresse 2 für das Angebot | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Ort des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Lieferland des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
datetime |
Liefertermin des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Name der Angebotszustellung | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Postleitzahl für die Zustellung des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Nummer des Angebotsdokuments | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot E-Mail-Informationen E-Mail-Adresse Bcc | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot E-Mail-Informationen E-Mail-Adresse CC | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot E-Mail-Informationen E-Mail-Adresse Absender | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot E-Mail-Informationen E-Mail-Adresse an | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Informationen zum Angebot E-Mail-Text | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Informationen zum Angebot per E-Mail Betreff der E-Mail | filters on the platform, writable, Offer. |
||
Offer_ |
datetime |
Ablaufdatum des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Frachtangebot | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Offer Freight VAT | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Angebotsbrutto | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Hausarbeit anbieten | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebotsgeschäftszeichen / Bezug | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Sprache des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Angebotsnetto | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Angebot noch nicht abgeschlossen | filters on the platform, writable, Offer. |
||
Offer_ |
datetime |
Angebotsdatum | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebots- und Auftragsgeschäftszeichen | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebotsnummer der Organisation | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot von Ourreference | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot Telefon 1 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot Telefon 2 | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebots-Preisliste | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebotsschablone drucken | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Projektangebot | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Anmerkungen zum Angebot | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Angebot abrunden | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Angebot gesendet | filters on the platform, writable, Offer. |
||
Offer_ |
int32 |
Steuererleichterung anbieten | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Art der Steuerermäßigung | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Lieferbedingungen des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Zahlungsbedingungen des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Gesamtbetrag des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Gesamtbetrag des Angebots | filters on the platform, writable, Offer. |
||
Offer_ |
double |
Offer Total VAT | filters on the platform, writable, Offer. |
||
Offer_ |
char |
Angebot inklusive Mehrwertsteuer | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot – Versandart | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Geben Sie Ihr Geschäftszeichen / Bezug an | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Geben Sie Ihre Referenznummer an | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebot Postleitzahl | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Angebots-URL | filters on the platform, writable, Offer. |
||
Offer_ |
varchar2 |
Liste der Steuererleichterungen für Angebots-URLs | filters on the platform, writable, Offer. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: