This table stores additional information about a click through/stream event. The standard information is recorded in the clicktracking_ table, with the additional information provided in this table. Generally only one of these fields is present for each clickstream event, as supported by that technology.
Primary key: ClickID_
Field Name | Description | Version Added |
ClickID_ | The ClickID_ value from the clicktracking_ table. (int, NOT NULL) |
|
UnitPrice_ | The price recorded for this purchase. (numeric (2,), NULL) |
|
Quantity_ | The number of items purchased. (int, NULL) |
|
Points_ | The points that this item represents. (int, NULL) |
|
Stage_ | The stage that this item represents. (int, NULL) |
|
ProductSku_ | The product SKU for this purchase. (varchar(25), NULL) |
|
OrderID_ | The Order ID of this purchase. (varchar(25), NULL) |
|
CustomerID_ | The customer ID, from the customer's accounting system, for this transaction. (varchar(25), NULL) |
|