| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| invoice_id |
Key of invoice to which this line belongs |
globally unique identifier | |
| article_id |
Key of article on this line |
globally unique identifier | |
| article_name |
Name of article on this line |
string | |
| article_description |
Description of article on this line |
string | |
| article_code |
Code of article on this line |
string | |
| line_num |
Number of this line within the invoice |
integer | |
| quantity |
Quantity of article |
integer | |
| article_price |
Price of article |
decimal number | |
| discount |
Discount value (absolute) applied to this line |
decimal number | |
| vat_rate |
VAT ratio applied to this line |
decimal number | |
| vat_value |
Value (absolute) of VAT on this line |
decimal number | |
| total_line |
quantity*(article_price-discount+vat_value) |
decimal number | |
| article_stock_location_id |
In case of stock management enabled, the stock that has been used |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |