invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseOrderRowNotesById: Fortnox Purchase Order Row Notes by ID

read only REST

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

Get Purchase Order

Can only retrieve data.

API Source

  • Endpoint: /api/warehouse/purchaseorders-v1/{id}
  • Operation: get /api/warehouse/purchaseorders-v1/{id}

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type 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).

Table Columns

The columns of the table PurchaseOrderRowNotesById are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
backOrderQuantity decimal Backorder Quantity writable, ::ancestor.backOrderQuantity
confirmationEmail varchar2(100) Confirmation Email filters on the platform, writable, ::ancestor.::ancestor.confirmationEmail
costCenterCode varchar2(25) Cost Centre Code writable, ::ancestor.costCenterCode
costCenterCode_2 varchar2(25) Cost Centre Code 2 filters on the platform, writable, ::ancestor.::ancestor.costCenterCode
currencyCode varchar2(3) Currency Code writable, ::ancestor.currencyCode
currencyCode_2 varchar2(3) Currency Code 2 filters on the platform, writable, ::ancestor.::ancestor.currencyCode
currencyRate decimal Currency Rate filters on the platform, writable, ::ancestor.::ancestor.currencyRate
currencyUnit int32 Currency Unit filters on the platform, writable, ::ancestor.::ancestor.currencyUnit
customerId varchar2(25) Customer ID filters on the platform, writable, ::ancestor.::ancestor.customerId
customerName varchar2(1024) Customer Name filters on the platform, writable, ::ancestor.::ancestor.customerName
customerNumber varchar2(1024) Customer Number filters on the platform, writable, ::ancestor.::ancestor.customerNumber
deliveryAddress varchar2(1024) Delivery Address filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress
deliveryAddress2 varchar2(1024) Delivery Address 2 filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress2
deliveryCity varchar2(50) Delivery City filters on the platform, writable, ::ancestor.::ancestor.deliveryCity
deliveryCountryCode varchar2(3) Delivery Country Code filters on the platform, writable, ::ancestor.::ancestor.deliveryCountryCode
deliveryDate datetime Delivery Date filters on the platform, writable, ::ancestor.::ancestor.deliveryDate
deliveryName varchar2(50) Delivery Name filters on the platform, writable, ::ancestor.::ancestor.deliveryName
deliveryZipCode varchar2(10) Delivery Zip Code 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) Internal Reference filters on the platform, writable, ::ancestor.::ancestor.internalReference
isStockItem char Is Stock Item writable, ::ancestor.isStockItem
itemDescription varchar2 Item Description writable, ::ancestor.itemDescription
itemId varchar2(50) Item ID writable, ::ancestor.itemId
itemUnit varchar2 Item Unit writable, ::ancestor.itemUnit
languageCode varchar2(3) Language Code filters on the platform, writable, ::ancestor.::ancestor.languageCode
manuallyCompleted char Manually Completed filters on the platform, writable, ::ancestor.::ancestor.manuallyCompleted
messageToSupplier varchar2(1000) Message to Supplier 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 Order Date filters on the platform, writable, ::ancestor.::ancestor.orderDate
orderValue decimal Order Value filters on the platform, writable, ::ancestor.::ancestor.orderValue
orderValueInSEK decimal Order Value in SEK filters on the platform, writable, ::ancestor.::ancestor.orderValueInSEK
orderedQuantity decimal Ordered Quantity writable, ::ancestor.orderedQuantity
ourReference varchar2(50) Ourreference filters on the platform, writable, ::ancestor.::ancestor.ourReference
outboundDocumentReference_id varchar2 Outbound Document Reference ID filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.id
outboundDocumentReference_type varchar2 Outbound Document Reference Type filters on the platform, writable, ::ancestor.::ancestor.outboundDocumentReference.type
paymentTermsCode varchar2(20) Payment Terms Code 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) Projectid 2 filters on the platform, writable, ::ancestor.::ancestor.projectId
purchaseOrderId int64 Purchase Order ID writable, purchaseOrderId
purchaseOrderId_2 int64 Purchase Order ID 2 writable, ::ancestor.purchaseOrderId
purchaseOrderRowId guid Purchase Order Rowid writable, purchaseOrderRowId
purchaseOrderState varchar2 Purchase Order State filters on the platform, writable, ::ancestor.::ancestor.purchaseOrderState
purchaseType varchar2 Purchase Type filters on the platform, writable, ::ancestor.::ancestor.purchaseType
receivedQuantity decimal Received Quantity writable, ::ancestor.receivedQuantity
remainingOrderedQuantity decimal Remaining Ordered Quantity writable, ::ancestor.remainingOrderedQuantity
responseState varchar2 Response State filters on the platform, writable, ::ancestor.::ancestor.responseState
rowNum int64 Row Number writable, rowNum
rowNum_2 int64 Row Number 2 writable, ::ancestor.rowNum
stockLocationCode varchar2 Stock Location Code writable, ::ancestor.stockLocationCode
stockLocationId guid Stock Location ID writable, ::ancestor.stockLocationId
stockLocationName varchar2 Stock Location Name writable, ::ancestor.stockLocationName
stockPointCode varchar2 Stock Point Code writable, ::ancestor.stockPointCode
stockPointCode_2 varchar2 Stock Point Code 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointCode
stockPointId guid Stock Point ID writable, ::ancestor.stockPointId
stockPointId_2 guid Stock Point ID 2 filters on the platform, writable, ::ancestor.::ancestor.stockPointId
stockPointName varchar2 Stock Point Name writable, ::ancestor.stockPointName
supplier varchar2 Supplier filters on the platform, writable, ::ancestor.::ancestor.supplier
supplierAddress varchar2(1024) Supplier Address filters on the platform, writable, ::ancestor.::ancestor.supplierAddress
supplierAddress2 varchar2(1024) Supplier Address 2 filters on the platform, writable, ::ancestor.::ancestor.supplierAddress2
supplierCity varchar2(1024) Supplier City filters on the platform, writable, ::ancestor.::ancestor.supplierCity
supplierCountryCode varchar2(3) Supplier Country Code filters on the platform, writable, ::ancestor.::ancestor.supplierCountryCode
supplierEmail varchar2(100) Supplier Email filters on the platform, writable, ::ancestor.::ancestor.supplierEmail
supplierName varchar2(1024) Supplier Name filters on the platform, writable, ::ancestor.::ancestor.supplierName
supplierNumber varchar2(1024) Supplier Number filters on the platform, writable, ::ancestor.::ancestor.supplierNumber
supplierPostCode varchar2(1024) Supplier Postcode filters on the platform, writable, ::ancestor.::ancestor.supplierPostCode
totalReceivedQuantity decimal Total Received Quantity filters on the platform, writable, ::ancestor.::ancestor.totalReceivedQuantity
translatedResponseState varchar2 Translated Response State filters on the platform, writable, ::ancestor.::ancestor.translatedResponseState
voided char Voided filters on the platform, writable, ::ancestor.::ancestor.voided
yourReference varchar2(50) Your Reference filters on the platform, writable, ::ancestor.::ancestor.yourReference

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: