NameDescriptionTypeAdditional 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