Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For ItemHdrDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item. |
item_master |
item |
varchar2 |
25 |
Yes |
Unique alphanumeric value that identifies the item. |
item_number_type |
varchar26 |
1 |
1 |
This type can hold a number of digits count umber_type. |
item_master |
item_number_type |
varchar2 |
6 |
Yes |
Code specifying item type. Valid values are in the code type UPCT in the code_head and code_detail tables. |
format_id |
varchar21 |
0 |
1 |
This field will hold the format ID that corresponds to the item's variable UPC. This value is only used for items with variable UPCs. |
item_master |
format_id |
varchar2 |
1 |
No |
This field contains the format ID that corresponds to the item's variable UPC. This value is used only for items with variable UPCs. |
prefix |
number2 |
0 |
1 |
This column holds the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and will be used to decode variable weight UPCs that are uploaded from the POS. It is the clients responsibility to download this value to their |
item_master |
prefix |
number |
2 |
No |
This column contains the prefix for variable weight UPCs. The prefix determines the format of the eventual UPC and is used to decode variable weight UPCs that are uploaded from the POS. It is the retailer's responsibility to download this value. |
item_parent |
varchar225 |
0 |
1 |
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. |
item_master |
item_parent |
varchar2 |
25 |
No |
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. |
item_grandparent |
varchar225 |
0 |
1 |
Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table. |
item_master |
item_grandparent |
varchar2 |
25 |
No |
Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as an item and an item parent in another row on the item_master table. |
pack_ind |
varchar21 |
0 |
1 |
Indicates if the item is a pack. A pack item is a collection of items that may be either ordered or sold as a unit. Packs require details (i.e. component items and qtys, etc.) that other items do not. This field is required by the database. |
item_master |
pack_ind |
varchar2 |
1 |
Yes |
Indicates whether the item is a pack. A pack item is a collection of items that may be ordered or sold as a unit. Packs require details (such as. component items and quantities) that other items do not. This field is required by the database. |
item_level |
number1 |
0 |
1 |
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. |
item_master |
item_level |
number |
1 |
Yes |
Number indicating on which of the three levels the item resides. The item level determines if the item stands alone or is part of a family of related items. The item level also determines how the item may be used throughout the system. |
tran_level |
number1 |
0 |
1 |
Number indicating which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's 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. |
item_master |
tran_level |
null |
null |
Yes |
Number indicating at which of the three levels transactions occur for the item's group. The transaction level is the level at which the item's inventory is tracked in the system. The transaction level item is counted, transferred, and shipped. The transaction level may be at the current item or up to two levels above or below the current item. Only one level of the hierarchy of an item family can contain transaction level items. |
diff_1 |
varchar210 |
0 |
1 |
Diff_group or diff_id 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. Men's 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 the diff_group and diff_id tables. |
item_master |
diff_1 |
null |
null |
No |
Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (such as men's pant sizes) or a value (such as 6 ounces). For an item that is not a parent, this field may contain a value (such as 34X34 or red). Valid values are found on the diff_group and diff_id tables. |
diff_1_type |
varchar26 |
0 |
1 |
This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. |
diff_ids |
diff_type |
null |
null |
No |
This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. |
diff_2 |
varchar210 |
0 |
1 |
Diff_group or diff_id 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 the diff_group and diff_id tables. |
item_master |
diff_2 |
null |
null |
No |
Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (such as men's pant sizes) or a value (such as 6 ounces). For an item that is not a parent, this field may contain a value (such as 34X34 or red). Valid values are found on the diff_group and diff_id tables. |
diff_2_type |
varchar26 |
0 |
1 |
This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. |
diff_ids |
diff_type |
null |
null |
No |
This field contains a value of all possible differential types. (for example, S for size, C for color, F for flavor, E for scent, and P for pattern). Valid values are stored on the code_detail table with the code_type DIFF and in the diff_type table. |
diff_3 |
varchar210 |
0 |
1 |
Diff_group or diff_id 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 the diff_group and diff_id tables. |
item_master |
diff_3 |
null |
null |
No |
Diff_group or diff_id 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 the diff_group and diff_id tables. |
diff_3_type |
varchar26 |
0 |
1 |
This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. |
diff_ids |
diff_type |
null |
null |
No |
This field contains a value of all possible differential types (for example, S for size, C for color, F for flavor, E for scent, and P for pattern). Valid values are stored in the code_detail table (with the code_type DIFF) and in the diff_type table. |
diff_4 |
varchar210 |
0 |
1 |
Diff_group or diff_id 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 the diff_group and diff_id tables. |
item_master |
diff_4 |
null |
null |
No |
Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (such as men's pant sizes) or a value (such as 6 ounces). For an item that is not a parent, this field may contain a value (such as 34X34 or red). Valid values are found on the diff_group and diff_id tables. |
diff_4_type |
varchar26 |
0 |
1 |
This field will hold a value of all possible differential types. (for example, 'S' - size, 'C' - color, 'F' - flavor, 'E' - scent, 'P' - pattern). Valid values are stored on the code_detail table with the code_type 'DIFF' and on the diff_type table. |
diff_ids |
diff_type |
null |
null |
No |
This field will hold a value of all possible differential types (for example, S for size, C for color, F for flavor, E for scent, and P for pattern). Valid values are stored in the code_detail table (with the code_type DIFF) and in the diff_type table. |
dept |
number4 |
0 |
1 |
Number identifying the department to which the item is attached. The item's department will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the deps table. |
item_master |
dept |
number |
4 |
No |
Number to identify the department to which the item belongs. The item and its parent (and its grandparent) will share the same department. Valid values for this field are in the deps table. |
dept_name |
varchar2120 |
0 |
1 |
Contains the name of the department. |
deps |
dept_name |
varchar2 |
20 |
Yes |
Contains the name of the department. |
class |
varchar27 |
0 |
1 |
Number identifying the class to which the item is attached. The item's class will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the class table. |
item_master |
class |
varchar2 |
7 |
Yes |
Number to identify the class to which the item is attached. The item and its parent (and grandparent) will share the same class. Valid values are in the class table. |
class_name |
varchar2120 |
0 |
1 |
Contains the name of the class. |
class |
class_name |
varchar2 |
20 |
Yes |
Contains the name of the class. |
subclass |
varchar24 |
0 |
1 |
Number identifying the subclass to which the item is attached. The item's subclass will be the same as that of its parent (and, by transitivity, to that of its grandparent). Valid values for this field are located on the subclass table. |
item_master |
subclass |
varchar2 |
4 |
Yes |
Number identifying the subclass to which the item is attached. The item and its parent (and grandparent) share the same subclass Valid values are located in the subclass table. |
sub_name |
varchar2120 |
0 |
1 |
Contains the name of the subclass. |
subclass |
sub_name |
varchar2 |
20 |
Yes |
Contains the name of the subclass. |
status |
varchar21 |
0 |
1 |
Status of the item. Valid values are: W = Worksheet: item setup in progress, cannot be used in system; S = Submitted: item setup complete and awaiting approval, cannot be use in system; A = Approved: item is approved and can now be used throughout the system. |
item_master |
status |
null |
|
Yes |
Status of the item. Valid value is W (worksheet). |
item_desc |
varchar2250 |
0 |
1 |
Long description of the item. This description is used through out the system to help online users identify the item. For items that have parents, this description will default to the parents description plus any differentiators. For items without parents this description will default to null. |
item_master |
item_desc |
null |
null |
Yes |
Long description of the item. This description is used throughout the system to help users identify the item. For items with parents, this description will default to the parent description plus any differentiators. For items without parents, the description defaults to null. |
short_desc |
varchar2120 |
0 |
1 |
Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description will default to the parent's short description. For items without parents, this description will default to null. |
item_master |
short_desc |
null |
null |
Yes |
Shortened description of the item. This description is the default for downloading to the POS. For items that have parents, this description defaults to the parent's short description. For items without parents, this description defaults to null. |
desc_up |
varchar2250 |
0 |
1 |
All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog, but is used in item list of value search processing through out the system. |
item_master |
desc_up |
varchar2 |
100 |
Yes |
All upper case description of the item (same as upper(item_desc)). This field is not displayed in the on-line item maintenance dialog. It is used in Item list of value search processing throughout the system. |
primary_ref_item_ind |
varchar21 |
0 |
1 |
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 'N'o. |
item_master |
primary_ref_item_ind |
varchar2 |
1 |
No |
Indicates whether the sub-transation level item is designated as the primary sub-transaction level item. For items at transaction level and higher, the value is N. |
retail_zone_group_id |
number4 |
0 |
1 |
Retail pricing strategy associated with the item. |
item_master |
retail_zone_group_id |
number |
4 |
No |
Retail pricing strategy associated with the item. |
cost_zone_group_id |
number4 |
0 |
1 |
Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to 'Y' on the system_options table. |
item_master |
cost_zone_group_id |
number |
4 |
No |
Cost zone group associated with the item. This field is only required when elc_ind (landed cost indicator) is set to Y in the system_options table. |
standard_uom |
varchar24 |
0 |
1 |
Unit of measure in which stock of the item is tracked at a corporate level. |
item_master |
standard_uom |
varchar2 |
4 |
Yes |
Unit of measure in which stock of the item is tracked at a corporate level. |
uom_conv_factor |
number20_10 |
0 |
1 |
Conversion factor between an "Each" and the standard_uom when the standard_uom is not in the quantity class (e.g. if standard_uom = lb and 1 lb = 10 eaches, this factor will be 10). This factor will be used to convert sales and stock data when an item is retailed in eaches but does not have eaches as its standard unit of measure. |
item_master |
uom_conv_factor |
null |
null |
No |
Conversion factor between an Each and the standard_uom when the standard_uom is not in the quantity class. (For example, if standard_uom = lb and 1 lb = 10 eaches, this factor is 10.) This factor is used to convert sales and stock data when an item is retailed in eaches but does not have eaches as its standard unit of measure. |
package_size |
number12_4 |
0 |
1 |
Holds the size of the product printed on any packaging (i.e. 24 ounces). This field is used for reporting purposes, as well as by Retek Price Mangement to determine same sized and different sized items. |
item_master |
package_size |
number |
12 |
No |
Contains the size of the product printed on packaging (such as 24 ounces). This field is used for reporting purposes and by RPM to determine same sized and different sized items. |
package_uom |
varchar24 |
0 |
1 |
Holds the unit of measure associated with the package size. This field is used for reporting purposes and by Retek Price Management to determine same sized and different sized items. |
item_master |
package_uom |
varchar2 |
4 |
No |
Contains the unit of measure associated with the package size. This field is used for reporting purposes and by RPM to determine same sized and different sized items. |
merchandise_ind |
varchar21 |
0 |
1 |
Indicates if the item is a merchandise item (Y, N). |
item_master |
merchandise_ind |
varchar2 |
1 |
Yes |
Indicates whether the item is a merchandise item. Valid values are Y and N. |
store_ord_mult |
varchar21 |
0 |
1 |
Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are:C = Cases; I = Inner; E = Eaches. |
item_master |
store_ord_mult |
null |
|
Yes |
Merchandise shipped from the warehouses to the stores must be specified in this unit type. Valid values are C (cases), I (inner), and E (eaches). |
forecast_ind |
varchar21 |
0 |
1 |
Indicates if this item will be interfaced to an external forecasting system (Y, N). |
item_master |
forecast_ind |
varchar2 |
1 |
Yes |
Indicates whether the item will be interfaced to an external forecasting system. Valid values are Y and N. |
mfg_rec_retail |
number20_4 |
0 |
1 |
Manufacturer's recommended retail price for the item. Used for informational purposes only. This field is stored in the primary currency. |
item_master |
mfg_rec_retail |
number |
20 |
No |
Manufacturer's recommended retail price for the item, used for informational purposes only. This field is stored in the primary currency. |
retail_label_type |
varchar26 |
0 |
1 |
This field indicates any special lable type assoctiated with an item (i.e. pre-priced or cents off). This field is used for reporting purposes only. Values for this field are defined by the 'RTLT' code on code detail. |
item_master |
retail_label_type |
varchar2 |
6 |
No |
This field indicates the special lable type associated with an item (such as pre-priced or cents off). This field is used for reporting purposes only. Valid values are defined by the RTLT code in code detail. |
retail_label_type_desc |
varchar240 |
0 |
1 |
Contains the retail label type description corresponding to the retail_label_type value in item_master. |
code_detail |
code_desc |
varchar2 |
40 |
No |
Contains the retail label type description corresponding to the retail_label_type value in item_master. |
retail_label_value |
number20_4 |
0 |
1 |
This field represents the value associated with the retail label type. |
item_master |
retail_label_value |
number |
20 |
No |
This field represents the value associated with the retail label type. |
handling_temp |
varchar26 |
0 |
1 |
Holds the temperature information associated with the item. Valid values for this field are in the code type 'HTMP' on the code_head and code_detail tables. |
item_master |
handling_temp |
varchar2 |
6 |
No |
This field contains the temperature information associated with the item. Valid values for this field are in the code type HTMP on the code_head and code_detail tables. |
handling_temp_desc |
varchar240 |
0 |
1 |
Contains the Handling temperature description corresponding to the handling_temp value in item_master. |
code_detail |
code_desc |
varchar2 |
40 |
No |
Contains the Handling temperature description corresponding to the handling_temp value in item_master. |
handling_sensitivity |
varchar26 |
0 |
1 |
Holds the sensitivity information associated with the item. Valid values for this field are in the code type 'HSEN' on the code_head and code_detail tables. |
item_master |
handling_sensitivity |
varchar2 |
6 |
No |
This field contains the sensitivity information associated with the item. Valid values for this field are in the code type HSEN in the code_head and code_detail tables. |
handling_sensitivity_desc |
varchar240 |
0 |
1 |
Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. |
code_detail |
code_desc |
varchar2 |
40 |
No |
Contains the Handling sensitivity description corresponding to the handling_sensitivity value in item_master. |
catch_weight_ind |
varchar21 |
0 |
1 |
Indiactes whether the item should be weighed when it arives at a location. Valid values for this field are 'Y' and 'N'. |
item_master |
catch_weight_ind |
varchar2 |
1 |
Yes |
Indicates whether the item should be weighed when it arrives at a location. Valid values are Y and N. |
waste_type |
varchar26 |
0 |
1 |
Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (i.e. fat is trimmed off at customer request). Spoilage wastage occurs during the products shelf life (i.e. evaporation causes the product to weight less after a period of time). Valid values are: SP - spoilage; and SL - Sales. |
item_master |
waste_type |
null |
|
No |
Identifies the wastage type as either sales or spoilage wastage. Sales wastage occurs during processes that make an item saleable (for example, fat is trimmed off at customer request). Spoilage wastage occurs during the product's shelf life (for example, evaporation causes the product to weigh less after a period of time). Valid values are SP (spoilage) and SL (sales). |
waste_type_desc |
varchar240 |
0 |
1 |
Contains the Waste Type description corresponding to the Waste_Type value in item_master. |
code_detail |
code_desc |
varchar2 |
40 |
No |
Contains the Waste Type description corresponding to the Waste_Type value in item_master. |
waste_pct |
number12_4 |
0 |
1 |
Average percent of wastage for the item over its shelf life. Used in inflating the retail price for wastage items. |
item_master |
waste_pct |
number |
12 |
No |
Average percent of wastage for the item throughout its shelf life. Used in inflating the retail price for wastage items. |
default_waste_pct |
number12_4 |
0 |
1 |
Default daily wastage percent for spoilage type wastage items. This value will default to all item locations and represents the average amount of wastage that occurs on a daily basis. |
item_master |
default_waste_pct |
number |
12 |
No |
Default daily wastage percent for spoilage type wastage items. This value defaults to all item locations and represents the average amount of wastage that occurs on a daily basis. |
const_dimen_ind |
varchar21 |
0 |
1 |
Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers will be defaulted to the primary supplier/primary country dimensions. Editing of dimensions for the item will only be allowed for the primary supplier/primiary country. |
item_master |
const_dimen_ind |
null |
null |
Yes |
Indicates that the dimensions of the product are always the same, regardless of the supplier. If this field is Y, the dimensions for all suppliers default to the primary supplier/primary country dimensions. Editing of dimensions for the item will be allowed only for the primary supplier/primiary country. |
simple_pack_ind |
varchar21 |
0 |
1 |
Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are:Y = Yes, this item is a simple pack; N = No if this is not a simple pack. |
item_master |
simple_pack_ind |
null |
|
Yes |
Indicates whether the pack item is a simple pack. This field is available only if the item is a pack item. A simple pack is an item for which the components are all the same item (such as a six pack of cola). Valid values are Y (this item is a simple pack) and N (this is not a simple pack). |
contains_inner_ind |
varchar21 |
0 |
1 |
Indicates if pack item contains inner packs. Vendor packs will never contain inner packs and this field will be defaulted to 'N'. This field will only be available if the item is a pack item. Valid values are:Y = Yes, this pack contains inner packs; N = No, this pack does not contain inner packs. |
item_master |
contains_inner_ind |
null |
|
Yes |
Indicates if pack item contains inner packs. This field will only be available if the item is a pack item. Valid values are Y (this pack contains inner packs) and N (this pack does not contain inner packs). Vendor packs will never contain inner packs, and this field will default to N. |
sellable_ind |
varchar21 |
0 |
1 |
Indicates if pack item may be sold as a unit. If it is 'Y' then the pack will have its own unique unit retail. If it is 'N' then the pack's unit retail is the sum of each individual item's total retail within the pack. This field will only be available if the item is a pack item. Value values are: Y = Yes, this pack may be sold as a unit; N = No, this pack man not be sold as a unit. |
item_master |
sellable_ind |
null |
|
Yes |
Indicates whether the pack item may be sold as a unit. This field is available only if the item is a pack item. Value values are Y (this pack may be sold as a unit) and N (this pack may not be sold as a unit). If Y, the pack will have its own unique unit retail. If N, the pack's unit retail is the sum of each individual item's total retail within the pack. |
orderable_ind |
varchar21 |
0 |
1 |
Indicates if pack item is orderable. If it is 'Y' then the suppliers of the pack must supply all components in the pack. If it is 'N' then the components may have different suppliers. This field will only be available if the item is a pack item. Valid values are: Y = Yes, this pack may be ordered, N = No, this pack may not be ordered. |
item_master |
orderable_ind |
null |
|
Yes |
Indicates whether the pack item is orderable. This field will only be available if the item is a pack item. Valid values are Y (this pack may be ordered) abd N (this pack may not be ordered). If Y, the suppliers of the pack must supply all components in the pack. If N, then the components may have different suppliers. |
pack_type |
varchar21 |
0 |
1 |
Indicates if pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will use the vendor pack number. A buyer pack is a pack that a buyer created for internal ease of use. If the pack item is a buyer pack communication with the supplier will explode the pack out to its component items. This field will only be available if the item is a pack item. If the pack item is not orderable this field must be null. Valid values are: V = Vendor; B = Buyer. |
item_master |
pack_type |
null |
|
No |
Indicates whether pack item is a vendor pack or a buyer pack. A vendor pack is a pack that the vendor or supplier recognizes and sells to the retailer. If the pack item is a vendor pack, communication with the supplier will include the vendor pack number. A buyer pack is a pack that a buyer created for internal ease of use. If the pack item is a buyer pack, communication with the supplier will explode the pack out to its component items. This field will be available only if the item is a pack item. If the pack item is not orderable, this field must be null. Valid values are V (vendor) and B (buyer). |
order_as_type |
varchar21 |
0 |
1 |
Indicates if pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if pack item is an orderable buyer pack. This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid Values are: E = Eaches (component level) P = Pack (buyer pack only). |
item_master |
order_as_type |
null |
|
No |
Indicates whether the pack item is receivable at the component level or at the pack level (for a buyer pack only). This field is required if the pack item is an orderable buyer pack.This field must be NULL if the pack is sellable only or a vendor pack. This field will only be available if the item is a pack item. Valid values are E = Eaches (component level) and P = Pack (buyer pack only). |
comments |
varchar22000 |
0 |
1 |
Holds any comments associated with the item. |
item_master |
comments |
varchar2 |
2000 |
No |
Contains comments associated with the item. |
unit_retail |
number20_4 |
0 |
1 |
This field holds the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. |
item_zone_price |
unit_retail |
number |
20 |
No |
This field contains the unit retail in the standard unit of measure for the item/zone combination. This field is stored in the local currency. |
item_service_level |
varchar26 |
0 |
1 |
Holds a value that restricts the type of shipment methods that RCOM can select for an item. |
item_master |
item_service_level |
varchar2 |
6 |
No |
Contains a value that restricts the type of shipment methods that RCOM can select for an item. |
gift_wrap_ind |
varchar21 |
0 |
1 |
This field will contain a value of 'Y' if the item is eligible to be gift wrapped. |
item_master |
gift_wrap_ind |
varchar2 |
1 |
Yes |
This field contains Y if the item is eligible to be gift wrapped. |
ship_alone_ind |
varchar21 |
0 |
1 |
This field will contain a value of 'Y' if the item should be shipped to the customer is a seperate package versus being grouped together in a box. |
item_master |
ship_alone_ind |
varchar2 |
1 |
Yes |
This field will contain Y if the item should be shipped to the customer in a separate package (instead of being grouped together in a box). |
vendor_style |
varchar215 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
15 |
No |
Not used by RMS. |
std_unit_weight |
number20_10 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
number |
20 |
No |
Not used by RMS. |
single_price_flag |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
preticket_flag |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
planned_residual |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
autopackable |
number8 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
number |
8 |
No |
Not used by RMS. |
sortable |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
item_master_uda1 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda2 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda3 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda4 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda5 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda6 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda7 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda8 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda9 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda10 |
varchar220 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda11 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda12 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda13 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda14 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
item_master_uda15 |
varchar220 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
20 |
No |
Not used by RMS. |
ship_alone |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
slottable |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
freight_class |
varchar24 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
4 |
No |
Not used by RMS. |
new_item |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
brand |
varchar210 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
10 |
No |
Not used by RMS. |
break_case_ups |
varchar24 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
4 |
No |
Not used by RMS. |
rigid |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
fragile |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
container_type |
varchar26 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
6 |
No |
Not used by RMS. |
conveyable_flag |
varchar21 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
1 |
No |
Not used by RMS. |
hazard_matl_code |
varchar26 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
6 |
No |
Not used by RMS. |
velocity |
number12_4 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
number |
12 |
No |
Not used by RMS. |
high_value_ind |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
ticket_type |
varchar24 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
4 |
No |
Not used by RMS. |
color |
varchar224 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
varchar2 |
24 |
No |
Not used by RMS. |
size1 |
varchar26 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
6 |
No |
Not used by RMS. |
fit |
varchar26 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
6 |
No |
Not used by RMS. |
shade |
varchar26 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
6 |
No |
Not used by RMS. |
single_contain_bulk |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
unit_pick_system_code |
varchar212 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
4 |
No |
Not used by RMS. |
roundable_flag |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
perishable_ind |
varchar21 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
1 |
No |
Not used by RMS. |
division |
number4 |
0 |
1 |
Not used by RMS. |
n/a |
n/a |
number |
4 |
No |
Not used by RMS. |
vendor_nbr |
varchar210 |
0 |
1 |
Not used by RMS. |
N/A |
N/A |
varchar2 |
10 |
No |
Not used by RMS. |
kitting_wip_code |
varchar29 |
0 |
1 |
Wip code used to designate the Kitting process used in item_master |
N/A |
N/A |
varchar2 |
6 |
No |
WIP code used to designate the kitting process used in item_master |
unit_ticket_qty |
number3 |
0 |
1 |
Item Master User Defined Attribute |
N/A |
N/A |
number |
3 |
No |
Item Master user defined attribute. |
item_length |
number12_4 |
0 |
1 |
Length of an individual item |
n/a |
n/a |
number |
12 |
No |
Length of an individual item. |
item_width |
number12_4 |
0 |
1 |
Width of an individual item |
N/A |
N/A |
number |
12 |
No |
Width of an individual item. |
item_height |
number12_4 |
0 |
1 |
Height of an individual Item |
n/a |
n/a |
number |
12 |
No |
Height of an individual Item |
item_weight |
number12_4 |
0 |
1 |
Weight of an individual item |
N/A |
N/A |
number |
12 |
No |
Weight of an individual item |
item_cube |
number12_4 |
0 |
1 |
Cubic dimension of an individual item |
n/a |
n/a |
number |
12 |
No |
Cubic dimension of an individual item. |
std_unit_factor |
number6_2 |
0 |
1 |
Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. |
N/A |
N/A |
number |
6 |
No |
Used for putaway by volume. The percentage of the standard number of units that will fit into a location type. |
std_unit_qty |
number12_4 |
0 |
1 |
The number of items that normally fit on/in the container type |
N/A |
N/A |
number |
12 |
No |
The number of items that normally fits in the container type. |
expiration_days |
number4 |
0 |
1 |
The number of days before inventory is deemed to be no longer distributable |
n/a |
n/a |
number |
4 |
No |
The number of days before inventory no longer distributable. |
putaway_by_volume |
varchar26 |
0 |
1 |
If set to Y, putaway will be determined by cube or volume. If set to N, putaway will be determined by capacity. |
N/A |
N/A |
varchar2 |
6 |
No |
If set to Y, putaway is determined by cube or volume. If set to N, putaway is determined by capacity. |
putaway_plan |
varchar220 |
0 |
1 |
Plan used for putaway |
N/A |
N/A |
varchar2 |
6 |
No |
Plan used for putaway. |
item_type |
varchar26 |
0 |
1 |
This column contains a character indicator to determine if the item being ordered is a pack or not. |
N/A |
N/A |
varchar2 |
6 |
No |
This column contains a character to determine if the item being ordered is a pack. |
sorter_group |
varchar26 |
0 |
1 |
Sorter Group identifier |
N/A |
N/A |
varchar2 |
6 |
No |
Sorter Group identifier. |
sku_optimization |
varchar21 |
0 |
1 |
Indicator for inclusion in SKU optimization |
N/A |
N/A |
varchar2 |
1 |
No |
Indicator for inclusion in SKU optimization. |
ext_source_system |
varchar26 |
0 |
1 |
Specifies what external system the data originated from. |
N/A |
N/A |
varchar2 |
6 |
No |
Specifies the external system from which the data originated. |
item_xform_ind |
varchar21 |
0 |
1 |
Indicator shows that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. |
N/A |
N/A |
varchar2 |
1 |
No |
Indicates that an item is associated with an item transformation. The item is either the sellable or the orderable item in the transformation process. |
inventory_ind |
varchar21 |
0 |
1 |
Inventory Indicator |
N/A |
N/A |
varchar2 |
1 |
No |
Inventory indicator. |
order_type |
varchar29 |
0 |
1 |
Indicates the type of order and which Open To Buy bucket will be updated. |
N/A |
N/A |
varchar2 |
9 |
No |
Indicates the type of order and which Open To Buy bucket will be updated. |
sale_type |
varchar26 |
0 |
1 |
n/a |
N/A |
N/A |
varchar2 |
6 |
No |
N/A |
deposit_item_type |
varchar26 |
0 |
1 |
n/a |
N/A |
N/A |
varchar2 |
6 |
No |
N/A |
container_item |
varchar225 |
0 |
1 |
n/a |
N/A |
N/A |
varchar2 |
25 |
No |
N/A |
deposit_in_price_per_uom |
varchar26 |
0 |
1 |
n/a |
N/A |
N/A |
varchar2 |
6 |
No |
N/A |
transport_ind |
varchar21 |
0 |
1 |
n/a |
N/A |
N/A |
varchar2 |
1 |
No |
N/A |
notional_pack_ind |
varchar21 |
0 |
1 |
Indicates in SIM if a sellable simple pack needs to be broken down to its component item. |
NA |
NA |
NA |
NA |
NA |
NA |
soh_inquiry_at_pack_ind |
varchar21 |
0 |
1 |
Indicates in SIM if a notional simple pack item's inventory should be displayed in packs. |
NA |
NA |
NA |
NA |
NA |
NA |
purchase_type |
varchar26 |
0 |
1 |
Indicates if an item is a normal, consignment or concession item - 'N' for normal, 'S' for consignment, 'C' for concession. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfItemHdrDesc:ExtOfItemHdrDesc
|
*
|
0
|
1
|
Provide an extension hook to customize ItemHdrDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfItemHdrDesc:LocOfItemHdrDesc
|
*
|
0
|
1
|
Provide an extension hook to localize ItemHdrDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|