Lookup tables: retail
This is the set of lookup tables associated to the retail data domain.
Product category
The product category is used to indicate the category that a product belongs to in the product hierarchy feed layout. This is used to build out the product category summary table, which summarizes data related to an individual business unit ID and the product categories they have purchased from.
Used in Agg Calc | Custom Values Allowed | Reference Information Description | Target DB object | Reference Information Data Element 1 | Reference Information Data Element 2 |
---|---|---|---|---|---|
Used in Agg Calcs |
| Hierarchical classification of products. The range of products sold by a retailer is broken down into discrete groups of similar or related products. |
|
|
|
custom value |
| ||||
custom value |
| ||||
custom value |
| ||||
custom value |
| ||||
custom value |
|
Product status
Identifies the status of a given product in the product hierarchy feed layout.
Used in Agg Calc | Custom Values Allowed | Reference Information Description | Target DB object | Reference Information Data Element 1 | Reference Information Data Element 2 |
---|---|---|---|---|---|
NO |
| Identifies the status of the product as active, discontinued, or in design, etc. |
|
|
|
| Active product | ||||
| Discontinued product | ||||
| Product in design phase | ||||
custom value |
| ||||
custom value |
| ||||
custom value |
|
Shipping type
Shipping type identifies the type of shipping that was used for a given transaction in the transaction feed layout.
Used in Agg Calc | Custom Values Allowed | Reference Information Description | Target DB object | Reference Information Data Element 1 | Reference Information Data Element 2 |
---|---|---|---|---|---|
NO |
| Shipping method used, such as air, ground, store pickup, etc. |
|
|
|
| Item to be shipped by air | ||||
| Item to be shipped by ground transport | ||||
| Item to be picked up at the store location | ||||
| Express shipping | ||||
custom value |
| ||||
custom value |
| ||||
custom value |
|
Transaction detail status
Transaction detail status identifies the status of a given transaction in the transaction feed layout. The same transaction ID can be provided for each of the different transaction detail statuses that a customer captures for transactions, provided that the different transactions and statuses each have different transaction dates/times.
Used in Agg Calc | Custom Values Allowed | Reference Information Description | Target DB object | Reference Information Data Element 1 | Reference Information Data Element 2 |
---|---|---|---|---|---|
Used in Agg Calcs |
| The status of the line item: shipped, returned, cancelled, etc. Aggs have dependency on this field, and it's mandatory. |
|
|
|
| Items sold at the retail (B&M) stores AND items that were purchased through eComm channel that have been SHIPPED to the customer (fulfilled) | ||||
| Items that were ordered on any WebStore | ||||
| Items that were returned in either B&M store or online | ||||
| Items that were ordered on any WebStore that were cancelled before they were shipped | ||||
| Price adjustment transactions for the item |
Transaction type
Transaction type is a lookup that allows you to designate different types of transactions.
Used in Agg Calc | Custom Values Allowed | Reference Information Description | Target DB object | Reference Information Data Element 1 | Reference Information Data Element 2 |
---|---|---|---|---|---|
NO |
| Identifies the type of transaction on a high level, for example employee sale vs non-employee, non-sale transaction (subscription), etc. |
|
|
|
custom value |
| ||||
custom value |
| ||||
custom value |
|
Transaction payment type
Transaction payment type allows you to make a list of the accepted transaction payment types that can be associated to a transaction. This is used in the tender feed layout.
Used in Agg Calc | Custom Values Allowed | Reference Information Description | Target DB object | Reference Information Data Element 1 | Reference Information Data Element 2 |
---|---|---|---|---|---|
NO |
| List of payment types used in transactions. For example: credit card, gift card, cash, check, etc.
|
|
|
|
| American Express card | ||||
| Traveler's check | ||||
| Personal check | ||||
| Visa | ||||
| cash payment | ||||
| Gift card | ||||
| Mastercard | ||||
| Credit card | ||||
| Debit card | ||||
| Discover |