invantive documentation
Invantive Support ForumsLog In / Sign Up

LocationsByBAccountId: Visma.net Financials Locations by Bank Account ID

read only REST

  • Catalog: VismaNet
  • Schema: Location
  • Label: Locations by Bank Account ID

Get a range of Locations for a BAccount Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size Data for the Locations

Can only retrieve data.

Summary

Data for the Locations

API Source

  • Endpoint: /v1/location/{bAccountId}
  • Operation: get /v1/location/{bAccountId}

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
bAccountId `` Identifies the BAccount
createdDateTime `` This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
createdDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
gln ``
greaterThanValue `` Greater than value. The item which is the object for this, varies from API to API.
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
locationId ``

Table Columns

The columns of the table LocationsByBAccountId 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.
active char Active filters on the platform, writable, active The top part > Active > A check box that you select if the location is active.
address_addressId int32 Address ID filters on the platform, writable, address.addressId
address_addressLine1 varchar2 Address Line 1 filters on the platform, writable, address.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
address_addressLine2 varchar2 Address Line 2 filters on the platform, writable, address.addressLine2 Address 2 > The second line of the address.
address_addressLine3 varchar2 Address Line 3 filters on the platform, writable, address.addressLine3 Address 3 > The third line of the address.
address_city varchar2 City filters on the platform, writable, address.city City > The city.
address_country_errorInfo varchar2 itgen_vnet_address_country_errorinfo filters on the platform, writable, address.country.errorInfo
address_country_id varchar2 Country ID filters on the platform, writable, address.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
address_country_metadata_maxPageSize int64 itgen_vnet_address_country_metadata_maxpagesize filters on the platform, writable, address.country.metadata.maxPageSize
address_country_metadata_totalCount int64 itgen_vnet_address_country_metadata_totalcount filters on the platform, writable, address.country.metadata.totalCount
address_country_name varchar2 Country Name filters on the platform, writable, address.country.name Mandatory field: Country name* > The complete name of the country.
address_county_id varchar2 County ID filters on the platform, writable, address.county.id Click the magnifier > The identifier
address_county_name varchar2 County Name filters on the platform, writable, address.county.name Click the magnifier > The displayed name
address_postalCode varchar2 Postal Code filters on the platform, writable, address.postalCode Postcode > The postcode.
baccount_internalId int32 itgen_vnet_baccount_internalid filters on the platform, writable, baccount.internalId
baccount_name varchar2 itgen_vnet_baccount_name filters on the platform, writable, baccount.name The name of the particular destination of the selected type.
baccount_number varchar2 itgen_vnet_baccount_number filters on the platform, writable, baccount.number The identifier of the particular destination of the selected type.
contact_attention varchar2 itgen_vnet_contact_attention filters on the platform, writable, contact.attention Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.
contact_contactId int32 Contact ID filters on the platform, writable, contact.contactId
contact_email varchar2 Contact Email filters on the platform, writable, contact.email Email > The email address of the customer/supplier/company as a business entity.
contact_fax varchar2 Contact Fax filters on the platform, writable, contact.fax Fax > The fax number.
contact_name varchar2 Contact Name filters on the platform, writable, contact.name Name > The legal name of to appear on the documents.
contact_phone1 varchar2 Contact Phone 1 filters on the platform, writable, contact.phone1 Phone 1 > The default phone number.
contact_phone2 varchar2 Contact Phone 2 filters on the platform, writable, contact.phone2 Phone 2 > An additional phone number.
contact_web varchar2 Contact Website filters on the platform, writable, contact.web Web > The website of the company, if one exists.
corporateId varchar2 Corporate ID filters on the platform, writable, corporateId General information tab > Location address section > Corporate ID > The corporate ID associated with the customer location.
ediCode varchar2 EDI Code filters on the platform, writable, ediCode General information tab > Location address section > EDI code > The EDI code to be used for the customer location.
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
gln varchar2 GLN filters on the platform, writable, gln General information tab > Location address section > GLN > The GLN to be used for the customer location.
internalId int32 Internal ID filters on the platform, writable, internalId
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime System generation information
locationId varchar2 Location ID filters on the platform, writable, locationId Mandatory field: The top part > Location ID* > The identifier of the location. Click the magnifier.
locationName varchar2 Location Name filters on the platform, writable, locationName The top part > Location name > A descriptive name to help users recognize the location.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
peppolScheme_endpoint varchar2 itgen_vnet_peppolscheme_endpoint filters on the platform, writable, peppolScheme.endpoint Seller electronic address identification scheme identifier. The identification scheme identifier of the seller electronic address.
peppolScheme_partyIdentification varchar2 itgen_vnet_peppolscheme_partyidentification filters on the platform, writable, peppolScheme.partyIdentification Buyer identifier identification scheme identifier. The identification scheme identifier of the Buyer identifier.
peppolScheme_partyLegal varchar2 itgen_vnet_peppolscheme_partylegal filters on the platform, writable, peppolScheme.partyLegal Seller legal registration identifier identification scheme identifier. The identification scheme identifier of the Seller legal registration identifier.
vatRegistrationId varchar2 VAT Registration ID filters on the platform, writable, vatRegistrationId General information tab > Location address section > VAT registration ID > The optional VAT registration ID associated with the location.
vatZone_defaultTaxCategory_description varchar2 VAT Zone Default Tax Category Description filters on the platform, writable, vatZone.defaultTaxCategory.description Name of item/description
vatZone_defaultTaxCategory_number varchar2 VAT Zone Default Tax Category Number filters on the platform, writable, vatZone.defaultTaxCategory.number Number of item
vatZone_defaultVatCategory varchar2 VAT Zone Default VAT Category filters on the platform, writable, vatZone.defaultVatCategory Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_description varchar2 VAT Zone Description filters on the platform, writable, vatZone.description Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_errorInfo varchar2 itgen_vnet_vatzone_errorinfo filters on the platform, writable, vatZone.errorInfo
vatZone_id varchar2 VAT Zone ID filters on the platform, writable, vatZone.id Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_metadata_maxPageSize int64 itgen_vnet_vatzone_metadata_maxpagesize filters on the platform, writable, vatZone.metadata.maxPageSize
vatZone_metadata_totalCount int64 itgen_vnet_vatzone_metadata_totalcount filters on the platform, writable, vatZone.metadata.totalCount

Release Notes

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