Warehouses: Visma.net Financials Warehouses
read only REST
- Catalog:
VismaNet - Schema:
Warehouse - Label: Warehouses
Get a range of Warehouses - ScreenId=IN204000
Can only retrieve data.
API Source
- Endpoint:
/v1/warehouse - Operation:
get /v1/warehouse
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 258 |
| Full scan rows per minute | 2,760 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
active |
`` | Selects only the warehouses that are active/inactive. | ||
branch |
`` | Selects only the warehouses for the specified branch. |
Table Columns
The columns of the table Warehouses 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. | |
active |
char |
Active | filters on the platform, writable, active |
The top part > Active > This check box indicates (if selected) that the warehouse is active. | |
address_ |
int32 |
Address ID | filters on the platform, writable, address. |
Information retrieved from the system. | |
address_ |
varchar2 |
Address Line 1 | filters on the platform, writable, address. |
Address ! > The first line in the address of the warehouse. | |
address_ |
varchar2 |
Address Line 2 | filters on the platform, writable, address. |
Address 2 > The second line in the warehouse address. | |
address_ |
varchar2 |
Address Type | filters on the platform, writable, address. |
Information retrieved from the system. | |
address_ |
varchar2 |
City | filters on the platform, writable, address. |
City > The city of the warehouse address. | |
address_ |
varchar2 |
itgen_vnet_address_country_errorinfo | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Country ID | filters on the platform, writable, address. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
address_ |
int64 |
itgen_vnet_address_country_metadata_maxpagesize | filters on the platform, writable, address. |
||
address_ |
int64 |
itgen_vnet_address_country_metadata_totalcount | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Country Name | filters on the platform, writable, address. |
Mandatory field: Country name* > The complete name of the country. | |
address_ |
varchar2 |
County ID | filters on the platform, writable, address. |
Click the magnifier > The identifier | |
address_ |
varchar2 |
County Name | filters on the platform, writable, address. |
Click the magnifier > The displayed name | |
address_ |
varchar2 |
Postal Code | filters on the platform, writable, address. |
Postcode > The postcode relevant for the warehouse address. | |
address_ |
char |
Address Validated | filters on the platform, writable, address. |
Information retrieved from the system. | |
avg |
varchar2 |
itgen_vnet_avgdefaultcost | filters on the platform, writable, avg |
The top part > Avg. default return cost > For items with the Average valuation method, the option that defines which of costs should be used for returns and receipts. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, branch. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | filters on the platform, writable, branch. |
Click the magnifier. > The identifier. | |
contact_ |
varchar2 |
itgen_vnet_contact_attention | filters on the platform, writable, contact. |
Attention > The department or person to be noted on the attention line, if this line is used by your company. | |
contact_ |
varchar2 |
itgen_vnet_contact_companyname | filters on the platform, writable, contact. |
Company name > The legal business name of the warehouse to appear on the documents. | |
contact_ |
int32 |
Contact ID | filters on the platform, writable, contact. |
Information retrieved from the system. | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, contact. |
Email > The email address of the contact person assigned to this warehouse. | |
contact_ |
varchar2 |
Contact Fax | filters on the platform, writable, contact. |
Fax > The fax number of the contact person assigned to this warehouse. | |
contact_ |
varchar2 |
Contact Phone 1 | filters on the platform, writable, contact. |
Phone 1 > The primary phone number of the contact person assigned to this warehouse. | |
contact_ |
varchar2 |
Contact Phone 2 | filters on the platform, writable, contact. |
Phone 2 > A secondary phone number of the contact person assigned to this warehouse. | |
contact_ |
varchar2 |
Contact Website | filters on the platform, writable, contact. |
Web > The URL of the web page where information about the warehouse is published. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The top part > Description > A brief description of the warehouse. | |
drop |
varchar2 |
itgen_vnet_dropshiplocation_description | filters on the platform, writable, drop |
Click on the magnifier. > The description. | |
drop |
varchar2 |
itgen_vnet_dropshiplocation_id | filters on the platform, writable, drop |
Click on the magnifier. > The identifier. | |
fifo |
varchar2 |
itgen_vnet_fifodefaultcost | filters on the platform, writable, fifo |
The top part > FIFO default returns cost > For items with the FIFO valuation method, the option that defines which of costs should be used for returns and receipts. | |
location |
varchar2 |
Location Entry | filters on the platform, writable, location |
The top part > Location entry > An option indicating whether warehouse locations can be added directly on any inventory document or only by using this window. | |
lock |
char |
itgen_vnet_locksitepicountentry | filters on the platform, writable, lock |
The top part > Freeze the inventory when the stocktaking is in data entry state > This check box indicates (if selected) that the inventory in the warehouse will be frozen during the stocktaking and data entry stages of stocktaking. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
receipt |
varchar2 |
itgen_vnet_receiptlocation_description | filters on the platform, writable, receipt |
Click on the magnifier. > The description. | |
receipt |
varchar2 |
itgen_vnet_receiptlocation_id | filters on the platform, writable, receipt |
Click on the magnifier. > The identifier. | |
replenishment |
varchar2 |
itgen_vnet_replenishmentclass_description | filters on the platform, writable, replenishment |
Click on the magnifier. > The description. | |
replenishment |
varchar2 |
itgen_vnet_replenishmentclass_id | filters on the platform, writable, replenishment |
Click on the magnifier. > The identifier. | |
return |
varchar2 |
Return Location Description | filters on the platform, writable, return |
Click on the magnifier. > The description. | |
return |
varchar2 |
Return Location ID | filters on the platform, writable, return |
Click on the magnifier. > The identifier. | |
ship |
varchar2 |
Ship Location Description | filters on the platform, writable, ship |
Click on the magnifier. > The description. | |
ship |
varchar2 |
Ship Location ID | filters on the platform, writable, ship |
Click on the magnifier. > The identifier. | |
timestamp |
varchar2 |
Timestamp | filters on the platform, writable, timestamp |
Timestamp of the warehouse record | |
warehouse |
varchar2 |
Warehouse ID | filters on the platform, writable, warehouse |
Mandatory field: The top part > Warehouse ID* > The unique ID of the warehouse. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Warehouses_ |
branch_ |
Branches. |
Key |
Referenced By
- InventoryAdjustmentLines
warehouse_id(Key) - InventoryIssueLineAllocations
warehouse_id(Key) - InventoryIssueLines
warehouse_id(Key) - InventoryReceiptLineAllocations
warehouse_id(Key) - InventoryReceiptLines
warehouse_id(Key) - InventoryTransferLineAllocations
toWarehouse_id(Key) - InventoryTransferLineAllocations
warehouse_id(Key) - InventoryTransferLines
toWarehouse_id(Key) - InventoryTransferLines
warehouse_id(Key) - InventoryTransfers
toWarehouse_id(Key) - InventoryTransfers
warehouse_id(Key) - PurchaseOrderDiscountDetails
warehouse_id(Key) - PurchaseOrderLineSubsegments
warehouse_id(Key) - PurchaseOrderLines
warehouse_id(Key) - PurchaseOrderReceipts
warehouse_id(Key) - PurchaseOrderTaxDetails
warehouse_id(Key) - PurchaseOrders
warehouse_id(Key) - BasicPurchaseOrderLines
warehouse_id(Key) - PurchaseOrderLinesSubsegments
warehouse_id(Key) - SalesOrders
preferredWarehouse_id(Key) - BasicSalesOrderLines
warehouse_id(Key) - ShipmentDetailLineAllocations
fromWarehouse_id(Key) - ShipmentDetailLineAllocations
toWarehouse_id(Key) - ShipmentDetailLineAllocations
warehouse_id(Key) - ShipmentDetailLines
fromWarehouse_id(Key) - ShipmentDetailLines
toWarehouse_id(Key) - ShipmentDetailLines
warehouse_id(Key) - ShipmentOrderLines
fromWarehouse_id(Key) - ShipmentOrderLines
toWarehouse_id(Key) - ShipmentPackageLines
fromWarehouse_id(Key) - ShipmentPackageLines
toWarehouse_id(Key) - Shipments
fromWarehouse_id(Key) - Shipments
toWarehouse_id(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: