The ARF_PROMOTION_USAGE_MV
view provides aggregated data about purchases that involve promotions. The calculated values are based on information in the ARF_PROMOTION_USAGE
table. The values in each row are constrained to a particular day, site, and promotion.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| numeric | Yes | The number of purchases that involve the promotion and that correspond to the day and site. This value counts rows in the | |
| varchar | 40 | No | A reference to a value in the |
| timestamp | No | A reference to a value in the | |
| smallint | No | A reference to a value in the | |
| smallint | No | A reference to a value in the | |
| numeric | Yes | The number of purchased items for the day, site, and promotion. This value sums | |
| numeric | Yes | The total amount of discounts applied as a result of the promotion for the day and site. This value sums | |
| numeric | Yes | The total value of purchases that involve the promotion, minus the discounts applied as a result of the promotion for the day and site. This value sums | |
| numeric | Yes | The total value of the items that involve the promotion, minus the discounts applied as a result of the promotion for the day and site. This value sums |