Please enable JavaScript to view this site.

Navigation: Schema: Inventory > Tables

InventoryAttachments: Visma.net Financials Inventory Attachments

Get a range of Inventory items - ScreenId=IN202000 and IN202500Data for Inventory

Catalog: VismaNet

Schema: Inventory

Label: Inventory Attachments

The data in this table is partitioned per value of the COMPANY_CODE column.

This is a read-only table function. The Visma.net Financials API may not support changing the data or the Invantive SQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API.

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function InventoryAttachments. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

addCostPriceStatistics

boolean

 

This filter can be used only for stock items, from the Price/cost information tab.

alternateID

string

 

Applies for both Stock and Non-stock items. Some fields in this filter applies only for one of these.

attachmentLastModifiedDateTime

string

 

System retrieved information for last modified date and time for attachment.

attachmentLastModifiedDateTimeCondition

string

 

System retrieved information for state/condition for attachment.

attributes

string

 

Attributes (additional information) connected to the entity.Examples:{{base}}/inventory?attributes={"AttributeID":"ValueID","AttributeID":"ValueID"}{{base}}/inventory?attributes={"AttributeID":"ValueID1,ValueID2"}

availabilityLastModifiedDateTime

string

 

System retrieved information.

availabilityLastModifiedDateTimeCondition

string

 

System retrieved information for state/condition.

COMPANY_CODE

string

 

Partition to retrieve data from.

createdDateTime

string

 

Creation date and time.

createdDateTimeCondition

string

 

System-retrieved information for state/condition

description

string

 

A brief description of the stock item from the Top part of the window.

erp-api-background

string

 

If a URL value is provided, then API endpoint will be queued and executed in background. When the execution of the background operation is finished, the system will POST the response to the specified URL. The endpoint itself responds in this case with a 202-Accepted status and a reference to a state document for the background operation.

expandAccountInformation

boolean

 

Set to true to retrieve information about the account information connected to the item.

expandAttachment

boolean

 

Set to true to retrieve information about the attachments connected to the item.

expandAttribute

boolean

 

Set to true to retrieve the attribute descriptions used for the item.

expandCrossReference

boolean

 

These expand fields are by default set to true, but will be changed in the future. Set to true to retrieve information about the cross-references (item ID and suppliers/customers ID for the item connected to the item.

expandInventoryUnits

boolean

 

Set to true to retrieve information about the units of measure connected to the item.

expandNote

boolean

 

Set to true to retrieve the note value connected to the item.

expandSalesCategories

boolean

 

Set to true to retrieve details about the sales categories connected to the item.

expandSupplierDetails

boolean

 

Set to true to retrieve details about the supplier connected to the item.

expandWarehouseDetail

boolean

 

Set to true to retrieve information about the warehouse connected to the item.

greaterThanValue

string

 

Greater than value. The item which is the object for this, varies from API to API.

inventoryNumber

string

 

The Item ID.

lastModifiedDateTime

string

 

System generated value for last modification of transaction/record. Use format: YYYY-MM-DD HH:MM (date and time) to filter from date to present.

lastModifiedDateTimeCondition

string

 

System retrieved information for state/condition.

numberToRead

int32

 

This field has been deprecated and will be removed in future versions. Use pagenumber and pagesize for pagination purposes. Pagenumber and pagesize does not work with NumberToRead and SkipRecords.

pageNumber

int32

 

Pagination parameter. Page number.

pageSize

int32

 

Pagination parameter. Number of items to be collected.Please use a page size lower or equal to the allowed max page size which is returned as part of the metadata information.If requested page size is greater than allowed max page size, request will be limited to max page size.MaxPageSize will be set to 5000 from 1. April 2022

salesCategory

int32

 

The Category ID for the sales category, found on the Attributes tab.

skipRecords

int32

 

This field has been deprecated and will be removed in future versions. Use pagenumber and pagesize for pagination purposes. Pagenumber and pagesize does not work with NumberToRead and SkipRecords.

 

Columns of Table Function

The columns of the table function InventoryAttachments are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

accountInformation_cogsAccount_description

string

 

Name of item/description

accountInformation_cogsAccount_number

string

 

Number of item

accountInformation_cogsAccount_type

string

 

 

accountInformation_cogsSubaccount_description

string

 

Click on the magnifier. > The description.

accountInformation_cogsSubaccount_id

string

 

Click on the magnifier. > The identifier.

accountInformation_expenseAccount_description

string

 

Name of item/description

accountInformation_expenseAccount_number

string

 

Number of item

accountInformation_expenseAccount_type

string

 

 

accountInformation_expenseAccrualAccount_description

string

 

Name of item/description

accountInformation_expenseAccrualAccount_number

string

 

Number of item

accountInformation_expenseAccrualAccount_type

string

 

 

accountInformation_expenseEuAccount_description

string

 

Name of item/description

accountInformation_expenseEuAccount_number

string

 

Number of item

accountInformation_expenseEuAccount_type

string

 

 

accountInformation_expenseImportAccount_description

string

 

Name of item/description

accountInformation_expenseImportAccount_number

string

 

Number of item

accountInformation_expenseImportAccount_type

string

 

 

accountInformation_expenseNonTaxableAccount_description

string

 

Name of item/description

accountInformation_expenseNonTaxableAccount_number

string

 

Number of item

accountInformation_expenseNonTaxableAccount_type

string

 

 

accountInformation_expenseSubaccount_description

string

 

Click on the magnifier. > The description.

accountInformation_expenseSubaccount_id

string

 

Click on the magnifier. > The identifier.

accountInformation_inventoryAccount_description

string

 

Name of item/description

accountInformation_inventoryAccount_number

string

 

Number of item

accountInformation_inventoryAccount_type

string

 

 

accountInformation_salesAccount_description

string

 

Name of item/description

accountInformation_salesAccount_number

string

 

Number of item

accountInformation_salesAccount_type

string

 

 

accountInformation_salesEuAccount_description

string

 

Name of item/description

accountInformation_salesEuAccount_number

string

 

Number of item

accountInformation_salesEuAccount_type

string

 

 

accountInformation_salesExportAccount_description

string

 

Name of item/description

accountInformation_salesExportAccount_number

string

 

Number of item

accountInformation_salesExportAccount_type

string

 

 

accountInformation_salesNonTaxableAccount_description

string

 

Name of item/description

accountInformation_salesNonTaxableAccount_number

string

 

Number of item

accountInformation_salesNonTaxableAccount_type

string

 

 

accountInformation_salesSubaccount_description

string

 

Click on the magnifier. > The description.

accountInformation_salesSubaccount_id

string

 

Click on the magnifier. > The identifier.

baseUnit

string

Base Unit

Mandatory field: General information tab > Unit of measurement section > Base unit* > The UoM used as the base unit for this stock item.

body

string

 

The top part > Body *> A brief description of the stock item.

COMPANY_CODE

string(30)

Company Code

Partition code, segmenting the data.

COMPANY_NAME

string(240)

Company Name

Name of the partition.

costPriceStatistics_averageCost

double

 

Cost price statistics section > Average cost > The average cost for the stock item.

costPriceStatistics_lastCost

double

 

Cost price statistics section > Last cost > The last standard cost used for the stock item.

costPriceStatistics_maxCost

double

 

Cost price statistics section > Max. cost > The maximum cost for the stock item.

costPriceStatistics_minCost

double

 

Cost price statistics section > Min. cost > The minimum cost for the stock item.

currentCost

double

 

Price/cost information tab > Standard cost section > Current cost > Read-only. This field displays the current standard cost for the stock item.

defaultIssueFrom_description

string

 

Click on the magnifier. > The description.

defaultIssueFrom_id

string

 

Click on the magnifier. > The identifier.

defaultPrice

double

Default Price

Price/cost information tab > Price management section > Default price > The price of the stock item.

defaultReceiptTo_description

string

 

Click on the magnifier. > The description.

defaultReceiptTo_id

string

 

Click on the magnifier. > The identifier.

defaultWarehouse_description

string

 

Click on the magnifier. > The description.

defaultWarehouse_id

string

 

Click on the magnifier. > The identifier.

description

string

Description

The top part > Description *> A brief description of the stock item.

effectiveDate

datetime

Effective Date

Price/cost information tab > Standard cost section > Effective date > Read-only. This field shows the effective date for the current standard cost of the stock item.

errorInfo

string

Error Message

 

id

guid

ID

The ID of the attachment

intrastat_cN8

string

 

Represents the 8 digit level Combine Nomenclature commodity code specific for the yearfor which the creating / actualizations Intrastat declarations is drafted.

intrastat_countryOfOrigin

string

 

The country of origin of the commodity will be selected,that country where the good has been produced or had the last substantial transformation.

intrastat_supplementaryMeasureUnit

string

 

The requirement for Supplementary Measure Units applies only to certain classes of goods(NC8 Positions)that may be expressed from quantitative point of view in other measurement units but kilo also.

inventoryId

int32

Inventory ID

The unique internal identifier of the item as is stored in the database. This Id is not visible in the window.

inventoryNumber

string

Inventory Number

Mandatory field: The top part > Item Id* > The unique alphanumeric identifier of the stock item.

itemClass_description

string

Item Class Description

Click on the magnifier. > The description.

itemClass_id

string

Item Class ID

Click on the magnifier. > The identifier.

itemClass_type

string

Item Class Type

 

kitItem

boolean

 

 

lastCost

double

Last Cost

Price/cost information tab > Standard cost section > Last cost > Read-only. This field showing the last standard cost defined for the stock item.

lastModifiedDateTime

datetime

Last Modified

Information collected from system.

lotSerialClass_description

string

 

Click on the magnifier. > The description.

lotSerialClass_id

string

 

Click on the magnifier. > The identifier.

metadata_maxPageSize

int64

 

 

metadata_totalCount

int64

Total Count

 

name

string

Name

The name of the attachment.

note

string

Note

Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the inventory item.

packaging_baseItemVolume

double

 

The volume of the <see cref="!:BaseUnit">Base Unit</see> of the item.

packaging_baseItemWeight

double

 

The weight of the <see cref="!:BaseUnit">Base Unit</see> of the item.

packaging_volumeUOM

string

 

The <see cref="!:INUnit">Unit of Measure</see> used for the <see cref="P:Visma.net.ERP.Web.Api.Model.V1.IN.PackagingDto.BaseItemVolume">Volume</see> of the item.

packaging_weightUOM

string

 

The <see cref="!:INUnit">Unit of Measure</see> used for the <see cref="P:Visma.net.ERP.Web.Api.Model.V1.IN.PackagingDto.BaseItemWeight">Weight</see> of the item.

pendingCost

double

Pending Cost

Price/cost information tab &gt; Standard cost section &gt; Pending cost &gt; The pending standard cost for the stock item.

pendingCostDate

datetime

Pending Cost Date

Price/cost information tab &gt; Standard cost section &gt; Pending cost date &gt; The date when the pending standard cost becomes effective.

postingClass_description

string

 

Click on the magnifier. &gt; The description.

postingClass_id

string

 

Click on the magnifier. &gt; The identifier.

priceClass_description

string

Price Class Description

Click on the magnifier. &gt; The description.

priceClass_id

string

Price Class ID

Click on the magnifier. &gt; The identifier.

priceClassID

string

 

The Price/cost information tab &gt; Price management section &gt; Price class &gt; The price class of the item.

priceManager_id

string

 

 

priceManager_name

string

 

 

priceManagerID

guid

 

The Price/cost information tab &gt; Price management section &gt; Price manager &gt; The ID of the manager responsible for the product pricing.

priceWorkgroupID

int32

 

The Price/cost information tab &gt; Price management section &gt; Price work group &gt; The work group responsible for product pricing. Select the pricing work group for the stock item.

purchaseUnit

string

 

Mandatory field: General information tab &gt; Unit of measurement section &gt; Purchase unit *&gt; The UoM to be used as the purchase unit for the stock item.

recommendedPrice

double

 

The Price/cost information tab &gt; Price management section &gt; List price &gt; The manufacturer's suggested retail price (MSRP) of the stock item.

revision

int32

Revision

The version of the attachment.

salesUnit

string

Sales Unit

Mandatory field: General information tab &gt; Unit of measurement section &gt; Sales unit *&gt; The UoM to be used as the sales unit for the stock item.

status

string

Status

The top part &gt; Item status &gt; The status of the stock item. The alternatives are: Active, No sales, No purchases, No request, Inactive, Marked for deletion.

stockItem

boolean

Stock Item

 

type

string

Type

General information tab &gt; Item defaults section &gt; Type &gt; The type of stock item.

vatCode_description

string

VAT Code Description

Click on the magnifier. &gt; The description.

vatCode_id

string

VAT Code ID

Click on the magnifier. &gt; The identifier.

 

22-12-2022 21:03 Version 22.1.101-BETA+3681

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer