invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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).
internalReference `` 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).
purchaseType `` Include only documents with the given purchaseType (Values: WAREHOUSE, DROPSHIP)
q `` Include only documents where id or internalReference-field contains the given text (case-insensitive).
state `` Include only documents with the given purchaseOrderState.(Values: NOT_SENT, SENT, SENT_NOT_REJECTED, DELAYED, RECEIVED, VOIDED, CURRENT, ALL)
supplierNumber `` Include only documents with the given supplierNumber.
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
backOrderQuantity decimal Quantité en attente de livraison writable, ::ancestor.backOrderQuantity
confirmationEmail varchar2(100) E-mail de confirmation filters on the platform, writable, ::ancestor.::ancestor.confirmationEmail
costCenterCode varchar2(25) Coût Code Center writable, ::ancestor.costCenterCode
costCenterCode_2 varchar2(25) Code du centre de coûts 2 filters on the platform, writable, ::ancestor.::ancestor.costCenterCode
currencyCode varchar2(3) Code de devise writable, ::ancestor.currencyCode
currencyCode_2 varchar2(3) Code de devise 2 filters on the platform, writable, ::ancestor.::ancestor.currencyCode
currencyRate decimal Taux de change de la devise filters on the platform, writable, ::ancestor.::ancestor.currencyRate
currencyUnit int32 Devise filters on the platform, writable, ::ancestor.::ancestor.currencyUnit
customerId varchar2(25) ID de cliente filters on the platform, writable, ::ancestor.::ancestor.customerId
customerName varchar2(1024) Nom du client filters on the platform, writable, ::ancestor.::ancestor.customerName
customerNumber varchar2(1024) Numéro de client filters on the platform, writable, ::ancestor.::ancestor.customerNumber
deliveryAddress varchar2(1024) Adresse de livraison filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress
deliveryAddress2 varchar2(1024) Adresse de livraison 2 filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress2
deliveryCity varchar2(50) Ville de livraison filters on the platform, writable, ::ancestor.::ancestor.deliveryCity
deliveryCountryCode varchar2(3) Code pays de livraison filters on the platform, writable, ::ancestor.::ancestor.deliveryCountryCode
deliveryDate datetime Date de livraison filters on the platform, writable, ::ancestor.::ancestor.deliveryDate
deliveryName varchar2(50) Nom du destinataire filters on the platform, writable, ::ancestor.::ancestor.deliveryName
deliveryZipCode varchar2(10) Code postal de livraison filters on the platform, writable, ::ancestor.::ancestor.deliveryZipCode
dropship char Dropship filters on the platform, writable, ::ancestor.::ancestor.dropship
id guid ID writable, ::ancestor.id
id_2 int64 ID filters on the platform, writable, ::ancestor.::ancestor.id
internalReference varchar2(50) Référence interne filters on the platform, writable, ::ancestor.::ancestor.internalReference
isStockItem char Article en stock ? writable, ::ancestor.isStockItem
itemDescription varchar2 Description de l’article writable, ::ancestor.itemDescription
itemId varchar2(50) ID de l'article writable, ::ancestor.itemId
itemUnit varchar2 Article Unité writable, ::ancestor.itemUnit
languageCode varchar2(3) Code de langue filters on the platform, writable, ::ancestor.::ancestor.languageCode
manuallyCompleted char Rempli manuellement filters on the platform, writable, ::ancestor.::ancestor.manuallyCompleted
messageToSupplier varchar2(1000) Message à l'attention du fournisseur filters on the platform, writable, ::ancestor.::ancestor.messageToSupplier
note varchar2 Note writable, note
note_2 varchar2(1000) Note 2 filters on the platform, writable, ::ancestor.::ancestor.note
orderDate datetime Date de la commande filters on the platform, writable, ::ancestor.::ancestor.orderDate
orderValue decimal Montant de la commande filters on the platform, writable, ::ancestor.::ancestor.orderValue
orderValueInSEK decimal Montant de la commande en SEK filters on the platform, writable, ::ancestor.::ancestor.orderValueInSEK
orderedQuantity decimal Quantité commandée writable, ::ancestor.orderedQuantity
ourReference varchar2(50) Ourreference filters on the platform, writable, ::ancestor.::ancestor.ourReference
outboundDocumentReference_id varchar2 Référence du document sortant filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.id
outboundDocumentReference_type varchar2 Type de référence des documents sortants filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.type
paymentTermsCode varchar2(20) Code des conditions de paiement filters on the platform, writable, ::ancestor.::ancestor.paymentTermsCode
price decimal Price writable, ::ancestor.price
projectId varchar2(25) Identifiant du projet writable, ::ancestor.projectId
projectId_2 varchar2(25) Identifiant du projet 2 filters on the platform, writable, ::ancestor.::ancestor.projectId
purchaseOrderId int64 ID de bon de commande writable, purchaseOrderId
purchaseOrderId_2 int64 Référence de bon de commande n° 2 writable, ::ancestor.purchaseOrderId
purchaseOrderRowId guid ID de ligne de bon de commande writable, purchaseOrderRowId
purchaseOrderState varchar2 Statut de la commande d'achat filters on the platform, writable, ::ancestor.::ancestor.purchaseOrderState
purchaseType varchar2 Type d'achat filters on the platform, writable, ::ancestor.::ancestor.purchaseType
receivedQuantity decimal Quantité réceptionnée writable, ::ancestor.receivedQuantity
remainingOrderedQuantity decimal Quantité restante commandée writable, ::ancestor.remainingOrderedQuantity
responseState varchar2 État de la réponse filters on the platform, writable, ::ancestor.::ancestor.responseState
rowNum int64 Numéro de ligne writable, rowNum
rowNum_2 int64 Ligne n° 2 writable, ::ancestor.rowNum
stockLocationCode varchar2 Code d'emplacement des stocks writable, ::ancestor.stockLocationCode
stockLocationId guid Référence de l'emplacement de stock writable, ::ancestor.stockLocationId
stockLocationName varchar2 Nom du lieu de stockage writable, ::ancestor.stockLocationName
stockPointCode varchar2 Code de référence writable, ::ancestor.stockPointCode
stockPointCode_2 varchar2 Code de référence 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointCode
stockPointId guid Référence de stock writable, ::ancestor.stockPointId
stockPointId_2 guid Référence de stock n° 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointId
stockPointName varchar2 Nom du point de stock writable, ::ancestor.stockPointName
supplier varchar2 Supplier filters on the platform, writable, ::ancestor.::ancestor.supplier
supplierAddress varchar2(1024) Adresse du fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierAddress
supplierAddress2 varchar2(1024) Adresse du fournisseur 2 filters on the platform, writable, ::ancestor.::ancestor.supplierAddress2
supplierCity varchar2(1024) Ville du fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierCity
supplierCountryCode varchar2(3) Code pays du fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierCountryCode
supplierEmail varchar2(100) E-mail du fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierEmail
supplierName varchar2(1024) Nom du fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierName
supplierNumber varchar2(1024) Numéro de fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierNumber
supplierPostCode varchar2(1024) Code postal du fournisseur filters on the platform, writable, ::ancestor.::ancestor.supplierPostCode
totalReceivedQuantity decimal Quantité totale reçue filters on the platform, writable, ::ancestor.::ancestor.totalReceivedQuantity
translatedResponseState varchar2 État de la réponse traduite filters on the platform, writable, ::ancestor.::ancestor.translatedResponseState
voided char Voided filters on the platform, writable, ::ancestor.::ancestor.voided
yourReference varchar2(50) Votre référence filters on the platform, writable, ::ancestor.::ancestor.yourReference

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 :