invantive documentation
Invantive Support ForumsLog In / Sign Up

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
customerId `` 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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
address_city varchar2 City filters on the platform, writable, address.city The city
address_country_id varchar2 Country ID filters on the platform, writable, address.country.id The id
address_country_name varchar2 Country Name filters on the platform, writable, address.country.name The name
address_county_id varchar2 County ID filters on the platform, writable, address.county.id The id
address_county_name varchar2 County Name filters on the platform, writable, address.county.name The name
address_id int32 itgen_vnet_address_id filters on the platform, writable, address.id The address id
address_line1 varchar2 itgen_vnet_address_line1 filters on the platform, writable, address.line1 Address line 1
address_line2 varchar2 itgen_vnet_address_line2 filters on the platform, writable, address.line2 Address line 2
address_line3 varchar2 itgen_vnet_address_line3 filters on the platform, writable, address.line3 Address line 3
address_overridesDefault char itgen_vnet_address_overridesdefault filters on the platform, writable, address.overridesDefault Whether this address overrides the default address
address_postalCode varchar2 Postal Code filters on the platform, writable, address.postalCode The postal code
contact_attention varchar2 itgen_vnet_contact_attention filters on the platform, writable, contact.attention Any attention for the contact
contact_email varchar2 Contact Email filters on the platform, writable, contact.email The e-mail address of the contact
contact_fax varchar2 Contact Fax filters on the platform, writable, contact.fax The fax number of the contact
contact_id int32 Contact ID filters on the platform, writable, contact.id The id of the contact
contact_name varchar2 Contact Name filters on the platform, writable, contact.name The name of the contact
contact_overridesDefault char itgen_vnet_contact_overridesdefault filters on the platform, writable, contact.overridesDefault Whether this overrides the default contact
contact_phone1 varchar2 Contact Phone 1 filters on the platform, writable, contact.phone1 The phone number of the contact
contact_phone2 varchar2 Contact Phone 2 filters on the platform, writable, contact.phone2 The secondary phone number of the contact
corporateId varchar2 Corporate ID filters on the platform, writable, corporateId The corporate id of the location
countryId varchar2 itgen_vnet_countryid filters on the platform, writable, countryId The country code of the location
exportType varchar2 itgen_vnet_exporttype filters on the platform, writable, exportType
fobPointId varchar2 itgen_vnet_fobpointid filters on the platform, writable, fobPointId 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
internalId int32 Internal ID filters on the platform, writable, internalId An internal id of the customer location
leadTime int32 itgen_vnet_leadtime filters on the platform, writable, leadTime 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
preferredWarehouseId varchar2 itgen_vnet_preferredwarehouseid filters on the platform, writable, preferredWarehouseId The preferred shipping warehouse of the customer set default for the order
priceClassId varchar2 itgen_vnet_priceclassid filters on the platform, writable, priceClassId Price class
priority int32 Priority filters on the platform, writable, priority Default Priority
residentialDelivery char Residential Delivery filters on the platform, writable, residentialDelivery Default ResidentialDelivery
salesAccountId varchar2 itgen_vnet_salesaccountid filters on the platform, writable, salesAccountId Location sales account
salesEuAccountId varchar2 itgen_vnet_saleseuaccountid filters on the platform, writable, salesEuAccountId Location EU Sales Account
salesExportAccountId varchar2 itgen_vnet_salesexportaccountid filters on the platform, writable, salesExportAccountId Location export sales account
salesNonTaxableAccountId varchar2 itgen_vnet_salesnontaxableaccountid filters on the platform, writable, salesNonTaxableAccountId Location non taxable sales account
saturdayDelivery char Saturday Delivery filters on the platform, writable, saturdayDelivery Default SaturdayDelivery
shipTermsId varchar2 itgen_vnet_shiptermsid filters on the platform, writable, shipTermsId Default ShipTermsId
shipViaId varchar2 itgen_vnet_shipviaid filters on the platform, writable, shipViaId The ship via id that represents the carrier and its service to be used for shipping the ordered goods
shipZoneId varchar2 itgen_vnet_shipzoneid filters on the platform, writable, shipZoneId Default ShipZoneId
shippingRule varchar2 itgen_vnet_shippingrule filters on the platform, writable, shippingRule 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.
taxRegistrationId varchar2 itgen_vnet_taxregistrationid filters on the platform, writable, taxRegistrationId The tax registration id of the location
taxZoneId varchar2 Tax Zone ID filters on the platform, writable, taxZoneId The location tax/VAT zone id
warehouseId varchar2 Warehouse ID filters on the platform, writable, warehouseId The site id of the location

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: