invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerV2CustomerBalance3: Visma.net Financials itgen_vnet_customerv2customerbalance_plural

read only REST

  • Catalog: VismaNet
  • Schema: CustomerV2
  • Label: itgen_vnet_customerv2customerbalance_plural

Get the balance for one or multiple customers

Can only retrieve data.

API Source

  • Endpoint: /v2/customer/balance
  • Operation: get /v2/customer/balance

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
branchNumber `` Filter by Branch
customer `` Filter by Customer
fromFinPeriod `` Filter from financial period, format YYYYPP The filte is inclusive, the records for the specified period will be included in the results. This filter is required.
toFinPeriod `` Filter to financial period, format YYYYPP The filte is inclusive, the records for the specified period will be included in the results. This filter is required.

Table Columns

The columns of the table CustomerV2CustomerBalance3 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.
adjustmentsAndDiscounts double itgen_vnet_adjustmentsanddiscounts filters on the platform, writable, adjustmentsAndDiscounts Adjustments and discounts
beginBalance double itgen_vnet_beginbalance filters on the platform, writable, beginBalance Begin balance
branchNumber_name varchar2 Branch Name filters on the platform, writable, branchNumber.name Click the magnifier. > The name.
branchNumber_number varchar2 Branch Number filters on the platform, writable, branchNumber.number Click the magnifier. > The identifier.
customer_internalId int32 Customer Internal ID filters on the platform, writable, customer.internalId
customer_name varchar2 Customer Name filters on the platform, writable, customer.name The name of the particular destination of the selected type.
customer_number varchar2 Customer Number filters on the platform, writable, customer.number The identifier of the particular destination of the selected type.
overdueCharges double itgen_vnet_overduecharges filters on the platform, writable, overdueCharges Overdue charges
paymentsAndPrepayments double itgen_vnet_paymentsandprepayments filters on the platform, writable, paymentsAndPrepayments Payments and prepayments
sales double itgen_vnet_sales filters on the platform, writable, sales Purchases
yearToDateBalance double itgen_vnet_yeartodatebalance filters on the platform, writable, yearToDateBalance Year to date balance

Release Notes

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