KitSpecificationStockComponentLinesByKitInventoryIdRevisionId: Visma.net Financials Kit Specification Stock Component Lines by Kit Inventory ID Revision ID
read only REST
- Catalog:
VismaNet - Schema:
KitSpecifications - Label: Kit Specification Stock Component Lines by Kit Inventory ID Revision ID
Get a specific KitSpecification Data for the INKitSpecHdr
Can only retrieve data.
Summary
Data for the INKitSpecHdr
API Source
- Endpoint:
/v1/KitSpecifications/{kitInventoryID}/{revisionID} - Operation:
get /v1/KitSpecifications/{kitInventoryID}/{revisionID}
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 |
|---|---|---|---|---|
kit |
`` | kitInventoryID | ||
revision |
`` | revisionID |
Table Columns
The columns of the table KitSpecificationStockComponentLinesByKitInventoryIdRevisionId 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. | |
allow |
char |
itgen_vnet_allowcomponentaddition | filters on the platform, writable, ::ancestor. |
||
allow |
char |
itgen_vnet_allowcomponentqtyvariance | writable, allow |
||
allow |
char |
itgen_vnet_allowcomponentsubstitution | writable, allow |
||
component |
varchar2 |
itgen_vnet_componentid | writable, component |
||
component |
double |
itgen_vnet_componentqty | writable, component |
||
created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | writable, description |
||
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
||
disassembly |
double |
itgen_vnet_disassemblycoeff | writable, disassembly |
||
error |
varchar2 |
Error Message | writable, error |
||
error |
varchar2 |
Error Information 2 | filters on the platform, writable, ::ancestor. |
||
is |
char |
Is Active | filters on the platform, writable, ::ancestor. |
||
is |
char |
itgen_vnet_isnonstock | filters on the platform, writable, ::ancestor. |
||
kit |
varchar2 |
itgen_vnet_kitinventoryid | filters on the platform, writable, ::ancestor. |
||
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
||
line |
int32 |
itgen_vnet_linenbr | writable, line |
||
max |
double |
itgen_vnet_maxcomponentqty | writable, max |
||
metadata_ |
int64 |
Metadata Max Pagesize | writable, metadata. |
||
metadata_ |
int64 |
itgen_vnet_metadata_maxpagesize_2 | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | writable, metadata. |
||
metadata_ |
int64 |
itgen_vnet_metadata_totalcount_2 | filters on the platform, writable, ::ancestor. |
||
min |
double |
itgen_vnet_mincomponentqty | writable, min |
||
revision |
varchar2 |
Revision | filters on the platform, writable, ::ancestor. |
||
timestamp |
varchar2 |
Timestamp | filters on the platform, writable, ::ancestor. |
Timestamp of the kit specification record | |
uom |
varchar2 |
Unit of Measure | writable, uom |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: