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 > Standard cost section > Pending cost > The pending standard cost for the stock item. |
pendingCostDate |
datetime |
Pending Cost Date |
☐ |
Price/cost information tab > Standard cost section > Pending cost date > The date when the pending standard cost becomes effective. |
postingClass_description |
string |
|
☐ |
Click on the magnifier. > The description. |
postingClass_id |
string |
|
☐ |
Click on the magnifier. > The identifier. |
priceClass_description |
string |
Price Class Description |
☐ |
Click on the magnifier. > The description. |
priceClass_id |
string |
Price Class ID |
☐ |
Click on the magnifier. > The identifier. |
priceClassID |
string |
|
☐ |
The Price/cost information tab > Price management section > Price class > The price class of the item. |
priceManager_id |
string |
|
☐ |
|
priceManager_name |
string |
|
☐ |
|
priceManagerID |
guid |
|
☐ |
The Price/cost information tab > Price management section > Price manager > The ID of the manager responsible for the product pricing. |
priceWorkgroupID |
int32 |
|
☐ |
The Price/cost information tab > Price management section > Price work group > The work group responsible for product pricing. Select the pricing work group for the stock item. |
purchaseUnit |
string |
|
☐ |
Mandatory field: General information tab > Unit of measurement section > Purchase unit *> The UoM to be used as the purchase unit for the stock item. |
recommendedPrice |
double |
|
☐ |
The Price/cost information tab > Price management section > List price > 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 > Unit of measurement section > Sales unit *> The UoM to be used as the sales unit for the stock item. |
status |
string |
Status |
☐ |
The top part > Item status > 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 > Item defaults section > Type > The type of stock item. |
vatCode_description |
string |
VAT Code Description |
☐ |
Click on the magnifier. > The description. |
vatCode_id |
string |
VAT Code ID |
☐ |
Click on the magnifier. > The identifier. |
22-12-2022 21:03 Version 22.1.101-BETA+3681