Fact table containing data on the use of promotional materials in CRM tasks (visits). Used for analyzing material distribution by representatives and monitoring stock levels.
| Field Name | Description |
|---|---|
| storage_fact_date_spisania | Actual write-off date |
| storage_key | Unique identifier of the record for receipt of promotional material in the warehouse (key from info_storageinvoicematerial). Linked to the table crm_storage_material |
| storage_key_task_id | Task (visit) identifier within which the promotional material was used. Linked to the table crm_task_fact |
| storage_promomaterial_id | Identifier of the used promotional material. Linked to the table crm_storage_materialsk |
| storage_rozdacha | Quantity of promotional material written off (used) during task execution (visit) |