| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| article_category_id |
Foreign key to article category |
globally unique identifier | |
| article_category |
Embedded entity "article_category" when adding/updating article |
article_category | |
| article_category_code |
Embedded entity "article_category" using ERP PK when adding/updating article |
string | |
| article_group_1_id |
Foreign key to article_group_1 |
globally unique identifier | |
| article_group_1_code |
Embedded entity "article_group_1" using ERP PK when adding/updating article |
string | |
| article_group_1 |
Embedded entity "article_group_1" using ERP PK when adding/updating article |
article_group_1 | |
| article_group_2_id |
Foreign key to article_group_2 |
globally unique identifier | |
| article_group_2_code |
Embedded entity "article_group_2" using ERP PK when adding/updating article |
string | |
| article_group_2 |
Embedded entity "article_group_2" using ERP PK when adding/updating article |
article_group_2 | |
| article_group_3_id |
Foreign key to article_group_3 |
globally unique identifier | |
| article_group_3_code |
Embedded entity "article_group_3" using ERP PK when adding/updating article |
string | |
| article_group_3 |
Embedded entity "article_group_3" using ERP PK when adding/updating article |
article_group_3 | |
| article_group_4_id |
Foreign key to article_group_4 |
globally unique identifier | |
| article_group_4_code |
Embedded entity "article_group_4" using ERP PK when adding/updating article |
string | |
| article_group_4 |
Embedded entity "article_group_4" using ERP PK when adding/updating article |
article_group_4 | |
| article_group_5_id |
Foreign key to article_group_5 |
globally unique identifier | |
| article_group_5_code |
Embedded entity "article_group_5" using ERP PK when adding/updating article |
string | |
| article_group_5 |
Embedded entity "article_group_5" using ERP PK when adding/updating article |
article_group_5 | |
| article_group_6_id |
Foreign key to article_group_6 |
globally unique identifier | |
| article_group_6_code |
Embedded entity "article_group_6" using ERP PK when adding/updating article |
string | |
| article_group_6 |
Embedded entity "article_group_6" using ERP PK when adding/updating article |
article_group_6 | |
| physical_stock |
Physical stock from the ERP (used for Eco Stock) |
integer | |
| back_order_client |
Number of pieces reserved for clients (used for Eco Stock) |
integer | |
| back_order_supplier |
Number of pieces that should arrive from the supplier (used for Eco stock if expected delivery is in the past) |
integer | |
| expected_delivery_date_bo_supplier |
Date when the delivery from the supplier should arrive (used for Eco stock) |
date | |
| article_increment |
For Sales : Increment used to order (by 2, by 4 etc) |
integer | |
| min_article_quantity |
For Sales : Minimum amount to be ordered |
integer | |
| entered_price |
Standard article price |
decimal number | |
| cost_price | decimal number | ||
| no_stock |
For Sales : Disables the stock check |
boolean | |
| archived |
Archives an article (cannot be deleted) |
boolean | |
| is_travel_fee |
Indicate that this article will be used to compute the fee based on the car travel time |
boolean | |
| is_mileage_fee |
Indicate that this article will be used to compute the fee based on the distance. |
boolean | |
| code |
The Id/Ref of the back office. Used by Embedded entity |
string |
Max length: 50 |
| name |
Name of the article |
string |
Required Max length: 50 |
| description_short |
Description (if exists, otherwhise name will be used) |
string |
Max length: 100 |
| description_long |
Long description |
string | |
| barcode |
Barcode of the article (fast search) |
string |
Max length: 50 |
| notes |
Notes (remark, details) |
string |
Max length: 255 |
| date_create |
Creation date, auto filled by Now if no value received |
date | |
| date_update |
Update date, auto filled by Now if no value received |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| article_color_id |
Foreign key to article_color |
globally unique identifier | |
| article_color_code |
Embedded entity "article_color" using ERP PK when adding/updating article |
string | |
| article_color |
Embedded entity "article_color" when adding/updating article |
article_color | |
| warranty_period_nb_months |
warranty_period_nb_months |
integer | |
| use_serial |
use_serial |
boolean | |
| _replace_id |
Foreign key to article that replace the current article |
globally unique identifier | |
| replace_article |
Embedded entity "article" of replace, when adding/updating article |
article | |
| replace_article_code |
Embedded code "article" of replace, when adding/updating article |
string | |
| db_unit_of_measure_id_selling |
Applicable db_unit_of_measure |
globally unique identifier | |
| db_unit_of_measure_code_selling |
Applicable db_unit_of_measure |
string | |
| translations |
List of translation of specific field name |
Collection of translation |