Dc Fashion Xref

Unique alphanumeric value that identifies the item.

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

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.

Holds any comments associated with the item.

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.

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.

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

A grocery item attribute used to indicate whether an item is perishable or not.

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.