VoucherLines: Fortnox Voucher Lines
read only
- Catalog:
Fortnox - Schema:
Views - Label: Voucher Lines
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 VoucherLines 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 |
int32 |
Account | writable | ||
Cost |
varchar2 |
Cost Centre | writable | ||
Credit |
double |
Credit | writable | ||
Debit |
double |
Debit | writable | ||
Description |
varchar2 |
Description | writable | ||
Project |
varchar2 |
Project | writable | ||
Quantity |
double |
Quantity | writable | ||
Removed |
char |
Removed | writable | ||
Transaction |
varchar2 |
Transaction Information | writable | ||
Voucher |
int32 |
Approval State | filters on the platform, writable, Voucher |
||
Voucher |
varchar2 |
Description | filters on the platform, writable, Voucher |
||
Voucher |
int32 |
Voucher Number | filters on the platform, writable, Voucher |
||
Voucher |
varchar2 |
Reference Number | filters on the platform, writable, Voucher |
||
Voucher |
varchar2 |
Voucher Series | filters on the platform, writable, Voucher |
||
Voucher |
datetime |
Transaction Date | filters on the platform, writable, Voucher |
||
Year |
varchar2 |
Accounting Method | filters on the platform, writable, Year |
||
Year |
datetime |
To Date | filters on the platform, writable, Year |
||
YearId |
int32 |
ID | filters on the platform, writable, YearId |
||
Year |
datetime |
From Date | filters on the platform, writable, Year |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: