invantive documentation
Invantive Support ForumsLog In / Sign Up

LandedCostsByCode: Visma.net Financials itgen_vnet_landedcostsbycode_plural

read only REST

  • Catalog: VismaNet
  • Schema: LandedCostCode
  • Label: itgen_vnet_landedcostsbycode_plural

Get a specific Landed Costs - ScreenId=PO2020PL

Can only retrieve data.

API Source

  • Endpoint: /v1/landedCostCode/{code}
  • Operation: get /v1/landedCostCode/{code}

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 Id

Table Columns

The columns of the table LandedCostsByCode 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: