Item

the retailers sku or unique item identifier for items sold or returned. this field is required by sim.

Indicates the type of item. Possible values are:0 - Item,15 - Simple Pack,20 - Complex Pack,25 - Simple Breakable Pack,30 - Complex Breakable Pack

hierarchy department id Oracle Retail target column DEPARTMENT_ID on ITEM.

hierarchy class id Oracle Retail target column CLASS_ID on ITEM.

hierarchy subclass id Oracle Retail target column SUBCLASS_ID on ITEM.

the textural description of the item and its characteristics.

long description of the item. Oracle Retail target column LONG_DESCRIPTION on ITEM.

the unique identifier that differentiates the current item from its item parent. for an item that is a parent, this field may be either a group (i.e. mens pant sizes) or a value (6 oz). for an item that is not a parent, this field may contain a value (34x34, red, etc.) valid values are found on diff_id table.

this field can be used the same way as diff_1.

this field can be used the same way as diff_1.

this field can be used the same way as diff_1.

the current status of the item. A - Active, C - Discountinued, I - Inactive,D - Deleted,Q - AutoStockable,N - Non-ranged

indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only).

the unique identifier of the item/group at the level above the item.

number indicating which of the three levels transactions occur for the items group. the transaction level is the level at which the items inventory is tracked in the system. the transaction level item will be counted, transferred, shipped, etc. the transaction level may be at the current item or up to 2 levels above or below the current item. only one level of the hierarchy of an item family may contain transaction level items. this field is required by sim.

number indicating which of the three levels the item resides. the item level determines if the item stands alone or if it is part of a family of related items. the item level also determines how the item may be used throughout the system. the item where the item_level is the same as the trans_level is the item id where sim assumes inventory information is recorded for in the STORE_ITEM_STOCK table. this field is required by sim.

indicates if this item may be sold as a unit. valid values are: Y and N. this field is required by sim when using pack items.

indicates if this item may be order from a supplier. valid values are: Y and N. this field is required by sim.

holds the unit of measure associated with the package size.

holds the size of the product printed on a label.

unit of measure which the stock for this item is tracked at the coporate level.

default number of items that are contained in a case when shipped from or to the store.

barcode format Oracle Retail target column BARCODE_FORMAT on ITEM.

barcode prefix Oracle Retail target column BARCODE_PREFIX on ITEM.

suggested ticket type code for this item. value is obtained from rms.

The multiplication factor to convert 1 EA to the equivalent standard unit of measure.

This column hods the waste type associated with a given item.SL - Sales wastage.SP - Spoilage wastage

This column hods the waste percentage associated with a given item.

This column hods the default waste percentage associated with a given item.

soh inquiry at pack indicator Oracle Retail target column ESTIMATE_SOH_FOR_PACK on ITEM.

the unique identifier of the retail pricing strategy associated with this item.

indicates if the sub-transaction level item is designated as the primary sub-transaction level item. for transaction level items and above the value in this field will be n. valid values are: y and n. this field is required by sim.

Brand name associated with the item

Manufacturer suggested retail price

Y indicates inventoriable, N indicates not inventoriable

indicates if the item should be shipped to the customer is a seperate package versus being grouped together in a box. valid values are: Y and N.

Description of the brand associated to an item.

Manufacturer suggested retail currency.

Oracle Retail target column CREATE_DATE on ITEM.

Oracle Retail target column UPDATE_DATE on ITEM.

The current thumbnail image URL for the item.