| Name | Description | Type | Additional information | 
|---|---|---|---|
| id | 
                         Primary Key  | 
                    globally unique identifier | |
| code | 
                         The Id/Ref of the back office. Used by Embedded entity  | 
                    string | 
                                 Max length: 50  | 
                
| name | 
                         Name of the equipment model  | 
                    string | 
                                 Required Max length: 50  | 
                
| description | 
                         Description of the equipment model  | 
                    string | |
| equipment_brand_id | 
                         FK Of Equipment brand  | 
                    globally unique identifier | |
| equipment_brand_code | 
                         Embedded entity "equipment_brand" using ERP PK when adding/updating equipment_model  | 
                    string | |
| equipment_brand | 
                         Embedded entity "equipment_brand" using ERP PK when adding/updating equipment_model  | 
                    equipment_brand | |
| equipment_family_id | 
                         FK Of equipment_family  | 
                    globally unique identifier | |
| equipment_family_code | 
                         Embedded entity "equipment_family" using ERP PK when adding/updating equipment_model  | 
                    string | |
| equipment_family | 
                         Embedded entity "equipment_family" using ERP PK when adding/updating equipment_model  | 
                    equipment_family | |
| date_in_production_since | 
                         Date in production since  | 
                    date | |
| date_out_of_production_since | 
                         Date Out Of production since  | 
                    date | |
| date_end_support | 
                         Date end support  | 
                    date | |
| sales_organization_id | 
                         FK of sales_organization. Filled if specific of one SO, empty if can be used by all  | 
                    globally unique identifier | |
| sales_organization_code | 
                         Embedded entity "sales_organization" using ERP PK when adding/updating equipment_model  | 
                    string | |
| sales_organization | 
                         Embedded entity "sales_organization" when adding/updating equipment_model  | 
                    sales_organization | |
| replacement_period_nb_months | 
                         replacement_period_nb_months  | 
                    integer | |
| warranty_period_nb_months | 
                         warranty_period_nb_months  | 
                    integer | |
| translations | 
                         List of translation of specific field name  | 
                    Collection of translation | |
| modified_dateutc | 
                         Readonly system field managed by database, filled with GetUtcDate when adding,updating  | 
                    date |