invantive documentation
Invantive Support ForumsLog In / Sign Up

StockTakings2ByParameters: Fortnox itgen_fnx_stocktakings2byparameters_plural

read only REST

  • Catalog: Fortnox
  • Schema: WarehouseStockTakings
  • Label: itgen_fnx_stocktakings2byparameters_plural

List stock takings

Sortable fields: id, name, date, responsible, state

Can only retrieve data.

Summary

Sortable fields: id, name, date, responsible, state

API Source

  • Endpoint: /api/warehouse/stocktaking-v1
  • Operation: get /api/warehouse/stocktaking-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 stock takings with the given item.
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
state `` Include only stock takings with the given state. (Values: all, planning, started, 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 StockTakings2ByParameters 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
costCenterCode varchar2 Cost Centre Code filters on the platform, writable, ::ancestor.costCenterCode
countedBy varchar2(100) Counted by writable, countedBy
currentRowNo int32 Current Row No writable, currentRowNo
date datetime Date filters on the platform, writable, ::ancestor.date
hasPostReleaseStockChanges char Has Post Release Stock Changes writable, hasPostReleaseStockChanges
id varchar2 ID writable, id
id_2 int64 ID filters on the platform, writable, ::ancestor.id
itemId varchar2(50) Item ID writable, itemId
name varchar2(50) Name filters on the platform, writable, ::ancestor.name
projectId varchar2 Project ID filters on the platform, writable, ::ancestor.projectId
responsible varchar2(50) Responsible filters on the platform, writable, ::ancestor.responsible
sortParams_primarySort varchar2 Sort Params Primary Sort filters on the platform, writable, ::ancestor.sortParams.primarySort
sortParams_primarySortOrder varchar2 Sort Params Primary Sort Order filters on the platform, writable, ::ancestor.sortParams.primarySortOrder
sortParams_secondarySort varchar2 Sort Params Secondary Sort filters on the platform, writable, ::ancestor.sortParams.secondarySort
sortParams_secondarySortOrder varchar2 Sort Params Secondary Sort Order filters on the platform, writable, ::ancestor.sortParams.secondarySortOrder
sortingId int32 Sorting ID filters on the platform, writable, ::ancestor.sortingId
state varchar2 State filters on the platform, writable, ::ancestor.state
stockLocationId guid Stock Location ID writable, stockLocationId
stockPointId guid Stock Point ID writable, stockPointId
stockTakenQuantity decimal Stock Taken Quantity writable, stockTakenQuantity
stockTakingId int64 Stock Taking ID writable, stockTakingId
stockTakingRowId varchar2 Stock Taking Rowid writable, stockTakingRowId
totalQuantityInStock decimal Total Quantity in Stock writable, totalQuantityInStock
usingStockPoints char Using Stockpoints filters on the platform, writable, ::ancestor.usingStockPoints

Release Notes

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