invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerContractDetailsLines: Visma.net Financials Customer Contract Details Lines

read only REST

  • Catalog: VismaNet
  • Schema: CustomerContract
  • Label: Customer Contract Details Lines

Get a range of Customer Contracts, a filter needs to be specified - ScreenId=CT301000

Can only retrieve data.

API Source

  • Endpoint: /v1/customerContract
  • Operation: get /v1/customerContract

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
attributes `` Attributes (additional information) connected to the entity. Examples: {{base}}/customerContract?attributes={"AttributeID":"ValueID","AttributeID":"ValueID"} {{base}}/customerContract?attributes={"AttributeID":"ValueID1,ValueID2"}
contractTemplate ``
customer ``
expandAttributes ``
expandDetails ``
expandSummary ``
greaterThanValue ``
lastModifiedDateTime ``
lastModifiedDateTimeCondition ``
status `` Values: Draft, InApproval, Active, Expired, Canceled, Completed, InUpgrade, PendingActivation.

Table Columns

The columns of the table CustomerContractDetailsLines 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.
balance double Balance filters on the platform, writable, ::ancestor.::ancestor.balance The top part > Balance > A read-only field that displays the sum of the balances of open invoices associated with the contract.
contractDetailId int32 itgen_vnet_contractdetailid writable, contractDetailId
contractId varchar2 Contract ID filters on the platform, writable, ::ancestor.::ancestor.contractId Mandatory field: The top part > Contract ID* > The unique identifier of a contract.
contractTemplate_description varchar2 Contract Template Description filters on the platform, writable, ::ancestor.::ancestor.contractTemplate.description Click on the magnifier. > The description.
contractTemplate_id varchar2 Contract Template ID filters on the platform, writable, ::ancestor.::ancestor.contractTemplate.id Click on the magnifier. > The identifier.
currentRecurring double itgen_vnet_currentrecurring writable, ::ancestor.currentRecurring
currentRenewal double itgen_vnet_currentrenewal writable, ::ancestor.currentRenewal
currentSetup double itgen_vnet_currentsetup writable, ::ancestor.currentSetup
customer_name varchar2 Customer Name filters on the platform, writable, ::ancestor.::ancestor.customer.name Click the magnifier. > The name.
customer_number varchar2 Customer Number filters on the platform, writable, ::ancestor.::ancestor.customer.number
description varchar2 Description writable, description
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.::ancestor.description Mandatory field: The top part > Description* > The description of the contract, which includes any related comments.
difference double Difference writable, difference
effectiveFrom datetime Effective from 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
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.::ancestor.lastModifiedDateTime System generated information
location_description varchar2 Location Description filters on the platform, writable, ::ancestor.::ancestor.location.description Click on the magnifier. > The description.
location_id varchar2 Location ID filters on the platform, writable, ::ancestor.::ancestor.location.id Click on the magnifier. > The identifier.
pendingRecurring double itgen_vnet_pendingrecurring writable, ::ancestor.pendingRecurring
pendingRenewal double itgen_vnet_pendingrenewal writable, ::ancestor.pendingRenewal
pendingSetup double itgen_vnet_pendingsetup writable, ::ancestor.pendingSetup
promoCode_description varchar2 itgen_vnet_promocode_description writable, ::ancestor.promoCode.description Click on the magnifier. > The description.
promoCode_id varchar2 itgen_vnet_promocode_id 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
status varchar2 Status filters on the platform, writable, ::ancestor.::ancestor.status The top part > Status > The status of the contract, which is one of the following: Draft, Pending activation, Active, Expired, Cancelled, Pending update.
summary_activationDate datetime Activation Date filters on the platform, writable, ::ancestor.::ancestor.summary.activationDate Contract settings section > Activation date > The date to initiate the provision of the contract services.
summary_caseCountItem_description varchar2 itgen_vnet_summary_casecountitem_description filters on the platform, writable, ::ancestor.::ancestor.summary.caseCountItem.description Name of item/description
summary_caseCountItem_number varchar2 itgen_vnet_summary_casecountitem_number filters on the platform, writable, ::ancestor.::ancestor.summary.caseCountItem.number Number of item
summary_currency varchar2 Currency filters on the platform, writable, ::ancestor.::ancestor.summary.currency Mandatory field: Contract settings section > Currency* > The currency used in the contract.
summary_expirationDate datetime Expiration Date filters on the platform, writable, ::ancestor.::ancestor.summary.expirationDate Contract settings section > Expiration date > The date when the contract expires.
summary_gracePeriod int32 Grace Period filters on the platform, writable, ::ancestor.::ancestor.summary.gracePeriod Contract settings section > Grace period > The number of days after the expiration date where the contract can still be renewed.
summary_invoiceAccount_name varchar2 itgen_vnet_summary_invoiceaccount_name filters on the platform, writable, ::ancestor.::ancestor.summary.invoiceAccount.name Click the magnifier. > The name.
summary_invoiceAccount_number varchar2 itgen_vnet_summary_invoiceaccount_number filters on the platform, writable, ::ancestor.::ancestor.summary.invoiceAccount.number
summary_invoiceLocation_description varchar2 itgen_vnet_summary_invoicelocation_description filters on the platform, writable, ::ancestor.::ancestor.summary.invoiceLocation.description Click on the magnifier. > The description.
summary_invoiceLocation_id varchar2 itgen_vnet_summary_invoicelocation_id filters on the platform, writable, ::ancestor.::ancestor.summary.invoiceLocation.id Click on the magnifier. > The identifier.
summary_invoiceTo varchar2 itgen_vnet_summary_invoiceto filters on the platform, writable, ::ancestor.::ancestor.summary.invoiceTo Invoice information section > Invoice to > The setting that defines the customer account to be invoiced for a contract. The following options are available: Parent account, Customer account, Specific account.
summary_invoicingPeriod varchar2 itgen_vnet_summary_invoicingperiod filters on the platform, writable, ::ancestor.::ancestor.summary.invoicingPeriod Mandatory field: Invoicing schedule section > Invoicing period* > The type of invoicing schedule, which can be one of the following options: Weekly, Monthly; Quarterly, Half a year, Yearly, On demand, Statement based.
summary_invoicingScheduleStartsOn datetime itgen_vnet_summary_invoicingschedulestartson filters on the platform, writable, ::ancestor.::ancestor.summary.invoicingScheduleStartsOn Invoicing schedule section > Invoice schedule starts on > A read-only field that displays the start date of the first invoicing period.
summary_lastInvoicingDate datetime itgen_vnet_summary_lastinvoicingdate filters on the platform, writable, ::ancestor.::ancestor.summary.lastInvoicingDate Invoicing schedule section > Last invoicing date > A read-only field that shows the date when the invoicing was performed most recently.
summary_massRenewal char itgen_vnet_summary_massrenewal filters on the platform, writable, ::ancestor.::ancestor.summary.massRenewal Contract settings section > Mass renewal > A check box indicating renewal of all contract at expiration date.
summary_nextInvoicingDate datetime itgen_vnet_summary_nextinvoicingdate filters on the platform, writable, ::ancestor.::ancestor.summary.nextInvoicingDate Invoicing schedule section > Next invoicing date > The date of the next invoicing invoice, according to the invoicing schedule.
summary_owner_internalId varchar2 itgen_vnet_summary_owner_internalid filters on the platform, writable, ::ancestor.::ancestor.summary.owner.internalId
summary_owner_name varchar2 itgen_vnet_summary_owner_name filters on the platform, writable, ::ancestor.::ancestor.summary.owner.name The name of the particular destination of the selected type.
summary_owner_number varchar2 itgen_vnet_summary_owner_number filters on the platform, writable, ::ancestor.::ancestor.summary.owner.number The identifier of the particular destination of the selected type.
summary_renewalPoint int32 itgen_vnet_summary_renewalpoint filters on the platform, writable, ::ancestor.::ancestor.summary.renewalPoint Contract settings section > Renewal point > The number of days before expiration where the renewal process are to begin.
summary_salesPerson_description varchar2 itgen_vnet_summary_salesperson_description filters on the platform, writable, ::ancestor.::ancestor.summary.salesPerson.description Click on the magnifier. > The description.
summary_salesPerson_id varchar2 itgen_vnet_summary_salesperson_id filters on the platform, writable, ::ancestor.::ancestor.summary.salesPerson.id Click on the magnifier. > The identifier.
summary_setupDate datetime itgen_vnet_summary_setupdate filters on the platform, writable, ::ancestor.::ancestor.summary.setupDate Mandatory field: Contract settings section > Setup date* > The date of contract setup.
summary_terminationDate datetime itgen_vnet_summary_terminationdate filters on the platform, writable, ::ancestor.::ancestor.summary.terminationDate Contract settings section > Termination date > The date when the contract will be cancelled; no services will be provided.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.::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)
totalPending double Total Pending writable, ::ancestor.totalPending

Keys

Key Column Refers to Kind Description
CustomerContractDetailsLines_customer_number_fk customer_number Customers.number Key

Release Notes

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