The ARF_LINE_ITEM_MV_PRODUCT
view provides aggregated data about line items associated with customer purchases. The calculated values are based on information in the ARF_LINE_ITEM
table. The values in each row are constrained to a particular day, site, sales channel, segment cluster, internal agent, and product.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| numeric | Yes | The number of line items in customer purchases that correspond to the day, site, sales channel, segment cluster, internal agent, and product. 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 | |
| tinyint | Yes | A reference to a value in the | |
| integer | No | A reference to a value in the | |
| varchar | 40 | Yes | A reference to a value in the |
| integer | No | A reference to a value in the | |
| numeric | Yes | The number of product items for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total price of the product items for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total revenue after adjustments due to discounts, taxes, and shipping for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total revenue before adjustments due to discounts, taxes, and shipping for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total discounts applied for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total markdown discounts applied for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total order shipping costs for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total of order tax amounts for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total of order-level discounts applied for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total of appeasement credits applied by internal agents for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total of appeasement debits applied by internal agents for the day, site, sales channel, segment cluster, internal agent, and product. This value sums | |
| numeric | Yes | The total value of price overrides applied by internal agents for the day, site, sales channel, segment cluster, internal agent, and product. This value sums |