CustomerLocationsByCustomerId: Visma.net Financials itgen_vnet_customerlocationsbycustomerid_plural
read only REST
- Catalog:
NgSalesOrders - Schema:
Customers - Label: itgen_vnet_customerlocationsbycustomerid_plural
Gets a list of locations for the specified customer Sample request:
GET /customers/10000/locations
Can only retrieve data.
Summary
Sample request:
GET /customers/10000/locations
API Source
- Endpoint:
/api/v3/Customers/{customerId}/locations - Operation:
get /api/v3/Customers/{customerId}/locations
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 |
|---|---|---|---|---|
customer |
`` | The customer id (CustomerCd) to retrieve locations for |
Table Columns
The columns of the table CustomerLocationsByCustomerId 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 |
City | filters on the platform, writable, address. |
The city | |
address_ |
varchar2 |
Country ID | filters on the platform, writable, address. |
The id | |
address_ |
varchar2 |
Country Name | filters on the platform, writable, address. |
The name | |
address_ |
varchar2 |
County ID | filters on the platform, writable, address. |
The id | |
address_ |
varchar2 |
County Name | filters on the platform, writable, address. |
The name | |
address_ |
int32 |
itgen_vnet_address_id | filters on the platform, writable, address. |
The address id | |
address_ |
varchar2 |
itgen_vnet_address_line1 | filters on the platform, writable, address. |
Address line 1 | |
address_ |
varchar2 |
itgen_vnet_address_line2 | filters on the platform, writable, address. |
Address line 2 | |
address_ |
varchar2 |
itgen_vnet_address_line3 | filters on the platform, writable, address. |
Address line 3 | |
address_ |
char |
itgen_vnet_address_overridesdefault | filters on the platform, writable, address. |
Whether this address overrides the default address | |
address_ |
varchar2 |
Postal Code | filters on the platform, writable, address. |
The postal code | |
contact_ |
varchar2 |
itgen_vnet_contact_attention | filters on the platform, writable, contact. |
Any attention for the contact | |
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, contact. |
The e-mail address of the contact | |
contact_ |
varchar2 |
Contact Fax | filters on the platform, writable, contact. |
The fax number of the contact | |
contact_ |
int32 |
Contact ID | filters on the platform, writable, contact. |
The id of the contact | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, contact. |
The name of the contact | |
contact_ |
char |
itgen_vnet_contact_overridesdefault | filters on the platform, writable, contact. |
Whether this overrides the default contact | |
contact_ |
varchar2 |
Contact Phone 1 | filters on the platform, writable, contact. |
The phone number of the contact | |
contact_ |
varchar2 |
Contact Phone 2 | filters on the platform, writable, contact. |
The secondary phone number of the contact | |
corporate |
varchar2 |
Corporate ID | filters on the platform, writable, corporate |
The corporate id of the location | |
country |
varchar2 |
itgen_vnet_countryid | filters on the platform, writable, country |
The country code of the location | |
export |
varchar2 |
itgen_vnet_exporttype | filters on the platform, writable, export |
||
fob |
varchar2 |
itgen_vnet_fobpointid | filters on the platform, writable, fob |
Default FobPointId | |
gln |
varchar2 |
GLN | filters on the platform, writable, gln |
The global localization number of the location | |
id |
varchar2 |
ID | filters on the platform, writable, id |
Location id | |
insurance |
char |
Insurance | filters on the platform, writable, insurance |
Default Insurance | |
internal |
int32 |
Internal ID | filters on the platform, writable, internal |
An internal id of the customer location | |
lead |
int32 |
itgen_vnet_leadtime | filters on the platform, writable, lead |
The number of days required for the shipped goods to reach the customer. Used in the calculation of the scheduled shipment date | |
name |
varchar2 |
Name | filters on the platform, writable, name |
Location description | |
preferred |
varchar2 |
itgen_vnet_preferredwarehouseid | filters on the platform, writable, preferred |
The preferred shipping warehouse of the customer set default for the order | |
price |
varchar2 |
itgen_vnet_priceclassid | filters on the platform, writable, price |
Price class | |
priority |
int32 |
Priority | filters on the platform, writable, priority |
Default Priority | |
residential |
char |
Residential Delivery | filters on the platform, writable, residential |
Default ResidentialDelivery | |
sales |
varchar2 |
itgen_vnet_salesaccountid | filters on the platform, writable, sales |
Location sales account | |
sales |
varchar2 |
itgen_vnet_saleseuaccountid | filters on the platform, writable, sales |
Location EU Sales Account | |
sales |
varchar2 |
itgen_vnet_salesexportaccountid | filters on the platform, writable, sales |
Location export sales account | |
sales |
varchar2 |
itgen_vnet_salesnontaxableaccountid | filters on the platform, writable, sales |
Location non taxable sales account | |
saturday |
char |
Saturday Delivery | filters on the platform, writable, saturday |
Default SaturdayDelivery | |
ship |
varchar2 |
itgen_vnet_shiptermsid | filters on the platform, writable, ship |
Default ShipTermsId | |
ship |
varchar2 |
itgen_vnet_shipviaid | filters on the platform, writable, ship |
The ship via id that represents the carrier and its service to be used for shipping the ordered goods | |
ship |
varchar2 |
itgen_vnet_shipzoneid | filters on the platform, writable, ship |
Default ShipZoneId | |
shipping |
varchar2 |
itgen_vnet_shippingrule | filters on the platform, writable, shipping |
Shipping rule of the customer set default for the order Is one of the following options: CancelRemainder: The ordered quantity should be delivered in one shipmentBackOrderAllowed: The ordered quantity can be delivered in multiple shipments.ShipComplete: The ordered quantity should be delivered in one shipment. | |
tax |
varchar2 |
itgen_vnet_taxregistrationid | filters on the platform, writable, tax |
The tax registration id of the location | |
tax |
varchar2 |
Tax Zone ID | filters on the platform, writable, tax |
The location tax/VAT zone id | |
warehouse |
varchar2 |
Warehouse ID | filters on the platform, writable, warehouse |
The site id of the location |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: