Dc Grocery Variant

Unique alphanumeric value that identifies the item.

Code specifying what type the item is. Valid values for this field are in the code type UPCT on the code_head and code_detail tables.

This field will hold the format ID that corresponds to the items variable UPC.

This column holds the prefix for variable weight UPCs.

Long description of the item. Oracle Retail target column ITEM_DESC on DC_GROCERY_VARIANT.

Shortened description of the item.

Secondary descriptions of the item.

Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.

Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as both an item and an item parent inanother row on the item_master table.

Indicates if the sub-transation level item is designated as the primary sub-transaction level item. For transaction level items and above the value in this field will be No.

Only used if AIP is integrated. Determines which case sizes to extract against an item in the AIP interface.

Holds any comments associated with the item.

Product classification is informational only in RMS, but is used by RWMS to determine how to pack customer orders : such as to determine products that may not be able to be packaged together.

This field contains the brand associated to an item.