The table consolidates links by client category.
| Field Name | Short Description |
|---|---|
| category_name | Text name of the client category (for example: “A”, “A1”, “B”). |
| key_category_id | Identifier of the client category (for example: A, B, C categories, segments). Stored as a numeric ID. |
| key_client_id | Client identifier. For companies, it is stored as company_id * (-1) (negative value); for contacts — as contact_id. Used for unique client identification in reports. |
| key_client_categ | A technical key formed by concatenating key_client_id || '' || key_owner_id || '' || key_direction_id. Used for unique record identification in Power BI. |
| key_owner_id | CRM user identifier who owns the company or contact. |
| key_direction_id | Identifier of the business direction. Indicates which business line the client belongs to. |