DiscountItemsV2: Visma.net Financials Discount Items (V2)
read only REST
- Catalog:
VismaNet - Schema:
DiscountV2 - Label: Discount Items (V2)
Get a range of discounts - ScreenId=AR209500
Can only retrieve data.
API Source
- Endpoint:
/v2/discount - Operation:
get /v2/discount
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 |
|---|---|---|---|---|
created |
`` | This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. |
||
created |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. | ||
discount |
`` | |||
last |
`` | |||
last |
`` | System retrieved information for state/condition. | ||
series |
`` |
Table Columns
The columns of the table DiscountItemsV2 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. | |
active |
char |
Active | filters on the platform, writable, ::ancestor. |
The top part > Active > A check box that indicates (if selected) that the series is active. | |
break |
varchar2 |
itgen_vnet_breakby | filters on the platform, writable, ::ancestor. |
The top part > Break by > The way the breakpoints for this discount series are specified. Quantity, Amount. | |
created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The top part > Description > A brief description of the series. | |
discount |
varchar2 |
itgen_vnet_discountby | filters on the platform, writable, ::ancestor. |
The top part > Discount by > The way the discount for the series is specified. Percent, Amount, Free item. | |
discount |
varchar2 |
Discount Code | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Discount code > The code of the discount for which you want to create a new series or view an existing one. | |
effective |
datetime |
Effective Date | filters on the platform, writable, ::ancestor. |
The top part > Effective date > The date when the series becomes effective; this field appears for promotional discount series only. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
expiration |
datetime |
Expiration Date | filters on the platform, writable, ::ancestor. |
The top part > Expiration date > The date when the promotional discount expires. This field appears for the series if the Promotional check box is selected. | |
free |
int32 |
Free Item | filters on the platform, writable, ::ancestor. |
Free item tab > Free item > The free item (by its item ID) that is added to orders as the discount for this series. | |
itemId |
varchar2 |
Item ID | writable, itemId |
||
last |
int32 |
itgen_vnet_lastfreeitem | filters on the platform, writable, ::ancestor. |
Free item tab > Last free item > The free item (by its item ID) that had been added to orders as the discount for this series before the date shown in the Last date column on the Discount breakpoints tab. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Free item tab > Last update date > A read-only field that shows the date when this discount series has been updated last. | |
last |
datetime |
itgen_vnet_lastupdatedate | filters on the platform, writable, ::ancestor. |
The top part > Last update date > A read-only field that shows the date when the discount series was last updated. | |
line |
int32 |
itgen_vnet_linecntr | filters on the platform, writable, ::ancestor. |
Free item tab > A line counter for the table. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
pending |
int32 |
itgen_vnet_pendingfreeitem | filters on the platform, writable, ::ancestor. |
Free item tab > Pending free item > The free item (by its item ID) that will be added to orders as the discount for this series, starting on the date specified in the Pending date column on the Discount breakpoints tab. | |
promotional |
char |
itgen_vnet_promotional | filters on the platform, writable, ::ancestor. |
The top part > Promotional > A check box that indicates (if selected) that the series is a promotional discount. | |
prorate |
char |
itgen_vnet_proratediscount | filters on the platform, writable, ::ancestor. |
The top part > Prorate discount > A check box that indicates (if selected) that the discount can be prorated. | |
series |
varchar2 |
itgen_vnet_series | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Series > The ID of the series defined for the discount. | |
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
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) |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: