SupplierInvoiceLines: Fortnox Fortnox Supplier Invoice Lines
read only
- Catalog:
Fortnox - Schema:
Views - Label: Fortnox Supplier Invoice 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 SupplierInvoiceLines 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 | ||
Account |
varchar2 |
General Ledger Account Description | writable | ||
Accounting |
varchar2 |
Accounting Method | writable | ||
Administration |
varchar2 |
Administration Fee | writable | ||
Article |
varchar2 |
Article Number | writable | ||
Balance |
varchar2 |
Balance | writable | ||
Booked |
char |
Booked | writable | ||
Cancelled |
char |
Cancelled | writable | ||
Code |
varchar2 |
Code | writable | ||
Comments |
varchar2 |
Comments | writable | ||
Cost |
varchar2 |
Cost Centre | writable | ||
Cost |
varchar2 |
Cost Centre 2 | writable | ||
Credit |
double |
Credit | writable | ||
Credit |
double |
Credit Currency | writable | ||
Credit |
int32 |
Credit Reference | writable | ||
Credit_ |
char |
Credit 2 | writable | ||
Currency |
varchar2 |
Currency | writable | ||
Currency |
varchar2 |
Currency Rate | writable | ||
Currency |
double |
Currency Unit | writable | ||
Debit |
double |
Debit | writable | ||
Debit |
double |
Debit Currency | writable | ||
Disable |
char |
Disable Payment File | writable | ||
Due |
datetime |
Due Date | writable | ||
External |
varchar2 |
External Invoice Number | writable | ||
External |
varchar2 |
External Invoice Series | writable | ||
Final |
datetime |
Final Pay Date | writable | ||
Freight |
varchar2 |
Freight | writable | ||
Given |
varchar2 |
Given Number | writable | ||
Invoice |
datetime |
Invoice Date | writable | ||
Invoice |
varchar2 |
Invoice Number | writable | ||
Item |
varchar2 |
Item Description | writable | ||
OCR |
varchar2 |
Ocr | writable | ||
Our |
varchar2 |
Ourreference | writable | ||
Payment |
char |
Payment Pending | writable | ||
Price |
double |
Price | writable | ||
Project |
varchar2 |
Project | writable | ||
Project_ |
varchar2 |
Project 2 | writable | ||
Quantity |
int32 |
Quantity | writable | ||
Round |
varchar2 |
Round Off Value | writable | ||
Sales |
varchar2 |
Sales Type | writable | ||
Stock |
varchar2 |
Stock Location Code | writable | ||
Stock |
varchar2 |
Stock Point Code | writable | ||
Supplier |
varchar2 |
Authorizer Name | filters on the platform, writable | ||
Supplier |
varchar2 |
Balance | filters on the platform, writable | ||
Supplier |
char |
Booked | filters on the platform, writable | ||
Supplier |
char |
Cancel | filters on the platform, writable | ||
Supplier |
varchar2 |
Cost Centre | filters on the platform, writable | ||
Supplier |
char |
Credit | filters on the platform, writable | ||
Supplier |
varchar2 |
Currency | filters on the platform, writable | ||
Supplier |
varchar2 |
Currency Rate | filters on the platform, writable | ||
Supplier |
double |
Currency Unit | filters on the platform, writable | ||
Supplier |
datetime |
Due Date | filters on the platform, writable | ||
Supplier |
varchar2 |
External Invoice Number | filters on the platform, writable | ||
Supplier |
varchar2 |
External Invoice Series | filters on the platform, writable | ||
Supplier |
datetime |
Final Pay Date | filters on the platform, writable | ||
Supplier |
varchar2 |
Given Number | filters on the platform, writable | ||
Supplier |
datetime |
Invoice Date | filters on the platform, writable | ||
Supplier |
varchar2 |
Invoice Number | filters on the platform, writable | ||
Supplier |
varchar2 |
Project | filters on the platform, writable | ||
Supplier |
varchar2 |
Supplier Name | filters on the platform, writable | ||
Supplier |
varchar2 |
Supplier Number | filters on the platform, writable | ||
Supplier |
varchar2 |
Total | filters on the platform, writable | ||
Supplier |
varchar2 |
Call URL | filters on the platform, writable | ||
Supplier |
varchar2 |
Supplier Name | writable | ||
Supplier |
varchar2 |
Supplier Number | writable | ||
Total |
double |
Total | writable | ||
Total_ |
varchar2 |
Total 2 | writable | ||
Transaction |
varchar2 |
Transaction Information | writable | ||
Unit |
varchar2 |
Unit | writable | ||
VAT |
varchar2 |
VAT | writable | ||
VAT |
varchar2 |
VAT Type | writable | ||
Voucher |
int32 |
Voucher Number | writable | ||
Voucher |
varchar2 |
Voucher Series | writable | ||
Voucher |
int32 |
Voucher Year | writable | ||
Your |
varchar2 |
Your Reference | writable | ||
c_url |
varchar2 |
Call URL | writable |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: