invantive documentation
Invantive Support ForumsLog In / Sign Up

LandedCosts: Visma.net Financials itgen_vnet_landedcosts_plural

read only REST

  • Catalog: VismaNet
  • Schema: LandedCostCode
  • Label: itgen_vnet_landedcosts_plural

Get a range of Landed Costs - ScreenId=PO2020PL

Can only retrieve data.

API Source

  • Endpoint: /v1/landedCostCode
  • Operation: get /v1/landedCostCode

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
code `` Landed Cost Code
greaterThanValue `` Enter the from-value for Landed Cost Code
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.

Table Columns

The columns of the table LandedCosts 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.
allocationMethod varchar2 itgen_vnet_allocationmethod filters on the platform, writable, allocationMethod Allocation Method
applicationMethod varchar2 itgen_vnet_applicationmethod filters on the platform, writable, applicationMethod Application Method
description varchar2 Description filters on the platform, writable, description Description
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
landedCostAccrualAccount varchar2 itgen_vnet_landedcostaccrualaccount filters on the platform, writable, landedCostAccrualAccount Landed Cost Accrual Account
landedCostAccrualSubaccount varchar2 itgen_vnet_landedcostaccrualsubaccount filters on the platform, writable, landedCostAccrualSubaccount Landed Cost Accrual Sub.
landedCostCodeId varchar2 itgen_vnet_landedcostcodeid filters on the platform, writable, landedCostCodeId Landed Cost Code
landedCostType varchar2 itgen_vnet_landedcosttype filters on the platform, writable, landedCostType Type
landedCostVarianceAccount varchar2 itgen_vnet_landedcostvarianceaccount filters on the platform, writable, landedCostVarianceAccount Landed Cost Variance Account
landedCostVarianceSubaccount varchar2 itgen_vnet_landedcostvariancesubaccount filters on the platform, writable, landedCostVarianceSubaccount Landed Cost Variance Sub.
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
reasonCode varchar2 Reason Code filters on the platform, writable, reasonCode Reason Code
supplierId varchar2 itgen_vnet_supplierid filters on the platform, writable, supplierId Supplier ID
supplierLocationId varchar2 itgen_vnet_supplierlocationid filters on the platform, writable, supplierLocationId Supplier Location ID
terms varchar2 itgen_vnet_terms filters on the platform, writable, terms Terms
vatCategory varchar2 itgen_vnet_vatcategory filters on the platform, writable, vatCategory Tax Category

Release Notes

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