---
title: "CustomerContractDetailsLines (Visma.net Financials)"
description: "Customer Contract Details Lines"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CustomerContract.CustomerContractDetailsLines
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CustomerContract.CustomerContractDetailsLines
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `balance` | `double` | Balance | [ ] | filters on the platform, writable, `::ancestor.::ancestor.balance` | The top part &gt; Balance &gt; 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 &gt; Contract ID* &gt; 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. &gt; The description. |
| `contractTemplate_id` | `varchar2` | Contract Template ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.contractTemplate.id` | Click on the magnifier. &gt; 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. &gt; 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 &gt; Description* &gt; 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. &gt; The description. |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.location.id` | Click on the magnifier. &gt; 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. &gt; The description. |
| `promoCode_id` | `varchar2` | itgen_vnet_promocode_id | [ ] | writable, `::ancestor.promoCode.id` | Click on the magnifier. &gt; 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 &gt; Status &gt; 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 &gt; Activation date &gt; 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 &gt; Currency* &gt; The currency used in the contract. |
| `summary_expirationDate` | `datetime` | Expiration Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.summary.expirationDate` | Contract settings section &gt; Expiration date &gt; The date when the contract expires. |
| `summary_gracePeriod` | `int32` | Grace Period | [ ] | filters on the platform, writable, `::ancestor.::ancestor.summary.gracePeriod` | Contract settings section &gt; Grace period &gt; 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. &gt; 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. &gt; 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. &gt; The identifier. |
| `summary_invoiceTo` | `varchar2` | itgen_vnet_summary_invoiceto | [ ] | filters on the platform, writable, `::ancestor.::ancestor.summary.invoiceTo` | Invoice information section &gt; Invoice to &gt; 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 &gt; Invoicing period* &gt; 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 &gt; Invoice schedule starts on &gt; 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 &gt; Last invoicing date &gt; 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 &gt; Mass renewal &gt; 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 &gt; Next invoicing date &gt; 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 &gt; Renewal point &gt; 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. &gt; 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. &gt; The identifier. |
| `summary_setupDate` | `datetime` | itgen_vnet_summary_setupdate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.summary.setupDate` | Mandatory field: Contract settings section &gt; Setup date* &gt; The date of contract setup. |
| `summary_terminationDate` | `datetime` | itgen_vnet_summary_terminationdate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.summary.terminationDate` | Contract settings section &gt; Termination date &gt; 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](VismaNet.Customer.Customers)`.number` | Key |  |



## Release Notes

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

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

