invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PurchaseOrderRowNotesById: Fortnox Purchase Order Row Notes by ID

read only REST

  • Catalogus: Fortnox
  • Schema: WarehousePurchaseOrders
  • Label: Purchase Order Row Notes by ID

Get Purchase Order

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /api/warehouse/purchaseorders-v1/{id}
  • Operatie: get /api/warehouse/purchaseorders-v1/{id}

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).
id `` Purchase order id.
ignoreIncomingGoodsId `` 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).

Tabelkolommen

De kolommen van de tabel PurchaseOrderRowNotesById 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
backOrderQuantity decimal Nabestelling Aantal writable, ::ancestor.backOrderQuantity
confirmationEmail varchar2(100) Bevestiging E-mail filters on the platform, writable, ::ancestor.::ancestor.confirmationEmail
costCenterCode varchar2(25) Kostenplaatscode writable, ::ancestor.costCenterCode
costCenterCode_2 varchar2(25) Kostenplaatscode 2 filters on the platform, writable, ::ancestor.::ancestor.costCenterCode
currencyCode varchar2(3) Valuta Code writable, ::ancestor.currencyCode
currencyCode_2 varchar2(3) Valuta-code 2 filters on the platform, writable, ::ancestor.::ancestor.currencyCode
currencyRate decimal Valuta Classificatie filters on the platform, writable, ::ancestor.::ancestor.currencyRate
currencyUnit int32 Valuta-eenheid filters on the platform, writable, ::ancestor.::ancestor.currencyUnit
customerId varchar2(25) Klant ID filters on the platform, writable, ::ancestor.::ancestor.customerId
customerName varchar2(1024) Naam Klant filters on the platform, writable, ::ancestor.::ancestor.customerName
customerNumber varchar2(1024) Klantnummer filters on the platform, writable, ::ancestor.::ancestor.customerNumber
deliveryAddress varchar2(1024) Afleveradres filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress
deliveryAddress2 varchar2(1024) Afleveradres 2 filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress2
deliveryCity varchar2(50) Afleverstad filters on the platform, writable, ::ancestor.::ancestor.deliveryCity
deliveryCountryCode varchar2(3) Landcode voor levering filters on the platform, writable, ::ancestor.::ancestor.deliveryCountryCode
deliveryDate datetime Leveringsdatum filters on the platform, writable, ::ancestor.::ancestor.deliveryDate
deliveryName varchar2(50) Naam van de afzender filters on the platform, writable, ::ancestor.::ancestor.deliveryName
deliveryZipCode varchar2(10) Postcode voor levering 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) Interne Referentie filters on the platform, writable, ::ancestor.::ancestor.internalReference
isStockItem char Is Voorraadartikel writable, ::ancestor.isStockItem
itemDescription varchar2 Artikelomschrijving writable, ::ancestor.itemDescription
itemId varchar2(50) Artikel ID writable, ::ancestor.itemId
itemUnit varchar2 Artikel Eenheid writable, ::ancestor.itemUnit
languageCode varchar2(3) Taalcode filters on the platform, writable, ::ancestor.::ancestor.languageCode
manuallyCompleted char Handmatig ingevuld filters on the platform, writable, ::ancestor.::ancestor.manuallyCompleted
messageToSupplier varchar2(1000) Bericht aan de leverancier filters on the platform, writable, ::ancestor.::ancestor.messageToSupplier
note varchar2 Note writable, note
note_2 varchar2(1000) Opmerking 2 filters on the platform, writable, ::ancestor.::ancestor.note
orderDate datetime Besteldatum filters on the platform, writable, ::ancestor.::ancestor.orderDate
orderValue decimal Bestelwaarde filters on the platform, writable, ::ancestor.::ancestor.orderValue
orderValueInSEK decimal Bestelwaarde in SEK filters on the platform, writable, ::ancestor.::ancestor.orderValueInSEK
orderedQuantity decimal Bestelde hoeveelheid writable, ::ancestor.orderedQuantity
ourReference varchar2(50) Ourreference filters on the platform, writable, ::ancestor.::ancestor.ourReference
outboundDocumentReference_id varchar2 Verwijzing voor uitgaand document filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.id
outboundDocumentReference_type varchar2 Referentietype uitgaand document filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.type
paymentTermsCode varchar2(20) Code betalingsvoorwaarden filters on the platform, writable, ::ancestor.::ancestor.paymentTermsCode
price decimal Price writable, ::ancestor.price
projectId varchar2(25) Project ID writable, ::ancestor.projectId
projectId_2 varchar2(25) Project-ID 2 filters on the platform, writable, ::ancestor.::ancestor.projectId
purchaseOrderId int64 Inkoopopdracht ID writable, purchaseOrderId
purchaseOrderId_2 int64 Inkooporder-ID 2 writable, ::ancestor.purchaseOrderId
purchaseOrderRowId guid Rowid van inkooporder writable, purchaseOrderRowId
purchaseOrderState varchar2 Status van de inkooporder filters on the platform, writable, ::ancestor.::ancestor.purchaseOrderState
purchaseType varchar2 Aankoopsoort filters on the platform, writable, ::ancestor.::ancestor.purchaseType
receivedQuantity decimal Ontvangen Hoeveelheid writable, ::ancestor.receivedQuantity
remainingOrderedQuantity decimal Resterende bestelde hoeveelheid writable, ::ancestor.remainingOrderedQuantity
responseState varchar2 Status van de reactie filters on the platform, writable, ::ancestor.::ancestor.responseState
rowNum int64 Rijnummer writable, rowNum
rowNum_2 int64 Rij nummer 2 writable, ::ancestor.rowNum
stockLocationCode varchar2 Voorraadlocatiecode writable, ::ancestor.stockLocationCode
stockLocationId guid Voorraadlocatie ID writable, ::ancestor.stockLocationId
stockLocationName varchar2 Naam van Voorraadlocatie writable, ::ancestor.stockLocationName
stockPointCode varchar2 Voorraadpuntcode writable, ::ancestor.stockPointCode
stockPointCode_2 varchar2 Voorraadpuntcode 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointCode
stockPointId guid Voorraadpunt-ID writable, ::ancestor.stockPointId
stockPointId_2 guid Voorraadpunt-ID 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointId
stockPointName varchar2 Naam van het voorraadpunt writable, ::ancestor.stockPointName
supplier varchar2 Supplier filters on the platform, writable, ::ancestor.::ancestor.supplier
supplierAddress varchar2(1024) Leverancier Adres filters on the platform, writable, ::ancestor.::ancestor.supplierAddress
supplierAddress2 varchar2(1024) Adres leverancier 2 filters on the platform, writable, ::ancestor.::ancestor.supplierAddress2
supplierCity varchar2(1024) Leverancier Plaats filters on the platform, writable, ::ancestor.::ancestor.supplierCity
supplierCountryCode varchar2(3) Landcode leverancier filters on the platform, writable, ::ancestor.::ancestor.supplierCountryCode
supplierEmail varchar2(100) Leverancier E-mail filters on the platform, writable, ::ancestor.::ancestor.supplierEmail
supplierName varchar2(1024) Leveranciersnaam filters on the platform, writable, ::ancestor.::ancestor.supplierName
supplierNumber varchar2(1024) Leveranciersnummer filters on the platform, writable, ::ancestor.::ancestor.supplierNumber
supplierPostCode varchar2(1024) Postcode leverancier filters on the platform, writable, ::ancestor.::ancestor.supplierPostCode
totalReceivedQuantity decimal Totaal ontvangen hoeveelheid filters on the platform, writable, ::ancestor.::ancestor.totalReceivedQuantity
translatedResponseState varchar2 Vertaalde responsstatus filters on the platform, writable, ::ancestor.::ancestor.translatedResponseState
voided char Voided filters on the platform, writable, ::ancestor.::ancestor.voided
yourReference varchar2(50) Uw Referentie filters on the platform, writable, ::ancestor.::ancestor.yourReference

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: