Please enable JavaScript to view this site.

Made in EU
Visma.net Financials Forums

Visma.net Financials API Data Model

Navigation: Schema: Inventory > Tables

InventoryAttachmentsByInventoryNumber: Visma.net Financials Inventory Attachments by Inventory Number

Get a specific Inventory item

Catalog: VismaNet

Schema: Inventory

Label: Inventory Attachments by Inventory Number

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 InventoryAttachmentsByInventoryNumber. 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

COMPANY_CODE

string

☐

 

Partition to retrieve data from.

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.

inventoryNumber

string

☑

 

Identifies the Inventory item

 

Columns of Table Function

The columns of the table function InventoryAttachmentsByInventoryNumber 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