invantive documentation
Invantive Support ForumsLog In / Sign Up

ProductionOrderPackageItems: Fortnox Production Order Package Items

read only REST

  • Catalog: Fortnox
  • Schema: WarehouseProductionOrders
  • Label: Production Order Package Items

List production orders

Can only retrieve data.

API Source

  • Endpoint: /api/warehouse/productionorders-v1
  • Operation: get /api/warehouse/productionorders-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).
itemId `` Include only production orders with the given production item.
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
state `` Include only production orders with the given state. Allowed states: all, incomplete, delayed, completed, voided. (Default is incomplete) (Values: all, incomplete, delayed, completed, voided)
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 ProductionOrderPackageItems 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
batch varchar2 Batch filters on the platform, writable, ::ancestor.batch
costCenterCode varchar2 Cost Centre Code filters on the platform, writable, ::ancestor.costCenterCode
documentState varchar2 Document State filters on the platform, writable, ::ancestor.documentState
id int64 ID filters on the platform, writable, ::ancestor.id
inboundStockLocationId guid Inbound Stock Location ID filters on the platform, writable, ::ancestor.inboundStockLocationId
inboundStockPointId guid Inbound Stock Point ID filters on the platform, writable, ::ancestor.inboundStockPointId
itemDescription varchar2 Item Description writable, itemDescription
itemDescription_2 varchar2 Item Description 2 filters on the platform, writable, ::ancestor.itemDescription
itemId varchar2 Item ID writable, itemId
itemId_2 varchar2 Item ID 2 filters on the platform, writable, ::ancestor.itemId
itemUnit varchar2 Item Unit writable, itemUnit
itemUnit_2 varchar2 Item Unit 2 filters on the platform, writable, ::ancestor.itemUnit
note varchar2(1000) Note filters on the platform, writable, ::ancestor.note
outboundStockPointId guid Outbound Stock Point ID filters on the platform, writable, ::ancestor.outboundStockPointId
productionDate datetime Production Date filters on the platform, writable, ::ancestor.productionDate
productionState varchar2 Production State filters on the platform, writable, ::ancestor.productionState
projectId varchar2 Project ID filters on the platform, writable, ::ancestor.projectId
quantity decimal Quantity filters on the platform, writable, ::ancestor.quantity
quantityRequired decimal Quantity Required writable, quantityRequired
quantityReserved decimal Quantity Reserved writable, quantityReserved
startDate datetime Start Date filters on the platform, writable, ::ancestor.startDate
totalQuantityRequired decimal Total Quantity Required writable, totalQuantityRequired

Release Notes

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