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	`YES`	Hierarchical classification of products. The range of products sold by a retailer is broken down into discrete groups of similar or related products.	`PRODUCT_CATEGORY_LOOKUP`	`product_category_code`	`product_category_desc`
				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	`YES`	Identifies the status of the product as active, discontinued, or in design, etc.	`PRODUCT_STATUS_LOOKUP`	`product_status_code`	`product_status_desc`
				`active`	Active product
				`dxd`	Discontinued product
				`design`	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	`YES`	Shipping method used, such as air, ground, store pickup, etc.	`SHIPPING_TYPE_LOOKUP`	`shipping_type_code`	`shipping_type_desc`
				`air`	Item to be shipped by air
				`ground`	Item to be shipped by ground transport
				`store pickup`	Item to be picked up at the store location
				`express`	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	`NO`	The status of the line item: shipped, returned, cancelled, etc. Aggs have dependency on this field, and it's mandatory.	`TRANSACTION_DETAIL_STATUS_LOOKUP`	`transaction_detail_status_code`	`transaction_detail_status_desc`
				`sale`	Items sold at the retail (B&M) stores AND items that were purchased through eComm channel that have been SHIPPED to the customer (fulfilled)
				`demand`	Items that were ordered on any WebStore
				`returned`	Items that were returned in either B&M store or online
				`cancel`	Items that were ordered on any WebStore that were cancelled before they were shipped
				`price_adj`	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	`YES`	Identifies the type of transaction on a high level, for example employee sale vs non-employee, non-sale transaction (subscription), etc.	`TRANSACTION_TYPE_LOOKUP`	`transaction_type_code`	`transaction_type_desc`
				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	`YES`	List of payment types used in transactions. For example: credit card, gift card, cash, check, etc.	`TRANSACTION_PAYMENT_TYPE_LOOKUP`	`payment_type_code`	`payment_type_desc`
				`AMEX`	American Express card
				`TRAVELERS_CHECK`	Traveler's check
				`CHECK`	Personal check
				`VISA`	Visa
				`CASH`	cash payment
				`GIFT_CARD`	Gift card
				`MASTERCARD`	Mastercard
				`CREDIT`	Credit card
				`DEBIT`	Debit card
				`DISCOVER`	Discover