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 |
|---|---|---|---|---|
record |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
break |
double |
Break Quantity | filters on the platform, writable, break |
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. | |
effective |
datetime |
Effective Date | filters on the platform, writable, effective |
The Sales price table > Effective date > The date when the price became effective. | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
expiration |
datetime |
Expiration Date | filters on the platform, writable, expiration |
The Sales price table > Ecpiration date > The date when the price expires. | |
inventory |
varchar2 |
Inventory ID | filters on the platform, writable, inventory |
The Sales price table or the top part > Warehouse > The warehouse in which the price applies. | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
||
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
price |
double |
Price | filters on the platform, writable, price |
The Sales Price table > Price > The price for the item. | |
price |
varchar2 |
Price Code | filters on the platform, writable, price |
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. | |
price |
varchar2 |
Price Type | filters on the platform, writable, price |
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. | |
record |
int32 |
Record ID | filters on the platform, writable, record |
Mandatory field: The Sales price table > Item ID* > The ID of the stock or non-stock stock item for which price information is listed. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
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: