| Name | Description | Type | Additional information | 
|---|---|---|---|
| id | 
                         Primary Key  | 
                    globally unique identifier | |
| code | string | 
                                 Max length: 50  | 
                |
| segment | 
                         Marketing segment Name  | 
                    string | 
                                 Required Max length: 50  | 
                
| description | 
                         Description of the segment  | 
                    string | 
                                 Max length: 255  | 
                
| visit_frequency_days_interval | 
                         Number of days between 2 visits  | 
                    integer | |
| frequency_logic | 
                         Logic to apply for the frequency, which last events (value can be ORDER,MEETING_COMPLETED or ORDER_OR_MEETING_COMPLETED )  | 
                    string | |
| 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 company_type  | 
                    string | |
| sales_organization | 
                         Embedded entity "sales_organization" when adding/updating company_type  | 
                    sales_organization | |
| modified_dateutc | 
                         Readonly system field managed by database, filled with GetUtcDate when adding,updating  | 
                    date |