invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerContractDetailLinesByContractId: 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
contractId `` Identifies the customer contract

Table Columns

The columns of the table CustomerContractDetailLinesByContractId 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.
contractDetailId int32 itgen_vnet_contractdetailid writable, contractDetailId
currentRecurring double itgen_vnet_currentrecurring filters on the platform, writable, ::ancestor.currentRecurring
currentRenewal double itgen_vnet_currentrenewal filters on the platform, writable, ::ancestor.currentRenewal
currentSetup double itgen_vnet_currentsetup filters on the platform, writable, ::ancestor.currentSetup
description varchar2 Description writable, description
difference double Difference writable, difference
effectiveFrom datetime Effective from filters on the platform, writable, ::ancestor.effectiveFrom
extraUsagePrice double itgen_vnet_extrausageprice writable, extraUsagePrice
included double Included writable, included
invoiceType varchar2 itgen_vnet_invoicetype writable, invoiceType
itemCode varchar2 Item Code writable, itemCode
pendingRecurring double itgen_vnet_pendingrecurring filters on the platform, writable, ::ancestor.pendingRecurring
pendingRenewal double itgen_vnet_pendingrenewal filters on the platform, writable, ::ancestor.pendingRenewal
pendingSetup double itgen_vnet_pendingsetup filters on the platform, writable, ::ancestor.pendingSetup
promoCode_description varchar2 itgen_vnet_promocode_description filters on the platform, writable, ::ancestor.promoCode.description Click on the magnifier. > The description.
promoCode_id varchar2 itgen_vnet_promocode_id filters on the platform, writable, ::ancestor.promoCode.id Click on the magnifier. > The identifier.
recurringDiscount double itgen_vnet_recurringdiscount writable, recurringDiscount
recurringPrice double itgen_vnet_recurringprice writable, recurringPrice
renewalDiscount double itgen_vnet_renewaldiscount writable, renewalDiscount
renewalPrice double itgen_vnet_renewalprice writable, renewalPrice
setupDiscount double itgen_vnet_setupdiscount writable, setupDiscount
setupPrice double itgen_vnet_setupprice writable, setupPrice
totalPending double Total Pending filters on the platform, writable, ::ancestor.totalPending

Release Notes

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