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

# Customers: Visma.net Financials Customers

`read only` `REST`

- Catalog: `NgSalesOrders`
- Schema: `Customers`
- Label: Customers

Gets a list of customers
Sample request:
            
GET /customers?filter=visma&pageSize=10

Can only retrieve data.

## Summary

Sample request:
            
GET /customers?filter=visma&pageSize=10

## API Source

- Endpoint: `/api/v3/Customers`
- Operation: `get /api/v3/Customers`

## 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.

## Table Columns

The columns of the table `Customers` 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. |
| `addressLine1` | `varchar2` | itgen_vnet_addressline1 | [ ] | filters on the platform, writable, `addressLine1` | The customer's first address line |
| `addressLine2` | `varchar2` | itgen_vnet_addressline2 | [ ] | filters on the platform, writable, `addressLine2` | The customer's second address line |
| `country` | `varchar2` | itgen_vnet_country | [ ] | filters on the platform, writable, `country` | The customer's country code |
| `currencyId` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `currencyId` | The currency Id used by the customer |
| `customerClassId` | `varchar2` | itgen_vnet_customerclassid | [ ] | filters on the platform, writable, `customerClassId` | The class of the customer |
| `defaultLocation_corporateId` | `varchar2` | itgen_vnet_defaultlocation_corporateid | [ ] | filters on the platform, writable, `defaultLocation.corporateId` | The corporate id of the location |
| `defaultLocation_countryId` | `varchar2` | itgen_vnet_defaultlocation_countryid | [ ] | filters on the platform, writable, `defaultLocation.countryId` | The country code of the location |
| `defaultLocation_gln` | `varchar2` | itgen_vnet_defaultlocation_gln | [ ] | filters on the platform, writable, `defaultLocation.gln` | The global localization number of the location |
| `defaultLocation_id` | `varchar2` | itgen_vnet_defaultlocation_id | [ ] | filters on the platform, writable, `defaultLocation.id` | Location id |
| `defaultLocation_internalId` | `int32` | itgen_vnet_defaultlocation_internalid | [ ] | filters on the platform, writable, `defaultLocation.internalId` | An internal id of the customer location |
| `defaultLocation_name` | `varchar2` | itgen_vnet_defaultlocation_name | [ ] | filters on the platform, writable, `defaultLocation.name` | Location description |
| `defaultLocation_taxRegistrationId` | `varchar2` | itgen_vnet_defaultlocation_taxregistrationid | [ ] | filters on the platform, writable, `defaultLocation.taxRegistrationId` | The tax registration id of the location |
| `defaultLocation_warehouseId` | `varchar2` | itgen_vnet_defaultlocation_warehouseid | [ ] | filters on the platform, writable, `defaultLocation.warehouseId` | The site id of the location |
| `exportType` | `varchar2` | itgen_vnet_exporttype | [ ] | filters on the platform, writable, `exportType` |  |
| `id` | `varchar2` | ID | [ ] | filters on the platform, writable, `id` | Unique id for the customer |
| `internalId` | `int32` | Internal ID | [ ] | filters on the platform, writable, `internalId` | An internal unique id |
| `name` | `varchar2` | Name | [ ] | filters on the platform, writable, `name` | The name of the customer |
| `postalCode` | `varchar2` | itgen_vnet_postalcode | [ ] | filters on the platform, writable, `postalCode` | The customer's postal code |
| `salesAccountId` | `varchar2` | itgen_vnet_salesaccountid | [ ] | filters on the platform, writable, `salesAccountId` | The customer's sales account |
| `salesEuAccountId` | `varchar2` | itgen_vnet_saleseuaccountid | [ ] | filters on the platform, writable, `salesEuAccountId` | The customer's EU sales account |
| `salesExportAccountId` | `varchar2` | itgen_vnet_salesexportaccountid | [ ] | filters on the platform, writable, `salesExportAccountId` | The customer's export sales account |
| `salesNonTaxableAccountId` | `varchar2` | itgen_vnet_salesnontaxableaccountid | [ ] | filters on the platform, writable, `salesNonTaxableAccountId` | The customer's non taxable sales account |
| `salutation` | `varchar2` | itgen_vnet_salutation | [ ] | filters on the platform, writable, `salutation` | The customer's salutation |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `status` | The customer's status code |

## Sample Queries

```sql
--
-- All Visma.net Financials customers.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/visma-net-data-model/webhelp/visma-net-financials-connector-customer-customers.html
--
select *
from   VismaNet.Customer.Customers@vnt
limit  100
```



## 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)

