invantive documentation
Invantive Support ForumsLog In / Sign Up

ContractUsageTransactions: Visma.net Financials Contract Usage Transactions

read only REST

  • Catalog: VismaNet
  • Schema: ContractUsage
  • Label: Contract Usage Transactions

Get a range of Contract Usage - ScreenId=CT303000

Can only retrieve data.

API Source

  • Endpoint: /v1/contractUsage
  • Operation: get /v1/contractUsage

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
greaterThanValue ``
lastModifiedDateTime ``
lastModifiedDateTimeCondition ``

Table Columns

The columns of the table ContractUsageTransactions 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 writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) 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.
billingDate datetime Billing Date writable, billingDate Transaction history tab > Invoicing date > The date when the invoice was issued.
branch_name varchar2 Branch Name writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, branch.number Click the magnifier. > The identifier.
contract varchar2 Contract filters on the platform, writable, ::ancestor.contract
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_description varchar2 itgen_vnet_item_description writable, item.description Name of item/description
item_number varchar2 itgen_vnet_item_number writable, item.number Number of item
lastModifiedDateTime datetime Last Modified writable, lastModifiedDateTime A system generated date/time that indicates the last change for the document.
lastModifiedDateTime_2 datetime Last Modified Date/Time 2 filters on the platform, writable, ::ancestor.lastModifiedDateTime
quantity double Quantity writable, quantity Both tabs > Quantity > A number of units used for the item.
referenceNbr varchar2 Reference Number writable, referenceNbr Transaction history tab > Ref. no. > The reference number of the document/invoice.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.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)
transactionNumber int32 itgen_vnet_transactionnumber writable, transactionNumber
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.

Keys

Key Column Refers to Kind Description
ContractUsageTransactions_branch_number_fk branch_number Branches.number Key
ContractUsageTransactions_item_number_fk item_number InventoryItems.inventoryNumber Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: