invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerSalesPrices: Visma.net Financials Customer Sales Prices

popular insert update REST

  • Catalog: VismaNet
  • Schema: CustomerSalesPrice
  • Primary Keys: recordId
  • Label: Customer Sales Prices

Get a range of Customer Sales Prices - ScreenId=AR202000 Request page size must be 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

Can retrieve data and change data using insert and update.

API Source

  • Endpoint: /v1/customerSalesPrice
  • Operation: get /v1/customerSalesPrice

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 30,000
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
effectiveAsOf ``
greaterThanValue ``
inventoryId ``
lastModifiedDateTime ``
lastModifiedDateTimeCondition ``
priceCode ``
priceType `` Values: All, Base, Customer, CustomerPriceClass.

Table Columns

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