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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
address |
varchar2 |
itgen_vnet_addressline1 | filters on the platform, writable, address |
The customer's first address line | |
address |
varchar2 |
itgen_vnet_addressline2 | filters on the platform, writable, address |
The customer's second address line | |
country |
varchar2 |
itgen_vnet_country | filters on the platform, writable, country |
The customer's country code | |
currency |
varchar2 |
Currency ID | filters on the platform, writable, currency |
The currency Id used by the customer | |
customer |
varchar2 |
itgen_vnet_customerclassid | filters on the platform, writable, customer |
The class of the customer | |
default |
varchar2 |
itgen_vnet_defaultlocation_corporateid | filters on the platform, writable, default |
The corporate id of the location | |
default |
varchar2 |
itgen_vnet_defaultlocation_countryid | filters on the platform, writable, default |
The country code of the location | |
default |
varchar2 |
itgen_vnet_defaultlocation_gln | filters on the platform, writable, default |
The global localization number of the location | |
default |
varchar2 |
itgen_vnet_defaultlocation_id | filters on the platform, writable, default |
Location id | |
default |
int32 |
itgen_vnet_defaultlocation_internalid | filters on the platform, writable, default |
An internal id of the customer location | |
default |
varchar2 |
itgen_vnet_defaultlocation_name | filters on the platform, writable, default |
Location description | |
default |
varchar2 |
itgen_vnet_defaultlocation_taxregistrationid | filters on the platform, writable, default |
The tax registration id of the location | |
default |
varchar2 |
itgen_vnet_defaultlocation_warehouseid | filters on the platform, writable, default |
The site id of the location | |
export |
varchar2 |
itgen_vnet_exporttype | filters on the platform, writable, export |
||
id |
varchar2 |
ID | filters on the platform, writable, id |
Unique id for the customer | |
internal |
int32 |
Internal ID | filters on the platform, writable, internal |
An internal unique id | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The name of the customer | |
postal |
varchar2 |
itgen_vnet_postalcode | filters on the platform, writable, postal |
The customer's postal code | |
sales |
varchar2 |
itgen_vnet_salesaccountid | filters on the platform, writable, sales |
The customer's sales account | |
sales |
varchar2 |
itgen_vnet_saleseuaccountid | filters on the platform, writable, sales |
The customer's EU sales account | |
sales |
varchar2 |
itgen_vnet_salesexportaccountid | filters on the platform, writable, sales |
The customer's export sales account | |
sales |
varchar2 |
itgen_vnet_salesnontaxableaccountid | filters on the platform, writable, sales |
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: