invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesOrderRotRutDistributionsByTypeOrderId: Visma.net Financials itgen_vnet_salesorderrotrutdistributionsbytypeorderid_plural

read only REST

  • Catalog: NgSalesOrders
  • Schema: SalesOrders
  • Label: itgen_vnet_salesorderrotrutdistributionsbytypeorderid_plural

Gets ROT/RUT information for a single sales order Sample request:

GET /salesorders/SO/000123/rotrut

Can only retrieve data.

Summary

Sample request:

GET /salesorders/SO/000123/rotrut

API Source

  • Endpoint: /api/v3/SalesOrders/{type}/{orderId}/rotrut
  • Operation: get /api/v3/SalesOrders/{type}/{orderId}/rotrut

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
orderId `` The id of the sales order to get
type `` The type of sales order to get

Table Columns

The columns of the table SalesOrderRotRutDistributionsByTypeOrderId 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
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
amount double Amount writable, amount The amount
apartment varchar2 itgen_vnet_apartment filters on the platform, writable, ::ancestor.apartment The apartment reference
distributedAmount double Distributed Amount filters on the platform, writable, ::ancestor.distributedAmount The total amount distributed among the specified personal IDs
distributedAutomatically char itgen_vnet_distributedautomatically filters on the platform, writable, ::ancestor.distributedAutomatically Whether the ROT/RUT is distributed automatically
estate varchar2 Estate filters on the platform, writable, ::ancestor.estate The estate reference
extra char Extra writable, extra Whether this is extra or not
lineId int32 Line Identifier writable, lineId Reference to the order line
materialCostAmount double itgen_vnet_materialcostamount filters on the platform, writable, ::ancestor.materialCostAmount Cost amount for lines with inventory ROT/RUT item type Material
organizationNumber varchar2 Organisation Number filters on the platform, writable, ::ancestor.organizationNumber The organization number
otherCostAmount double itgen_vnet_othercostamount filters on the platform, writable, ::ancestor.otherCostAmount Cost amount for lines with inventory ROT/RUT item type OtherCost
personalId varchar2 Personal ID writable, personalId The personal id
totalDeductableAmount double itgen_vnet_totaldeductableamount filters on the platform, writable, ::ancestor.totalDeductableAmount The total amount that is tax deductable
type varchar2 Type filters on the platform, writable, ::ancestor.type The type of ROT/RUT
workPriceAmount double itgen_vnet_workpriceamount filters on the platform, writable, ::ancestor.workPriceAmount Price amount for lines with inventory ROT/RUT item type Service

Release Notes

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