This table holds information about transactions involving promotions.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| bigint | No | Identifier; primary key. | |
| smallint | No | Identifier of the promotion involved. Foreign key to | |
| timestamp | Yes | The date and time a promotion transaction occurred. | |
| varchar | 40 | No | Day on which the transaction occurred; foreign key to |
| integer | No | Time at which the transaction occurred; foreign key to | |
| integer | No | SKU to which the promotion was applied; foreign key to | |
| integer | No | Product to which the promotion was applied; foreign key to | |
| integer | No | Category of the item to which the promotion was applied; foreign key to | |
| integer | No | Customer for whom the promotion was used; foreign key to | |
| integer | No | Segment cluster to which the customer belongs; foreign key to | |
| smallint | No | Billing region for the transaction; foreign key to | |
| smallint | No | Local currency in which the transaction occurred; foreign key to | |
| smallint | No | Demographic to which the customer belongs; foreign key to | |
| bigint | No | ID of site visit in which the promotion use occurred. | |
| integer | No | ID of the order to which the promotion was applied. | |
| varchar | 40 | No | Natural identifier for the order to which the promotion was applied. |
| varchar | 128 | Yes | ID of the session in which the promotion was used. |
| varchar | 40 | Yes | Agent involved in the transaction, if any; foreign key to |
| numeric | 3 | Yes | Identifier for sales channel that originated the order. Foreign key to |
| numeric | 3 | Yes | Identifier for sales channel that completed the order. Foreign key to |
| integer | No | Quantity of items to which the promotion applies. | |
| numeric | 19 | No | Net revenue for the item to which the promotion was applied, in the local currency. If the promotion is one that applies to an entire order, this value is the same as the |
| numeric | 19 | No | Net revenue for the entire order after applying the promotion, in the local currency. |
| numeric | 19 | No | Effective amount of the discount applied as a result of the promotion, in the local currency. |
| numeric | 19 | No | Net revenue for the item to which the promotion was applied, in the standard currency. If the promotion is one that applies to an entire order, this value is the same as the |
| numeric | 19 | No | Net revenue for the entire order after applying the promotion, in the standard currency. |
| numeric | 19 | No | Effective amount of the discount applied as a result of the promotion, in the standard currency. |
| smallint | No | The site at which the transaction occurred. Foreign key to | |
| bigint | No | A unique identifier for this use of a coupon. Set to 0 if no coupon is associated with the promotion usage. | |
| int | No | The identifier of the coupon record. This is a foreign key to the ARF_COUPON table. | |
| varchar | 254 | Yes | The |
| int | Yes | The organization associated with the promotion. |