InvoiceLines: Fortnox Fortnox Invoice Lines
read only
- Catalog:
Fortnox - Schema:
Views - Label: Fortnox 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 InvoiceLines 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 Number | writable | ||
Accounting |
varchar2 |
Accounting Method | writable | ||
Address1 |
varchar2 |
Address Line 1 | writable | ||
Address2 |
varchar2 |
Address Line 2 | writable | ||
Administration |
double |
Administration Fee | writable | ||
Administration |
double |
Administration Fee VAT | writable | ||
Article |
varchar2 |
Article Number | writable | ||
Balance |
double |
Balance | writable | ||
Basis |
double |
Basis Tax Reduction | writable | ||
Booked |
char |
Booked | writable | ||
Cancelled |
char |
Cancelled | writable | ||
City |
varchar2 |
City | writable | ||
Comments |
varchar2 |
Comments | writable | ||
Contract |
int32 |
Contract Reference | writable | ||
Contribution |
varchar2 |
Contribution Percent | writable | ||
Contribution |
double |
Contribution Percent 2 | writable | ||
Contribution |
varchar2 |
Contribution Value | writable | ||
Contribution |
double |
Contribution Value 2 | writable | ||
Cost |
varchar2 |
Cost Centre | writable | ||
Cost |
varchar2 |
Cost Centre 2 | writable | ||
Country |
varchar2 |
Country | writable | ||
Credit |
varchar2 |
Credit | writable | ||
Credit |
varchar2 |
Credit Invoice Reference | writable | ||
Currency |
varchar2 |
Currency | writable | ||
Currency |
double |
Currency Rate | writable | ||
Currency |
int32 |
Currency Unit | writable | ||
Customer |
varchar2 |
Customer Name | writable | ||
Customer |
varchar2 |
Customer Number | writable | ||
Delivered |
varchar2 |
Delivered Quantity | writable | ||
Delivery |
varchar2 |
Delivery Address 1 | writable | ||
Delivery |
varchar2 |
Delivery Address 2 | writable | ||
Delivery |
varchar2 |
Delivery City | writable | ||
Delivery |
varchar2 |
Delivery Country | writable | ||
Delivery |
datetime |
Delivery Date | writable | ||
Delivery |
varchar2 |
Delivery Name | writable | ||
Delivery |
varchar2 |
Delivery Zip Code | writable | ||
Description |
varchar2 |
Description | writable | ||
Discount |
double |
Discount | writable | ||
Discount |
varchar2 |
Discount Type | writable | ||
Document |
varchar2 |
Document Number | writable | ||
Due |
datetime |
Due Date | writable | ||
EDI |
varchar2 |
EDI Information EDI Global Location Number | writable | ||
EDI |
varchar2 |
EDI Information EDI Global Location Number Delivery | writable | ||
EDI |
varchar2 |
EDI Information EDI Invoice Extra 1 | writable | ||
EDI |
varchar2 |
EDI Information EDI Invoice Extra 2 | writable | ||
EDI |
varchar2 |
EDI Information EDI Our Electronic Reference | writable | ||
EDI |
varchar2 |
EDI Information EDI Status | writable | ||
EDI |
varchar2 |
EDI Information EDI Your Electronic Reference | writable | ||
EU |
char |
EU Quarterly Report | writable | ||
Email |
varchar2 |
Email Information Email Address Bcc | writable | ||
Email |
varchar2 |
Email Information Email Address CC | writable | ||
Email |
varchar2 |
Email Information Email Address From | writable | ||
Email |
varchar2 |
Email Information Email Address To | writable | ||
Email |
varchar2 |
Email Information Email Body | writable | ||
Email |
varchar2 |
Email Information Email Subject | writable | ||
External |
varchar2 |
External Invoice Reference 1 | writable | ||
External |
varchar2 |
External Invoice Reference 2 | writable | ||
Final |
datetime |
Final Pay Date | writable | ||
Freight |
double |
Freight | writable | ||
Freight |
double |
Freight VAT | writable | ||
Gross |
double |
Gross | writable | ||
House |
char |
House Work | writable | ||
House |
int32 |
House Work Hours to Report | writable | ||
House |
varchar2 |
House Worktype | writable | ||
House |
char |
House Work 2 | writable | ||
Invoice |
double |
Balance | filters on the platform, writable | ||
Invoice |
char |
Booked | filters on the platform, writable | ||
Invoice |
char |
Cancelled | filters on the platform, writable | ||
Invoice |
varchar2 |
Cost Centre | filters on the platform, writable | ||
Invoice |
varchar2 |
Currency | filters on the platform, writable | ||
Invoice |
double |
Currency Rate | filters on the platform, writable | ||
Invoice |
double |
Currency Unit | filters on the platform, writable | ||
Invoice |
varchar2 |
Customer Name | filters on the platform, writable | ||
Invoice |
varchar2 |
Customer Number | filters on the platform, writable | ||
Invoice |
datetime |
Invoice Date | writable | ||
Invoice |
varchar2 |
Document Number | filters on the platform, writable | ||
Invoice |
datetime |
Due Date | filters on the platform, writable | ||
Invoice |
varchar2 |
External Invoice Reference 1 | filters on the platform, writable | ||
Invoice |
varchar2 |
External Invoice Reference 2 | filters on the platform, writable | ||
Invoice |
datetime |
Final Pay Date | filters on the platform, writable | ||
Invoice |
datetime |
Invoice Date | filters on the platform, writable | ||
Invoice |
varchar2 |
Invoice Type | filters on the platform, writable | ||
Invoice |
char |
Nox Finans | filters on the platform, writable | ||
Invoice |
varchar2 |
Ocr | filters on the platform, writable | ||
Invoice |
datetime |
Invoice Period End | writable | ||
Invoice |
varchar2 |
Invoice Period Reference | writable | ||
Invoice |
datetime |
Invoice Period Start | writable | ||
Invoice |
varchar2 |
Project | filters on the platform, writable | ||
Invoice |
char |
Sent | filters on the platform, writable | ||
Invoice |
varchar2 |
Terms of Payment | filters on the platform, writable | ||
Invoice |
double |
Total | filters on the platform, writable | ||
Invoice |
varchar2 |
Invoice Type | writable | ||
Invoice |
int32 |
Voucher Number | filters on the platform, writable | ||
Invoice |
varchar2 |
Voucher Series | filters on the platform, writable | ||
Invoice |
int32 |
Voucher Year | filters on the platform, writable | ||
Invoice |
varchar2 |
Way of Delivery | filters on the platform, writable | ||
Invoicec_ |
varchar2 |
Call URL | filters on the platform, writable | ||
Language |
varchar2 |
Language | writable | ||
Last |
datetime |
Last Remind Date | writable | ||
Net |
double |
Net | writable | ||
Not |
char |
Notcompleted | writable | ||
Nox |
char |
Nox Finans | writable | ||
OCR |
varchar2 |
Ocr | writable | ||
Offer |
varchar2 |
Offer Reference | writable | ||
Order |
varchar2 |
Order Reference | writable | ||
Organisation |
varchar2 |
Organisation Number | writable | ||
Our |
varchar2 |
Ourreference | writable | ||
Outbound |
datetime |
Outbound Date | writable | ||
Payment |
varchar2 |
Payment Way | writable | ||
Phone1 |
varchar2 |
Phone 1 | writable | ||
Phone2 |
varchar2 |
Phone 2 | writable | ||
Price |
double |
Price | writable | ||
Price |
double |
Price excluding VAT | writable | ||
Price |
varchar2 |
Price List | writable | ||
Print |
varchar2 |
Print Template | writable | ||
Project |
varchar2 |
Project | writable | ||
Project_ |
varchar2 |
Project 2 | writable | ||
Remarks |
varchar2 |
Remarks | writable | ||
Reminders |
int32 |
Reminders | writable | ||
Round |
double |
Round Off | writable | ||
RowId |
int32 |
Row ID | writable | ||
Sent |
char |
Sent | writable | ||
Stock |
varchar2 |
Stock Point Code | writable | ||
Tax |
int32 |
Tax Reduction | writable | ||
Tax |
varchar2 |
Tax Reduction Type | writable | ||
Terms |
varchar2 |
Terms of Delivery | writable | ||
Terms |
varchar2 |
Terms of Payment | writable | ||
Time |
int32 |
Time Basis Reference | writable | ||
Total |
double |
Total | writable | ||
Total |
double |
Total Excluding VAT | writable | ||
Total |
double |
Total to Pay | writable | ||
Total |
double |
Total VAT | writable | ||
Total_ |
double |
Total 2 | writable | ||
Unit |
varchar2 |
Unit | writable | ||
VAT |
int32 |
VAT | writable | ||
VAT |
varchar2 |
VAT Code | writable | ||
VAT |
char |
Vatincluded | writable | ||
Voucher |
int32 |
Voucher Number | writable | ||
Voucher |
varchar2 |
Voucher Series | writable | ||
Voucher |
int32 |
Voucher Year | writable | ||
Warehouse |
char |
Warehouse Ready | writable | ||
Way |
varchar2 |
Way of Delivery | writable | ||
Your |
varchar2 |
Your Order Number | writable | ||
Your |
varchar2 |
Your Reference | writable | ||
Zip |
varchar2 |
ZIP Code | writable | ||
c_url |
varchar2 |
Call URL | writable | ||
c_ |
varchar2 |
URL Tax Reduction List | writable |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: