---
title: "CustomerSalesPrices (Visma.net Financials)"
description: "Customer Sales Prices"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CustomerSalesPrice.CustomerSalesPrices
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CustomerSalesPrice.CustomerSalesPrices
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `breakQty` | `double` | Break Quantity | [ ] | filters on the platform, writable, `breakQty` | The Sales price table &gt; Break quantity &gt; 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 &gt; Currency* &gt; The currency in which this price is specified. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` | The Sales price table &gt; Description &gt; The description of the stock item. |
| `effectiveDate` | `datetime` | Effective Date | [ ] | filters on the platform, writable, `effectiveDate` | The Sales price table &gt; Effective date &gt; 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 &gt; Ecpiration date &gt; The date when the price expires. |
| `inventoryId` | `varchar2` | Inventory ID | [ ] | filters on the platform, writable, `inventoryId` | The Sales price table or the top part &gt; Warehouse &gt; 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 &gt; Price &gt; The price for the item. |
| `priceCode` | `varchar2` | Price Code | [ ] | filters on the platform, writable, `priceCode` | The Sales price table or the top part &gt; Price code &gt; 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 &gt; Price type &gt; 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 &gt; Promotion &gt; 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 &gt; Item ID* &gt; 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 &gt; UoM* &gt; The unit of measure (UoM) used for the item. |
| `vat` | `varchar2` | VAT | [ ] | filters on the platform, writable, `vat` | The Sales price table &gt; VAT &gt; 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:

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

