| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| code |
The Id/Ref of the back office. Used by Embedded entity |
string |
Max length: 50 |
| _parent_id | globally unique identifier | ||
| _replace_id | globally unique identifier | ||
| article_color_id | globally unique identifier | ||
| article_color_code | string | ||
| article_color_name | string | ||
| barcode |
Barcode of the article (fast search) |
string |
Max length: 50 |
| article_category_id |
Foreign key to article category |
globally unique identifier | |
| article_group_1_id |
Foreign key to article_group_1 |
globally unique identifier | |
| article_group_2_id |
Foreign key to article_group_2 |
globally unique identifier | |
| article_group_3_id |
Foreign key to article_group_3 |
globally unique identifier | |
| article_group_4_id |
Foreign key to article_group_4 |
globally unique identifier | |
| article_group_5_id |
Foreign key to article_group_5 |
globally unique identifier | |
| article_group_6_id |
Foreign key to article_group_6 |
globally unique identifier | |
| name |
Name of the article |
string |
Required Max length: 50 |
| description_short |
Description (if exists, otherwhise name will be used) |
string |
Max length: 100 |
| sys_computed_eco_stock |
value of the last eco stock computed |
integer | |
| entered_price |
Standard article price |
decimal number | |
| min_article_quantity |
For Sales : Minimum amount to be ordered |
integer | |
| article_increment |
For Sales : Increment used to order (by 2, by 4 etc) |
integer | |
| lowest_packing_value | integer | ||
| length | decimal number | ||
| width | decimal number | ||
| height | decimal number | ||
| mass | decimal number | ||
| volume | decimal number | ||
| use_serial |
Use serial |
boolean | |
| archived |
Archives an article (cannot be deleted) |
boolean | |
| no_stock |
For Sales : Disables the stock check |
boolean | |
| is_dummy | boolean | ||
| is_travel_fee | boolean | ||
| is_mileage_fee | boolean | ||
| db_unit_of_measure_id_selling | globally unique identifier | ||
| db_unit_of_measure_id_size |
size article unit |
globally unique identifier | |
| db_unit_of_measure_id_mass |
mass article unit |
globally unique identifier | |
| db_unit_of_measure_id_volume |
volume artice unit |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |