AccountActiveBalances: Fortnox Fortnox Active Account Balances
read only
- Catalog:
Fortnox - Schema:
Views - Label: Fortnox Active Account Balances
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 356 |
| Full scan rows per minute | 85,000 |
| Point query rows per minute | 168 |
The result can be cached on the client.
Table Columns
The columns of the table AccountActiveBalances 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 |
|---|---|---|---|---|---|
Account |
char |
Active | filters on the platform, writable, Account |
||
Account |
varchar2 |
Description | filters on the platform, writable, Account |
||
Account |
int32 |
Number | filters on the platform, writable, Account |
||
Account |
int32 |
Year | filters on the platform, writable, Account |
||
Balance |
double |
Account Balance Brought Forward | filters on the platform, writable, Balance |
||
Balance |
double |
Account Balance Carried Forward | filters on the platform, writable, Balance |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: