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

# CustomerContracts: Visma.net Financials Customer Contracts

`insert` `update` `REST`

- Catalog: `VismaNet`
- Schema: `CustomerContract`
- Primary Keys: `contractId`
- Label: Customer Contracts

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

Can retrieve data and change data using `insert` and `update`.

## 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 `CustomerContracts` 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, `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. |
| `contractId` | `varchar2` | Contract ID | [ ] | filters on the platform, writable, `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, `contractTemplate.description` | Click on the magnifier. &gt; The description. |
| `contractTemplate_id` | `varchar2` | Contract Template ID | [ ] | filters on the platform, writable, `contractTemplate.id` | Click on the magnifier. &gt; The identifier. |
| `customer_name` | `varchar2` | Customer Name | [ ] | filters on the platform, writable, `customer.name` | Click the magnifier. &gt; The name. |
| `customer_number` | `varchar2` | Customer Number | [ ] | filters on the platform, writable, `customer.number` |  |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` | Mandatory field: The top part &gt; Description* &gt; The description of the contract, which includes any related comments. |
| `details_currentRecurring` | `double` | itgen_vnet_details_currentrecurring | [ ] | filters on the platform, writable, `details.currentRecurring` |  |
| `details_currentRenewal` | `double` | itgen_vnet_details_currentrenewal | [ ] | filters on the platform, writable, `details.currentRenewal` |  |
| `details_currentSetup` | `double` | itgen_vnet_details_currentsetup | [ ] | filters on the platform, writable, `details.currentSetup` |  |
| `details_effectiveFrom` | `datetime` | itgen_vnet_details_effectivefrom | [ ] | filters on the platform, writable, `details.effectiveFrom` |  |
| `details_pendingRecurring` | `double` | itgen_vnet_details_pendingrecurring | [ ] | filters on the platform, writable, `details.pendingRecurring` |  |
| `details_pendingRenewal` | `double` | itgen_vnet_details_pendingrenewal | [ ] | filters on the platform, writable, `details.pendingRenewal` |  |
| `details_pendingSetup` | `double` | itgen_vnet_details_pendingsetup | [ ] | filters on the platform, writable, `details.pendingSetup` |  |
| `details_promoCode_description` | `varchar2` | itgen_vnet_details_promocode_description | [ ] | filters on the platform, writable, `details.promoCode.description` | Click on the magnifier. &gt; The description. |
| `details_promoCode_id` | `varchar2` | itgen_vnet_details_promocode_id | [ ] | filters on the platform, writable, `details.promoCode.id` | Click on the magnifier. &gt; The identifier. |
| `details_totalPending` | `double` | Total Pending | [ ] | filters on the platform, writable, `details.totalPending` |  |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `lastModifiedDateTime` | System generated information |
| `location_description` | `varchar2` | Location Description | [ ] | filters on the platform, writable, `location.description` | Click on the magnifier. &gt; The description. |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `location.id` | Click on the magnifier. &gt; The identifier. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `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, `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, `summary.caseCountItem.description` | Name of item/description |
| `summary_caseCountItem_number` | `varchar2` | itgen_vnet_summary_casecountitem_number | [ ] | filters on the platform, writable, `summary.caseCountItem.number` | Number of item |
| `summary_currency` | `varchar2` | Currency | [ ] | filters on the platform, writable, `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, `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, `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, `summary.invoiceAccount.name` | Click the magnifier. &gt; The name. |
| `summary_invoiceAccount_number` | `varchar2` | itgen_vnet_summary_invoiceaccount_number | [ ] | filters on the platform, writable, `summary.invoiceAccount.number` |  |
| `summary_invoiceLocation_description` | `varchar2` | itgen_vnet_summary_invoicelocation_description | [ ] | filters on the platform, writable, `summary.invoiceLocation.description` | Click on the magnifier. &gt; The description. |
| `summary_invoiceLocation_id` | `varchar2` | itgen_vnet_summary_invoicelocation_id | [ ] | filters on the platform, writable, `summary.invoiceLocation.id` | Click on the magnifier. &gt; The identifier. |
| `summary_invoiceTo` | `varchar2` | itgen_vnet_summary_invoiceto | [ ] | filters on the platform, writable, `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, `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, `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, `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, `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, `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, `summary.owner.internalId` |  |
| `summary_owner_name` | `varchar2` | itgen_vnet_summary_owner_name | [ ] | filters on the platform, writable, `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, `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, `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, `summary.salesPerson.description` | Click on the magnifier. &gt; The description. |
| `summary_salesPerson_id` | `varchar2` | itgen_vnet_summary_salesperson_id | [ ] | filters on the platform, writable, `summary.salesPerson.id` | Click on the magnifier. &gt; The identifier. |
| `summary_setupDate` | `datetime` | itgen_vnet_summary_setupdate | [ ] | filters on the platform, writable, `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, `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, `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) |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `CustomerContracts_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)

