---
title: "ProductionOrderRowNotes (Fortnox)"
description: "Production Order Row Notes"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.WarehousePurchaseOrders.ProductionOrderRowNotes
original: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.WarehousePurchaseOrders.ProductionOrderRowNotes
updated: 2026-11-01T16:13:15Z
license: https://documentation.invantive.eu/en/
---

# ProductionOrderRowNotes: Fortnox Production Order Row Notes

`read only` `REST`

- Catalog: `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

Can only retrieve data.

## Summary

<p>
 List purchase orders matching the given parameters.
 </p>
 <p>
 Sortable fields:
 <code>id</code>,
 <code>supplier_number</code>,
 <code>order_date</code>,
 <code>internal_reference</code>,
 <code>response_state</code>,
 <code>delivery_date</code>
 </p>

## API Source

- Endpoint: `/api/warehouse/purchaseorders-v1`
- Operation: `get /api/warehouse/purchaseorders-v1`

## 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). |
| `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). |

## Table Columns

The columns of the table `ProductionOrderRowNotes` 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:

- [Fortnox](/en/release-notes/drivers?driver=fortnox)

