invantive documentation
Invantive Support ForumsLog In / Sign Up

WarehouseLocationPrimaryItemClassAttributes: Visma.net Financials Warehouse Location Primary Item Class Attributes

read only REST

  • Catalog: VismaNet
  • Schema: Warehouse
  • Label: Warehouse Location Primary Item Class Attributes

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) 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
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 WarehouseLocationPrimaryItemClassAttributes 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 writable, ::ancestor.::ancestor.active Active > This check box indicates whether this location is active.
active_2 char itgen_vnet_active_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.address.addressId Information retrieved from the system.
address_addressLine1 varchar2 Address Line 1 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.addressLine1 Address ! > The first line in the address of the warehouse.
address_addressLine2 varchar2 Address Line 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.addressLine2 Address 2 > The second line in the warehouse address.
address_addressType varchar2 Address Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.addressType Information retrieved from the system.
address_city varchar2 City filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.city City > The city of the warehouse address.
address_country_errorInfo varchar2 itgen_vnet_address_country_errorinfo filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.country.errorInfo
address_country_id varchar2 Country ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.address.country.metadata.maxPageSize
address_country_metadata_totalCount int64 itgen_vnet_address_country_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.country.metadata.totalCount
address_country_name varchar2 Country Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.country.name Mandatory field: Country name* > The complete name of the country.
address_county_id varchar2 County ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.county.id Click the magnifier > The identifier
address_county_name varchar2 County Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.county.name Click the magnifier > The displayed name
address_postalCode varchar2 Postal Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.postalCode Postcode > The postcode relevant for the warehouse address.
address_validated char Address Validated filters on the platform, writable, ::ancestor.::ancestor.::ancestor.address.validated Information retrieved from the system.
assemblyValid char itgen_vnet_assemblyvalid writable, ::ancestor.::ancestor.assemblyValid Assembly allowed > You select this check box if assembly operations are allowed at this location.
attributeId varchar2 Attribute ID writable, attributeId The Attributes tab > Attribute ID > The identifier of the attribute.
attributeType varchar2 Attribute Type writable, attributeType
avgDefaultCost varchar2 itgen_vnet_avgdefaultcost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.number Click the magnifier. > The identifier.
contact_attention varchar2 itgen_vnet_contact_attention filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.contact.contactId Information retrieved from the system.
contact_email varchar2 Contact Email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.email Email > The email address of the contact person assigned to this warehouse.
contact_fax varchar2 Contact Fax filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.contact.web Web > The URL of the web page where information about the warehouse is published.
defaultValue varchar2 Default Value writable, defaultValue The Attributes tab > Default value > The default value of the attribute.
description varchar2 Description writable, description The Attributes tab > Description > A read-only column that displays the detailed description of the attribute.
description_2 varchar2 Description 2 writable, ::ancestor.description The description.
description_3 varchar2 itgen_vnet_description_3 writable, ::ancestor.::ancestor.description Description > A brief description of the warehouse location.
description_4 varchar2 itgen_vnet_description_4 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.description The top part > Description > A brief description of the warehouse.
dropShipLocation_description varchar2 itgen_vnet_dropshiplocation_description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.dropShipLocation.description Click on the magnifier. > The description.
dropShipLocation_id varchar2 itgen_vnet_dropshiplocation_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.dropShipLocation.id Click on the magnifier. > The identifier.
errorInfo varchar2 Error Message writable, ::ancestor.errorInfo
fifoDefaultCost varchar2 itgen_vnet_fifodefaultcost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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.
id varchar2 ID writable, ::ancestor.id The identifier.
inclQtyAvail char itgen_vnet_inclqtyavail writable, ::ancestor.::ancestor.inclQtyAvail Include in qty. available > You select this check box if the quantities of goods available at this location will be included in the quantities of available goods and used in inventory transactions, such as issues and transfers.
isCosted char itgen_vnet_iscosted writable, ::ancestor.::ancestor.isCosted Cost separately > You select this check box if the costs for goods available at this location will be calculated separately from costs calculated at the system-level; that is, for FIFO and specific valuation methods, separate cost layers will be created for this location.
locationEntry varchar2 Location Entry filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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.
locationId varchar2 Location ID writable, ::ancestor.::ancestor.locationId Location ID > The unique ID of the warehouse location.
lockSitePICountEntry char itgen_vnet_locksitepicountentry filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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 writable, ::ancestor.metadata.maxPageSize
metadata_maxPageSize_2 int64 itgen_vnet_metadata_maxpagesize_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count writable, ::ancestor.metadata.totalCount
metadata_totalCount_2 int64 itgen_vnet_metadata_totalcount_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.metadata.totalCount
primaryItemValid varchar2 itgen_vnet_primaryitemvalid writable, ::ancestor.::ancestor.primaryItemValid Primary item validation > An option indicating whether the operations with the primary item should be validated for this location and how.
primaryItem_description varchar2 itgen_vnet_primaryitem_description writable, ::ancestor.::ancestor.primaryItem.description Name of item/description
primaryItem_number varchar2 itgen_vnet_primaryitem_number writable, ::ancestor.::ancestor.primaryItem.number Number of item
projectTask_description varchar2 Project Task Description writable, ::ancestor.::ancestor.projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID writable, ::ancestor.::ancestor.projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid writable, ::ancestor.::ancestor.projectTask.internalId The internal identifier.
project_description varchar2 Project Description writable, ::ancestor.::ancestor.project.description Click on the magnifier. > The description.
project_id varchar2 Project ID writable, ::ancestor.::ancestor.project.id Click on the magnifier. > The identifier.
project_internalId int32 itgen_vnet_project_internalid writable, ::ancestor.::ancestor.project.internalId The internal identifier.
receiptLocation_description varchar2 itgen_vnet_receiptlocation_description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.receiptLocation.description Click on the magnifier. > The description.
receiptLocation_id varchar2 itgen_vnet_receiptlocation_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.receiptLocation.id Click on the magnifier. > The identifier.
receiptsValid char itgen_vnet_receiptsvalid writable, ::ancestor.::ancestor.receiptsValid Receipts allowed > You select this check box if receipts are allowed at this location.
replenishmentClass_description varchar2 itgen_vnet_replenishmentclass_description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.replenishmentClass.description Click on the magnifier. > The description.
replenishmentClass_id varchar2 itgen_vnet_replenishmentclass_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.replenishmentClass.id Click on the magnifier. > The identifier.
required char Required writable, required The Attributes tab > Required > This check box indicates (if selected) that the attribute value is required for items of the class.
returnLocation_description varchar2 Return Location Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.returnLocation.description Click on the magnifier. > The description.
returnLocation_id varchar2 Return Location ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.returnLocation.id Click on the magnifier. > The identifier.
salesValid char itgen_vnet_salesvalid writable, ::ancestor.::ancestor.salesValid Sales allowed > You select this check box if sales are allowed from this location.
shipLocation_description varchar2 Ship Location Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.shipLocation.description Click on the magnifier. > The description.
shipLocation_id varchar2 Ship Location ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.shipLocation.id Click on the magnifier. > The identifier.
sortOrder int32 itgen_vnet_sortorder writable, sortOrder The Attributes tab > Sort order > A number that represents the order of the attribute in the list of class attributes.The lower the number, the higher the attribute will be in the list of class attributes.
timestamp varchar2 Timestamp filters on the platform, writable, ::ancestor.::ancestor.::ancestor.timestamp Timestamp of the warehouse record
transfersValid char itgen_vnet_transfersvalid writable, ::ancestor.::ancestor.transfersValid Transfers allowed > You select this check box if transfers are allowed for this location.
type varchar2 Type writable, ::ancestor.type
warehouseID varchar2 Warehouse ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.warehouseID Mandatory field: The top part > Warehouse ID* > The unique ID of the warehouse.

Keys

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

Release Notes

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