CustomerContractDetailLinesByContractId2: Visma.net Financials Customer Contract Detail Lines by Contract ID
read only REST
- Catalog:
VismaNet - Schema:
CustomerContract - Label: Customer Contract Detail Lines by Contract ID
Get a specific Customer Contract Details
Can only retrieve data.
API Source
- Endpoint:
/v1/customerContract/{contractId}/details - Operation:
get /v1/customerContract/{contractId}/details
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 |
|---|---|---|---|---|
contract |
`` | Identifies the customer contract |
Table Columns
The columns of the table CustomerContractDetailLinesByContractId2 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. | |
contract |
int32 |
itgen_vnet_contractdetailid | writable, contract |
||
current |
double |
itgen_vnet_currentrecurring | filters on the platform, writable, ::ancestor. |
||
current |
double |
itgen_vnet_currentrenewal | filters on the platform, writable, ::ancestor. |
||
current |
double |
itgen_vnet_currentsetup | filters on the platform, writable, ::ancestor. |
||
description |
varchar2 |
Description | writable, description |
||
difference |
double |
Difference | writable, difference |
||
effective |
datetime |
Effective from | filters on the platform, writable, ::ancestor. |
||
extra |
double |
itgen_vnet_extrausageprice | writable, extra |
||
included |
double |
Included | writable, included |
||
invoice |
varchar2 |
itgen_vnet_invoicetype | writable, invoice |
||
item |
varchar2 |
Item Code | writable, item |
||
pending |
double |
itgen_vnet_pendingrecurring | filters on the platform, writable, ::ancestor. |
||
pending |
double |
itgen_vnet_pendingrenewal | filters on the platform, writable, ::ancestor. |
||
pending |
double |
itgen_vnet_pendingsetup | filters on the platform, writable, ::ancestor. |
||
promo |
varchar2 |
itgen_vnet_promocode_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
promo |
varchar2 |
itgen_vnet_promocode_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
recurring |
double |
itgen_vnet_recurringdiscount | writable, recurring |
||
recurring |
double |
itgen_vnet_recurringprice | writable, recurring |
||
renewal |
double |
itgen_vnet_renewaldiscount | writable, renewal |
||
renewal |
double |
itgen_vnet_renewalprice | writable, renewal |
||
setup |
double |
itgen_vnet_setupdiscount | writable, setup |
||
setup |
double |
itgen_vnet_setupprice | writable, setup |
||
total |
double |
Total Pending | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: