invantive documentation
Invantive Support ForumsLog In / Sign Up

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 writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name 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

--
-- 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: