|
|
|
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
what type the item is. Valid values for this field are in the code type
'UPCT' on 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 will
hold the format ID that corresponds to the item's variable UPC. This
value is only used 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
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_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 both 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 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_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 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.
|
|
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 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.
|
|
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 (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.
|
|
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 (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_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 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_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 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_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 (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_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' -
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.
|
|
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
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.
|
|
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
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.
|
|
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'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.
|
|
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
|
null
|
Yes
|
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_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 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.
|
|
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 will default to
the parent's short description. For items without parents, this
description will default 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, but is used in item
list of value search processing through out 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 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.
|
|
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' on 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 (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.
|
|
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
|
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.
|
|
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
|
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.
|
|
merchandise_ind
|
varchar21
|
0
|
1
|
Indicates if
the item is a merchandise item (Y, N).
|
item_master
|
merchandise_ind
|
varchar2
|
1
|
Yes
|
Indicates if
the item is a merchandise item (Y, 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
|
null
|
Yes
|
Merchandise
shipped from the warehouses to the stores must be specified in this unit
type. Valid values are:C = Cases; I = Inner; 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 if
this item will be interfaced to an external forecasting system (Y, 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 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.
|
|
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
|
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.
|
|
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
|
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.
|
|
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
|
Indiactes
whether the item should be weighed when it arives at a location. Valid
values for this field 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
|
null
|
No
|
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.
|
|
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 over 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 will default
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 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.
|
|
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
|
null
|
Yes
|
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.
|
|
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
|
null
|
Yes
|
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.
|
|
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
|
null
|
Yes
|
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.
|
|
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
|
null
|
Yes
|
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.
|
|
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
|
null
|
No
|
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.
|
|
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
|
null
|
No
|
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).
|
|
comments
|
varchar22000
|
0
|
1
|
Holds any
comments associated with the item.
|
item_master
|
comments
|
varchar2
|
2000
|
No
|
Holds any
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
holds 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
|
Holds 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 will
contain a value of '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 a value of 'Y' if the item should be shipped to the customer is a
seperate package versus 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 fit on/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 is deemed to be 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 will be determined by cube or volume. If set to N, putaway will
be 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 indicator to determine if the item being ordered is
a pack or not.
|
|
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 what
external system the data originated from.
|
|
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
|
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.
|
|
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
|
