ContractUsageSpecificTransactionByContractId: Visma.net Financials Contract Usage Specific Transaction by Contract ID
read only REST
- Catalog:
VismaNet - Schema:
ContractUsage - Label: Contract Usage Specific Transaction by Contract ID
Get a specific Contract Usage Data for the Contract Usage The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for the Contract Usage
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/contractUsage/{contractId} - Operation:
get /v1/contractUsage/{contractId}
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 |
`` | Identify the Contract Usage |
Table Columns
The columns of the table ContractUsageSpecificTransactionByContractId 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. | |
billed |
char |
Billed | writable, billed |
Information indicating that the contract is collected from the Transaction history tab and the contract is invoiced. Not indicated on screen CT303000. | |
billing |
datetime |
Billing Date | writable, billing |
Transaction history tab > Invoicing date > The date when the invoice was issued. | |
branch_ |
varchar2 |
Branch Name | writable, branch. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | writable, branch. |
Click the magnifier. > The identifier. | |
contract |
varchar2 |
Contract | filters on the platform, writable, ::ancestor. |
||
date |
datetime |
Date | writable, date |
Mandatory field: Both tabs > Date* > The date of the activity, case, applied labour, or other usage (for the item). | |
description |
varchar2 |
Description | writable, description |
Both tabs > Description > A description of the non-stock item. | |
item_ |
varchar2 |
itgen_vnet_item_description | writable, item. |
Name of item/description | |
item_ |
varchar2 |
itgen_vnet_item_number | writable, item. |
Number of item | |
last |
datetime |
Last Modified | writable, last |
A system generated date/time that indicates the last change for the document. | |
last |
datetime |
Last Modified Date/Time 2 | filters on the platform, writable, ::ancestor. |
||
quantity |
double |
Quantity | writable, quantity |
Both tabs > Quantity > A number of units used for the item. | |
reference |
varchar2 |
Reference Number | writable, reference |
Transaction history tab > Ref. no. > The reference number of the document/invoice. | |
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) | |
transaction |
int32 |
itgen_vnet_transactionnumber | writable, transaction |
||
type |
varchar2 |
Type | writable, type |
Transaction history tab > Type > The type of the customer ledger document. | |
uom |
varchar2 |
Unit of Measure | writable, uom |
Both tabs > UoM > The unit of measure used for the item. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: