ProductionOrderRowNotes: Fortnox Production Order Row Notes
read only REST
- Catalogus:
Fortnox - Schema:
WarehousePurchaseOrders - Label: Production Order Row Notes
List Purchase Orders
List purchase orders matching the given parameters.
Sortable fields: id, supplier_number, order_date, internal_reference, response_state, delivery_date
Kan alleen gegevens ophalen.
Samenvatting
List purchase orders matching the given parameters.
Sortable fields:
id,
supplier_number,
order_date,
internal_reference,
response_state,
delivery_date
API-bron
- Eindpunt:
/api/warehouse/purchaseorders-v1 - Operatie:
get /api/warehouse/purchaseorders-v1
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.
Parameters
| Name | Datatype | 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). | ||
internal |
`` | Include only documents where `internalReference' contains the given text (case-insensitive). | ||
itemId |
`` | Include only documents with the given itemId. |
||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
note |
`` | Include only documents where note-field contains the given text (case-insensitive). |
||
purchase |
`` | Include only documents with the given purchase (Values: WAREHOUSE, DROPSHIP) |
||
q |
`` | Include only documents where id or internal-field contains the given text (case-insensitive). |
||
state |
`` | Include only documents with the given purchase.(Values: NOT_SENT, SENT, SENT_NOT_REJECTED, DELAYED, RECEIVED, VOIDED, CURRENT, ALL) |
||
supplier |
`` | Include only documents with the given supplier. |
||
todate |
`` | Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). |
Tabelkolommen
De kolommen van de tabel ProductionOrderRowNotes 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 |
|---|---|---|---|---|---|
back |
decimal |
Nabestelling Aantal | writable, ::ancestor. |
||
confirmation |
varchar2 |
Bevestiging E-mail | filters on the platform, writable, ::ancestor. |
||
cost |
varchar2 |
Kostenplaatscode | writable, ::ancestor. |
||
cost |
varchar2 |
Kostenplaatscode 2 | filters on the platform, writable, ::ancestor. |
||
currency |
varchar2 |
Valuta Code | writable, ::ancestor. |
||
currency |
varchar2 |
Valuta-code 2 | filters on the platform, writable, ::ancestor. |
||
currency |
decimal |
Valuta Classificatie | filters on the platform, writable, ::ancestor. |
||
currency |
int32 |
Valuta-eenheid | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Klant ID | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Naam Klant | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Klantnummer | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Afleveradres | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Afleveradres 2 | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Afleverstad | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Landcode voor levering | filters on the platform, writable, ::ancestor. |
||
delivery |
datetime |
Leveringsdatum | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Naam van de afzender | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Postcode voor levering | 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 Referentie | filters on the platform, writable, ::ancestor. |
||
is |
char |
Is Voorraadartikel | writable, ::ancestor. |
||
item |
varchar2 |
Artikelomschrijving | writable, ::ancestor. |
||
itemId |
varchar2 |
Artikel ID | writable, ::ancestor. |
||
item |
varchar2 |
Artikel Eenheid | writable, ::ancestor. |
||
language |
varchar2 |
Taalcode | filters on the platform, writable, ::ancestor. |
||
manually |
char |
Handmatig ingevuld | filters on the platform, writable, ::ancestor. |
||
message |
varchar2 |
Bericht aan de leverancier | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
||
note_2 |
varchar2 |
Opmerking 2 | filters on the platform, writable, ::ancestor. |
||
order |
datetime |
Besteldatum | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Bestelwaarde | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Bestelwaarde in SEK | filters on the platform, writable, ::ancestor. |
||
ordered |
decimal |
Bestelde hoeveelheid | writable, ::ancestor. |
||
our |
varchar2 |
Ourreference | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Verwijzing voor uitgaand document | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Referentietype uitgaand document | filters on the platform, writable, ::ancestor. |
||
payment |
varchar2 |
Code betalingsvoorwaarden | filters on the platform, writable, ::ancestor. |
||
price |
decimal |
Price | writable, ::ancestor. |
||
project |
varchar2 |
Project ID | writable, ::ancestor. |
||
project |
varchar2 |
Project-ID 2 | filters on the platform, writable, ::ancestor. |
||
purchase |
int64 |
Inkoopopdracht ID | writable, purchase |
||
purchase |
int64 |
Inkooporder-ID 2 | writable, ::ancestor. |
||
purchase |
guid |
Rowid van inkooporder | writable, purchase |
||
purchase |
varchar2 |
Status van de inkooporder | filters on the platform, writable, ::ancestor. |
||
purchase |
varchar2 |
Aankoopsoort | filters on the platform, writable, ::ancestor. |
||
received |
decimal |
Ontvangen Hoeveelheid | writable, ::ancestor. |
||
remaining |
decimal |
Resterende bestelde hoeveelheid | writable, ::ancestor. |
||
response |
varchar2 |
Status van de reactie | filters on the platform, writable, ::ancestor. |
||
rowNum |
int64 |
Rijnummer | writable, rowNum |
||
row |
int64 |
Rij nummer 2 | writable, ::ancestor. |
||
stock |
varchar2 |
Voorraadlocatiecode | writable, ::ancestor. |
||
stock |
guid |
Voorraadlocatie ID | writable, ::ancestor. |
||
stock |
varchar2 |
Naam van Voorraadlocatie | writable, ::ancestor. |
||
stock |
varchar2 |
Voorraadpuntcode | writable, ::ancestor. |
||
stock |
varchar2 |
Voorraadpuntcode 2 | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
Voorraadpunt-ID | writable, ::ancestor. |
||
stock |
guid |
Voorraadpunt-ID 2 | filters on the platform, writable, ::ancestor. |
||
stock |
varchar2 |
Naam van het voorraadpunt | writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Leverancier Adres | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Adres leverancier 2 | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Leverancier Plaats | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Landcode leverancier | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Leverancier E-mail | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Leveranciersnaam | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Leveranciersnummer | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Postcode leverancier | filters on the platform, writable, ::ancestor. |
||
total |
decimal |
Totaal ontvangen hoeveelheid | filters on the platform, writable, ::ancestor. |
||
translated |
varchar2 |
Vertaalde responsstatus | filters on the platform, writable, ::ancestor. |
||
voided |
char |
Voided | filters on the platform, writable, ::ancestor. |
||
your |
varchar2 |
Uw Referentie | filters on the platform, writable, ::ancestor. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: