PurchaseOrderRowNotesById: Fortnox Purchase Order Row Notes by ID
read only REST
- Katalog:
Fortnox - Schema:
WarehousePurchaseOrders - Label: Purchase Order Row Notes by ID
Get Purchase Order
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/api/warehouse/purchaseorders-v1/{id} - Operation:
get /api/warehouse/purchaseorders-v1/{id}
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 |
|---|---|---|---|---|
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). | ||
id |
`` | Purchase order id. | ||
ignore |
`` | used for calculating the remaining ordered quantity. null will take the received quantity from all incoming goods | ||
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 PurchaseOrderRowNotesById 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 |
|---|---|---|---|---|---|
back |
decimal |
Rückstandsmenge | writable, ::ancestor. |
||
confirmation |
varchar2 |
Bestätigungs-E-Mail | filters on the platform, writable, ::ancestor. |
||
cost |
varchar2 |
Kostenstelle-Code | writable, ::ancestor. |
||
cost |
varchar2 |
Kostenstelle 2 | filters on the platform, writable, ::ancestor. |
||
currency |
varchar2 |
Währungscode | writable, ::ancestor. |
||
currency |
varchar2 |
Währungscode 2 | filters on the platform, writable, ::ancestor. |
||
currency |
decimal |
Währung | filters on the platform, writable, ::ancestor. |
||
currency |
int32 |
Währungseinheit | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Kunden-ID | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Name des Kunden | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Kundennummer | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Lieferadresse | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Lieferadresse 2 | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Stadt der Lieferung | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Ländercode für die Lieferung | filters on the platform, writable, ::ancestor. |
||
delivery |
datetime |
Liefertermin | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Name des Lieferanten | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Postleitzahl für die Lieferung | filters on the platform, writable, ::ancestor. |
||
dropship |
char |
Dropship | filters on the platform, writable, ::ancestor. |
||
id |
guid |
ID | writable, ::ancestor. |
||
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
||
internal |
varchar2 |
Interne Geschäftszeichen / Bezug | filters on the platform, writable, ::ancestor. |
||
is |
char |
Ist Lagerware? | writable, ::ancestor. |
||
item |
varchar2 |
Artikelbeschreibung | writable, ::ancestor. |
||
itemId |
varchar2 |
Artikel ID | writable, ::ancestor. |
||
item |
varchar2 |
Artikel Einheit | writable, ::ancestor. |
||
language |
varchar2 |
Sprachen-Code | filters on the platform, writable, ::ancestor. |
||
manually |
char |
Manuell ausgefüllt | filters on the platform, writable, ::ancestor. |
||
message |
varchar2 |
Nachricht an den Lieferanten | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
||
note_2 |
varchar2 |
Anmerkung 2 | filters on the platform, writable, ::ancestor. |
||
order |
datetime |
Orderdatum | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Bestellwert | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Bestellwert in SEK | filters on the platform, writable, ::ancestor. |
||
ordered |
decimal |
Bestellte Menge | writable, ::ancestor. |
||
our |
varchar2 |
Ourreference | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Geschäftszeichen / Bezug des ausgehenden Dokuments | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Referenztyp für ausgehende Dokumente | filters on the platform, writable, ::ancestor. |
||
payment |
varchar2 |
Code für Zahlungsbedingungen | filters on the platform, writable, ::ancestor. |
||
price |
decimal |
Price | writable, ::ancestor. |
||
project |
varchar2 |
Projekt ID | writable, ::ancestor. |
||
project |
varchar2 |
Projekt-ID 2 | filters on the platform, writable, ::ancestor. |
||
purchase |
int64 |
Bestellnummer | writable, purchase |
||
purchase |
int64 |
Bestellnummer 2 | writable, ::ancestor. |
||
purchase |
guid |
Bestell-ROWID | writable, purchase |
||
purchase |
varchar2 |
Status der Bestellung | filters on the platform, writable, ::ancestor. |
||
purchase |
varchar2 |
Art des Kaufs | filters on the platform, writable, ::ancestor. |
||
received |
decimal |
Erhaltene Menge | writable, ::ancestor. |
||
remaining |
decimal |
Verbleibende Bestellmenge | writable, ::ancestor. |
||
response |
varchar2 |
Antwortstatus | filters on the platform, writable, ::ancestor. |
||
rowNum |
int64 |
Zeilennummer | writable, rowNum |
||
row |
int64 |
Zeile 2 | writable, ::ancestor. |
||
stock |
varchar2 |
Lagerstandortcode | writable, ::ancestor. |
||
stock |
guid |
Lagerort-ID | writable, ::ancestor. |
||
stock |
varchar2 |
Name des Lagerorts | writable, ::ancestor. |
||
stock |
varchar2 |
Lager-Artikelnummer | writable, ::ancestor. |
||
stock |
varchar2 |
Lager-Artikelnummer 2 | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
Lagerort-ID | writable, ::ancestor. |
||
stock |
guid |
Lagerort-ID 2 | filters on the platform, writable, ::ancestor. |
||
stock |
varchar2 |
Name des Lagerpunkts | writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Lieferantenadresse | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Lieferantenadresse 2 | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Lieferantenort | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Ländercode des Lieferanten | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
E-Mail-Adresse des Lieferanten | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Name des Anbieters | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Lieferantennummer | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Postleitzahl des Lieferanten | filters on the platform, writable, ::ancestor. |
||
total |
decimal |
Gesamtmenge (eingegangen) | filters on the platform, writable, ::ancestor. |
||
translated |
varchar2 |
Übersetzter Antwortstatus | filters on the platform, writable, ::ancestor. |
||
voided |
char |
Voided | filters on the platform, writable, ::ancestor. |
||
your |
varchar2 |
Ihre Referenz | filters on the platform, writable, ::ancestor. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: