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 |
|---|---|---|---|---|
branch |
`` | Filter by Branch | ||
customer |
`` | Filter by Customer | ||
from |
`` | 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. | ||
to |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
adjustments |
double |
itgen_vnet_adjustmentsanddiscounts | filters on the platform, writable, adjustments |
Adjustments and discounts | |
begin |
double |
itgen_vnet_beginbalance | filters on the platform, writable, begin |
Begin balance | |
branch |
varchar2 |
Branch Name | filters on the platform, writable, branch |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | filters on the platform, writable, branch |
Click the magnifier. > The identifier. | |
customer_ |
int32 |
Customer Internal ID | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, customer. |
The name of the particular destination of the selected type. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, customer. |
The identifier of the particular destination of the selected type. | |
overdue |
double |
itgen_vnet_overduecharges | filters on the platform, writable, overdue |
Overdue charges | |
payments |
double |
itgen_vnet_paymentsandprepayments | filters on the platform, writable, payments |
Payments and prepayments | |
sales |
double |
itgen_vnet_sales | filters on the platform, writable, sales |
Purchases | |
year |
double |
itgen_vnet_yeartodatebalance | filters on the platform, writable, year |
Year to date balance |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: