NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier
purchase_order_id

Foreign key of the purchase_order

 globally unique identifier

Optionally required : purchase_order_id, purchase_order_reference or purchase_order must be provided
purchase_order_reference_back_office

Embedded entity "purchase_order" using ERP PK when adding/updating

 string

Optionally required : purchase_order_id, purchase_order_reference_back_office or purchase_order must be provided
purchase_order

Embedded entity "purchase_order" when adding/updating

 purchase_order

Optionally required : purchase_order_id, purchase_order_reference_back_office or purchase_order must be provided
article_id

Foreign key of article

 globally unique identifier

Optionally required : article_id, article_code or article must be provided
article_code

Embedded entity "article" using ERP PK when adding/updating

 string

Optionally required : article_id, article_code or article must be provided
article

Embedded entity "article" when adding/updating

 article

Optionally required : article_id, article_code or article must be provided
line_number

Line Number, auto filled with (Highest+1) if value is 0/null

 integer
code

Code of the article (auto filled if empty)

 string

Max length: 255
supplier_code

Code of the supplier for this article

 string

Max length: 255
name

Article Name (will be auto filled if article.name+description are empty)

 string

Max length: 255
description

Article description (will be auto filled by article.short_description if name+description are empty)

 string

Max length: 255
price

Unit Price

 decimal number

Matching regular expression pattern: ^[0-9]\d*(\.\d+)?$

Range: inclusive between 0.1 and 1.79769313486232E+308
quantity

Quantity

 decimal number

Required

Range: inclusive between 0.1 and 1.79769313486232E+308
memo

Line memo/remark

 string
cost_price

Unit Cost Price (statistic purpose)

 decimal number

Matching regular expression pattern: ^[0-9]\d*(\.\d+)?$
reference_back_office

Field used for Embedded entity (store there your ERP PK)

 string

Max length: 50
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date