KitAssemblyAllocationsByTypeRefNumber: Visma.net Financials Kit Assembly Allocations by Type Reference Number
read only REST
- Catalog:
VismaNet - Schema:
KitAssembly - Label: Kit Assembly Allocations by Type Reference Number
Get a Kit Assembly - ScreenId = IN307000
Can only retrieve data.
API Source
- Endpoint:
/v1/kitassembly/{type}/{refNo} - Operation:
get /v1/kitassembly/{type}/{refNo}
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 |
|---|---|---|---|---|
refNo |
`` | Kit Assembly Ref No | ||
type |
`` | Kit Assembly Type |
Table Columns
The columns of the table KitAssemblyAllocationsByTypeRefNumber 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. | |
created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
||
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
||
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
expiration |
datetime |
Expiration Date | writable, expiration |
||
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
||
itemID |
varchar2 |
Item ID | filters on the platform, writable, ::ancestor. |
||
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
||
line |
int32 |
itgen_vnet_linenbr | writable, line |
||
location |
varchar2 |
itgen_vnet_location | filters on the platform, writable, ::ancestor. |
||
location_ |
varchar2 |
Location Country ID | writable, location. |
Location*. | |
location_ |
varchar2 |
Location ID | writable, location. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | writable, location. |
Click the magnifier > The displayed name | |
lot |
varchar2 |
Lot Serial Number | writable, lot |
||
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
post |
varchar2 |
Post Period | filters on the platform, writable, ::ancestor. |
||
quantity |
double |
Quantity | writable, quantity |
||
quantity_ |
double |
itgen_vnet_quantity_2 | filters on the platform, writable, ::ancestor. |
||
reason |
varchar2 |
Reason Code | filters on the platform, writable, ::ancestor. |
||
refNo |
varchar2 |
itgen_vnet_refno | filters on the platform, writable, ::ancestor. |
||
revision |
varchar2 |
Revision | filters on the platform, writable, ::ancestor. |
||
sales |
varchar2 |
itgen_vnet_salesorderlink | filters on the platform, writable, ::ancestor. |
||
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
Status, possible values: H - On Hold, B - Balanced, R - Released | |
timestamp |
varchar2 |
Timestamp | filters on the platform, writable, ::ancestor. |
Timestamp of the kit assembly record | |
type |
varchar2 |
Type | filters on the platform, writable, ::ancestor. |
Type, possible values: P - Production, D - Disassembly | |
uoM_2 |
varchar2 |
itgen_vnet_uom_2 | filters on the platform, writable, ::ancestor. |
||
uom |
varchar2 |
Unit of Measure | writable, uom |
||
warehouse |
varchar2 |
Warehouse | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: