invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerSalesPriceCustomerSalesPriceByrecordId: Visma.net Financials itgen_vnet_customersalespricecustomersalespricebyrecordid_plural

read only REST

  • Catalog: VismaNet
  • Schema: CustomerSalesPrice
  • Label: itgen_vnet_customersalespricecustomersalespricebyrecordid_plural

Get a specific Customer Sales Price by recordId The response headers include an ETag after a successful GET operation.

Can only retrieve data.

Summary

The response headers include an ETag after a successful GET operation.

API Source

  • Endpoint: /v1/customerSalesPrice/{recordId}
  • Operation: get /v1/customerSalesPrice/{recordId}

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
recordId `` The recordId of the Customer Sales Price

Table Columns

The columns of the table CustomerSalesPriceCustomerSalesPriceByrecordId 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.
breakQty double Break Quantity filters on the platform, writable, breakQty The Sales price table > Break quantity > The quantity to define a lower bound for a quantity tier with the specific price.
currency varchar2 Currency filters on the platform, writable, currency Mandatory field: The Sales price table > Currency* > The currency in which this price is specified.
description varchar2 Description filters on the platform, writable, description The Sales price table > Description > The description of the stock item.
effectiveDate datetime Effective Date filters on the platform, writable, effectiveDate The Sales price table > Effective date > The date when the price became effective.
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
expirationDate datetime Expiration Date filters on the platform, writable, expirationDate The Sales price table > Ecpiration date > The date when the price expires.
inventoryId varchar2 Inventory ID filters on the platform, writable, inventoryId The Sales price table or the top part > Warehouse > The warehouse in which the price applies.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime
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
price double Price filters on the platform, writable, price The Sales Price table > Price > The price for the item.
priceCode varchar2 Price Code filters on the platform, writable, priceCode The Sales price table or the top part > Price code > The customer or a customer price class for which you want to create or edit a price list.
priceType varchar2 Price Type filters on the platform, writable, priceType The Sales price table or the top part > Price type > The type of prices you want to view: All prices, Base, Customer, Customer price class.
promotion char Promotion filters on the platform, writable, promotion The Sales price table > Promotion > A check box that indicates (if selected) that the price for this item is promotional.
recordId int32 Record ID filters on the platform, writable, recordId Mandatory field: The Sales price table > Item ID* > The ID of the stock or non-stock stock item for which price information is listed.
timeStamp blob Timestamp filters on the platform, writable, timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
uoM varchar2 Unit of Measure filters on the platform, writable, uoM Mandatory field: The Sales price table > UoM* > The unit of measure (UoM) used for the item.
vat varchar2 VAT filters on the platform, writable, vat The Sales price table > VAT > The VAT amount that is included in the sales price.
warehouse varchar2 Warehouse filters on the platform, writable, warehouse

Release Notes

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