invantive documentation
Invantive Support ForumsLog In / Sign Up

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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) 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_addressId int32 Address ID filters on the platform, writable, address.addressId Information retrieved from the system.
address_addressLine1 varchar2 Address Line 1 filters on the platform, writable, address.addressLine1 Address ! > The first line in the address of the warehouse.
address_addressLine2 varchar2 Address Line 2 filters on the platform, writable, address.addressLine2 Address 2 > The second line in the warehouse address.
address_addressType varchar2 Address Type filters on the platform, writable, address.addressType Information retrieved from the system.
address_city varchar2 City filters on the platform, writable, address.city City > The city of the warehouse address.
address_country_errorInfo varchar2 itgen_vnet_address_country_errorinfo filters on the platform, writable, address.country.errorInfo
address_country_id varchar2 Country ID filters on the platform, writable, address.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
address_country_metadata_maxPageSize int64 itgen_vnet_address_country_metadata_maxpagesize filters on the platform, writable, address.country.metadata.maxPageSize
address_country_metadata_totalCount int64 itgen_vnet_address_country_metadata_totalcount filters on the platform, writable, address.country.metadata.totalCount
address_country_name varchar2 Country Name filters on the platform, writable, address.country.name Mandatory field: Country name* > The complete name of the country.
address_county_id varchar2 County ID filters on the platform, writable, address.county.id Click the magnifier > The identifier
address_county_name varchar2 County Name filters on the platform, writable, address.county.name Click the magnifier > The displayed name
address_postalCode varchar2 Postal Code filters on the platform, writable, address.postalCode Postcode > The postcode relevant for the warehouse address.
address_validated char Address Validated filters on the platform, writable, address.validated Information retrieved from the system.
avgDefaultCost varchar2 itgen_vnet_avgdefaultcost filters on the platform, writable, avgDefaultCost 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_name varchar2 Branch Name filters on the platform, writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, branch.number Click the magnifier. > The identifier.
contact_attention varchar2 itgen_vnet_contact_attention filters on the platform, writable, contact.attention Attention > The department or person to be noted on the attention line, if this line is used by your company.
contact_companyName varchar2 itgen_vnet_contact_companyname filters on the platform, writable, contact.companyName Company name > The legal business name of the warehouse to appear on the documents.
contact_contactId int32 Contact ID filters on the platform, writable, contact.contactId Information retrieved from the system.
contact_email varchar2 Contact Email filters on the platform, writable, contact.email Email > The email address of the contact person assigned to this warehouse.
contact_fax varchar2 Contact Fax filters on the platform, writable, contact.fax Fax > The fax number of the contact person assigned to this warehouse.
contact_phone1 varchar2 Contact Phone 1 filters on the platform, writable, contact.phone1 Phone 1 > The primary phone number of the contact person assigned to this warehouse.
contact_phone2 varchar2 Contact Phone 2 filters on the platform, writable, contact.phone2 Phone 2 > A secondary phone number of the contact person assigned to this warehouse.
contact_web varchar2 Contact Website filters on the platform, writable, contact.web 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.
dropShipLocation_description varchar2 itgen_vnet_dropshiplocation_description filters on the platform, writable, dropShipLocation.description Click on the magnifier. > The description.
dropShipLocation_id varchar2 itgen_vnet_dropshiplocation_id filters on the platform, writable, dropShipLocation.id Click on the magnifier. > The identifier.
fifoDefaultCost varchar2 itgen_vnet_fifodefaultcost filters on the platform, writable, fifoDefaultCost 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.
locationEntry varchar2 Location Entry filters on the platform, writable, locationEntry 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.
lockSitePICountEntry char itgen_vnet_locksitepicountentry filters on the platform, writable, lockSitePICountEntry 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_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
receiptLocation_description varchar2 itgen_vnet_receiptlocation_description filters on the platform, writable, receiptLocation.description Click on the magnifier. > The description.
receiptLocation_id varchar2 itgen_vnet_receiptlocation_id filters on the platform, writable, receiptLocation.id Click on the magnifier. > The identifier.
replenishmentClass_description varchar2 itgen_vnet_replenishmentclass_description filters on the platform, writable, replenishmentClass.description Click on the magnifier. > The description.
replenishmentClass_id varchar2 itgen_vnet_replenishmentclass_id filters on the platform, writable, replenishmentClass.id Click on the magnifier. > The identifier.
returnLocation_description varchar2 Return Location Description filters on the platform, writable, returnLocation.description Click on the magnifier. > The description.
returnLocation_id varchar2 Return Location ID filters on the platform, writable, returnLocation.id Click on the magnifier. > The identifier.
shipLocation_description varchar2 Ship Location Description filters on the platform, writable, shipLocation.description Click on the magnifier. > The description.
shipLocation_id varchar2 Ship Location ID filters on the platform, writable, shipLocation.id Click on the magnifier. > The identifier.
timestamp varchar2 Timestamp filters on the platform, writable, timestamp Timestamp of the warehouse record
warehouseID varchar2 Warehouse ID filters on the platform, writable, warehouseID Mandatory field: The top part > Warehouse ID* > The unique ID of the warehouse.

Keys

Key Column Refers to Kind Description
Warehouses_branch_number_fk branch_number Branches.number Key

Referenced By

Release Notes

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