item |
item_master |
item |
Yes |
Unique
alphanumeric value that identifies the item. |
item_number_type |
item_master |
item_number_type |
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 |
item_master |
format_id |
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 |
item_master |
prefix |
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 |
item_master |
item_parent |
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 |
item_master |
item_grandparent |
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 |
item_master |
pack_ind |
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 |
item_master |
item_level |
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 |
item_master |
tran_level |
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 |
item_master |
diff_1 |
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 |
diff_ids |
diff_type |
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 |
item_master |
diff_2 |
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 |
diff_ids |
diff_type |
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 |
item_master |
diff_3 |
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 |
diff_ids |
diff_type |
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 |
item_master |
diff_4 |
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 |
diff_ids |
diff_type |
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 |
item_master |
dept |
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 |
deps |
dept_name |
Yes |
Contains the
name of the department. |
class |
item_master |
class |
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 |
class |
class_name |
Yes |
Contains the
name of the class. |
subclass |
item_master |
subclass |
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 |
subclass |
sub_name |
Yes |
Contains the
name of the subclass. |
status |
item_master |
status |
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 |
item_master |
item_desc |
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 |
item_master |
short_desc |
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 |
item_master |
desc_up |
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 |
item_master |
primary_ref_item_ind |
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 |
item_master |
retail_zone_group_id |
No |
Retail pricing
strategy associated with the item. |
cost_zone_group_id |
item_master |
cost_zone_group_id |
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 |
item_master |
standard_uom |
Yes |
Unit of measure
in which stock of the item is tracked at a corporate level. |
uom_conv_factor |
item_master |
uom_conv_factor |
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 |
item_master |
package_size |
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 |
item_master |
package_uom |
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 |
item_master |
merchandise_ind |
Yes |
Indicates if the
item is a merchandise item (Y, N). |
store_ord_mult |
item_master |
store_ord_mult |
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 |
item_master |
forecast_ind |
Yes |
Indicates if
this item will be interfaced to an external forecasting system (Y,
N). |
mfg_rec_retail |
item_master |
mfg_rec_retail |
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 |
item_master |
retail_label_type |
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 |
code_detail |
code_desc |
No |
Contains the
retail label type description corresponding to the retail_label_type value
in item_master. |
retail_label_value |
item_master |
retail_label_value |
No |
This field
represents the value associated with the retail label type. |
handling_temp |
item_master |
handling_temp |
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 |
code_detail |
code_desc |
No |
Contains the
Handling temperature description corresponding to the handling_temp value
in item_master. |
handling_sensitivity |
item_master |
handling_sensitivity |
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 |
code_detail |
code_desc |
No |
Contains the
Handling sensitivity description corresponding to the handling_sensitivity
value in item_master. |
catch_weight_ind |
item_master |
catch_weight_ind |
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 |
item_master |
waste_type |
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 |
code_detail |
code_desc |
No |
Contains the
Waste Type description corresponding to the Waste_Type value in
item_master. |
waste_pct |
item_master |
waste_pct |
No |
Average percent
of wastage for the item over its shelf life. Used in inflating the retail
price for wastage items. |
default_waste_pct |
item_master |
default_waste_pct |
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 |
item_master |
const_dimen_ind |
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 |
item_master |
simple_pack_ind |
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 |
item_master |
contains_inner_ind |
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 |
item_master |
sellable_ind |
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 |
item_master |
orderable_ind |
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 |
item_master |
pack_type |
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 |
item_master |
order_as_type |
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 |
item_master |
comments |
No |
Holds any
comments associated with the item. |
unit_retail |
item_zone_price |
unit_retail |
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 |
item_master |
item_service_level |
No |
Holds a value
that restricts the type of shipment methods that RCOM can select for an
item. |
gift_wrap_ind |
item_master |
gift_wrap_ind |
Yes |
This field will
contain a value of 'Y' if the item is eligible to be gift
wrapped. |
ship_alone_ind |
item_master |
ship_alone_ind |
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 |
n/a |
n/a |
No |
Not used by
RMS. |
std_unit_weight |
n/a |
n/a |
No |
Not used by
RMS. |
single_price_flag |
n/a |
n/a |
No |
Not used by
RMS. |
preticket_flag |
n/a |
n/a |
No |
Not used by
RMS. |
planned_residual |
n/a |
n/a |
No |
Not used by
RMS. |
autopackable |
n/a |
n/a |
No |
Not used by
RMS. |
sortable |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda1 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda2 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda3 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda4 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda5 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda6 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda7 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda8 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda9 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda10 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda11 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda12 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda13 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda14 |
n/a |
n/a |
No |
Not used by
RMS. |
item_master_uda15 |
n/a |
n/a |
No |
Not used by
RMS. |
ship_alone |
n/a |
n/a |
No |
Not used by
RMS. |
slottable |
n/a |
n/a |
No |
Not used by
RMS. |
freight_class |
n/a |
n/a |
No |
Not used by
RMS. |
new_item |
n/a |
n/a |
No |
Not used by
RMS. |
brand |
n/a |
n/a |
No |
Not used by
RMS. |
break_case_ups |
n/a |
n/a |
No |
Not used by
RMS. |
rigid |
n/a |
n/a |
No |
Not used by
RMS. |
fragile |
n/a |
n/a |
No |
Not used by
RMS. |
container_type |
n/a |
n/a |
No |
Not used by
RMS. |
conveyable_flag |
n/a |
n/a |
No |
Not used by
RMS. |
hazard_matl_code |
n/a |
n/a |
No |
Not used by
RMS. |
velocity |
n/a |
n/a |
No |
Not used by
RMS. |
high_value_ind |
n/a |
n/a |
No |
Not used by
RMS. |
ticket_type |
n/a |
n/a |
No |
Not used by
RMS. |
color |
n/a |
n/a |
No |
Not used by
RMS. |
size1 |
n/a |
n/a |
No |
Not used by
RMS. |
fit |
n/a |
n/a |
No |
Not used by
RMS. |
shade |
n/a |
n/a |
No |
Not used by
RMS. |
single_contain_bulk |
n/a |
n/a |
No |
Not used by
RMS. |
unit_pick_system_code |
n/a |
n/a |
No |
Not used by
RMS. |
roundable_flag |
n/a |
n/a |
No |
Not used by
RMS. |
perishable_ind |
n/a |
n/a |
No |
Not used by
RMS. |
division |
n/a |
n/a |
No |
Not used by
RMS. |
vendor_nbr |
n/a |
n/a |
No |
Not used by
RMS. |
kitting_wip_code |
n/a |
n/a |
No |
Wip code used to
designate the Kitting process used in item_master |
unit_ticket_qty |
n/a |
n/a |
No |
Item Master User
Defined Attribute |
item_length |
n/a |
n/a |
No |
Length of an
individual item |
item_width |
n/a |
n/a |
No |
Width of an
individual item |
item_height |
n/a |
n/a |
No |
Height of an
individual Item |
item_weight |
n/a |
n/a |
No |
Weight of an
individual item |
item_cube |
n/a |
n/a |
No |
Cubic dimension
of an individual item |
std_unit_factor |
n/a |
n/a |
No |
Used for putaway
by volume. The percentage of the standard number of units that will fit
into a location type. |
std_unit_qty |
n/a |
n/a |
No |
The number of
items that normally fit on/in the container type |
expiration_days |
n/a |
n/a |
No |
The number of
days before inventory is deemed to be no longer distributable |
putaway_by_volume |
n/a |
n/a |
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 |
n/a |
n/a |
No |
Plan used for
putaway |
item_type |
n/a |
n/a |
No |
This column
contains a character indicator to determine if the item being ordered is a
pack or not. |
sorter_group |
n/a |
n/a |
No |
Sorter Group
identifier |
sku_optimization |
n/a |
n/a |
No |
Indicator for
inclusion in SKU optimization |
ext_source_system |
n/a |
n/a |
No |
Specifies what
external system the data originated from. |
item_xform_ind |
n/a |
n/a |
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 |
n/a |
n/a |
No |
Inventory
Indicator |
order_type |
n/a |
n/a |
No |
Indicates the
type of order and which Open To Buy bucket will be updated. |
sale_type |
n/a |
n/a |
No |
n/a |
deposit_item_type |
n/a |
n/a |
No |
n/a |
container_item |
n/a |
n/a |
No |
n/a |
deposit_in_price_per_uom |
n/a |
n/a |
No |
n/a |
transport_ind |
n/a |
n/a |
No |
n/a |