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 |
|---|---|---|---|---|
order |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
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. |
The apartment reference | |
distributed |
double |
Distributed Amount | filters on the platform, writable, ::ancestor. |
The total amount distributed among the specified personal IDs | |
distributed |
char |
itgen_vnet_distributedautomatically | filters on the platform, writable, ::ancestor. |
Whether the ROT/RUT is distributed automatically | |
estate |
varchar2 |
Estate | filters on the platform, writable, ::ancestor. |
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 | |
material |
double |
itgen_vnet_materialcostamount | filters on the platform, writable, ::ancestor. |
Cost amount for lines with inventory ROT/RUT item type Material | |
organization |
varchar2 |
Organisation Number | filters on the platform, writable, ::ancestor. |
The organization number | |
other |
double |
itgen_vnet_othercostamount | filters on the platform, writable, ::ancestor. |
Cost amount for lines with inventory ROT/RUT item type OtherCost | |
personal |
varchar2 |
Personal ID | writable, personal |
The personal id | |
total |
double |
itgen_vnet_totaldeductableamount | filters on the platform, writable, ::ancestor. |
The total amount that is tax deductable | |
type |
varchar2 |
Type | filters on the platform, writable, ::ancestor. |
The type of ROT/RUT | |
work |
double |
itgen_vnet_workpriceamount | filters on the platform, writable, ::ancestor. |
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: