ProductionOrderRowNotes: Fortnox Production Order Row Notes
read only REST
- Catalogue :
Fortnox - Schéma :
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
Permet uniquement de récupérer des données.
Résumé
List purchase orders matching the given parameters.
Sortable fields:
id,
supplier_number,
order_date,
internal_reference,
response_state,
delivery_date
Source de l'API
- Point de terminaison :
/api/warehouse/purchaseorders-v1 - Opération :
get /api/warehouse/purchaseorders-v1
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 356 |
| Nombre de lignes par minute en mode de balayage complet | 85,000 |
| Nombre de lignes de requêtes ponctuelles par minute | 168 |
Le résultat peut être mis en cache côté client.
Paramètres
| Name | Type de données | 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). |
Colonnes de table
Les colonnes de la table ProductionOrderRowNotes sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
back |
decimal |
Quantité en attente de livraison | writable, ::ancestor. |
||
confirmation |
varchar2 |
E-mail de confirmation | filters on the platform, writable, ::ancestor. |
||
cost |
varchar2 |
Coût Code Center | writable, ::ancestor. |
||
cost |
varchar2 |
Code du centre de coûts 2 | filters on the platform, writable, ::ancestor. |
||
currency |
varchar2 |
Code de devise | writable, ::ancestor. |
||
currency |
varchar2 |
Code de devise 2 | filters on the platform, writable, ::ancestor. |
||
currency |
decimal |
Taux de change de la devise | filters on the platform, writable, ::ancestor. |
||
currency |
int32 |
Devise | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
ID de cliente | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Nom du client | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Numéro de client | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Adresse de livraison | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Adresse de livraison 2 | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Ville de livraison | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Code pays de livraison | filters on the platform, writable, ::ancestor. |
||
delivery |
datetime |
Date de livraison | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Nom du destinataire | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Code postal de livraison | 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 |
Référence interne | filters on the platform, writable, ::ancestor. |
||
is |
char |
Article en stock ? | writable, ::ancestor. |
||
item |
varchar2 |
Description de l’article | writable, ::ancestor. |
||
itemId |
varchar2 |
ID de l'article | writable, ::ancestor. |
||
item |
varchar2 |
Article Unité | writable, ::ancestor. |
||
language |
varchar2 |
Code de langue | filters on the platform, writable, ::ancestor. |
||
manually |
char |
Rempli manuellement | filters on the platform, writable, ::ancestor. |
||
message |
varchar2 |
Message à l'attention du fournisseur | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
||
note_2 |
varchar2 |
Note 2 | filters on the platform, writable, ::ancestor. |
||
order |
datetime |
Date de la commande | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Montant de la commande | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Montant de la commande en SEK | filters on the platform, writable, ::ancestor. |
||
ordered |
decimal |
Quantité commandée | writable, ::ancestor. |
||
our |
varchar2 |
Ourreference | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Référence du document sortant | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Type de référence des documents sortants | filters on the platform, writable, ::ancestor. |
||
payment |
varchar2 |
Code des conditions de paiement | filters on the platform, writable, ::ancestor. |
||
price |
decimal |
Price | writable, ::ancestor. |
||
project |
varchar2 |
Identifiant du projet | writable, ::ancestor. |
||
project |
varchar2 |
Identifiant du projet 2 | filters on the platform, writable, ::ancestor. |
||
purchase |
int64 |
ID de bon de commande | writable, purchase |
||
purchase |
int64 |
Référence de bon de commande n° 2 | writable, ::ancestor. |
||
purchase |
guid |
ID de ligne de bon de commande | writable, purchase |
||
purchase |
varchar2 |
Statut de la commande d'achat | filters on the platform, writable, ::ancestor. |
||
purchase |
varchar2 |
Type d'achat | filters on the platform, writable, ::ancestor. |
||
received |
decimal |
Quantité réceptionnée | writable, ::ancestor. |
||
remaining |
decimal |
Quantité restante commandée | writable, ::ancestor. |
||
response |
varchar2 |
État de la réponse | filters on the platform, writable, ::ancestor. |
||
rowNum |
int64 |
Numéro de ligne | writable, rowNum |
||
row |
int64 |
Ligne n° 2 | writable, ::ancestor. |
||
stock |
varchar2 |
Code d'emplacement des stocks | writable, ::ancestor. |
||
stock |
guid |
Référence de l'emplacement de stock | writable, ::ancestor. |
||
stock |
varchar2 |
Nom du lieu de stockage | writable, ::ancestor. |
||
stock |
varchar2 |
Code de référence | writable, ::ancestor. |
||
stock |
varchar2 |
Code de référence 2 | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
Référence de stock | writable, ::ancestor. |
||
stock |
guid |
Référence de stock n° 2 | filters on the platform, writable, ::ancestor. |
||
stock |
varchar2 |
Nom du point de stock | writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Adresse du fournisseur | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Adresse du fournisseur 2 | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Ville du fournisseur | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Code pays du fournisseur | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
E-mail du fournisseur | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Nom du fournisseur | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Numéro de fournisseur | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Code postal du fournisseur | filters on the platform, writable, ::ancestor. |
||
total |
decimal |
Quantité totale reçue | filters on the platform, writable, ::ancestor. |
||
translated |
varchar2 |
État de la réponse traduite | filters on the platform, writable, ::ancestor. |
||
voided |
char |
Voided | filters on the platform, writable, ::ancestor. |
||
your |
varchar2 |
Votre référence | filters on the platform, writable, ::ancestor. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :