Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XItemDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
The unique identifier of the main item on the message. |
item_master |
item |
varchar2 |
25 |
Yes |
The unique identifier of the main item on the message. |
item_parent |
varchar225 |
0 |
1 |
The item at the level above this item. This value must be predefined as an item on the ITEM_MASTER table. The item parent cannot be modified. |
item_master |
item_parent |
null |
null |
No |
The item at the level above this item.This value must be predefined as an item on the ITEM_MASTER table. The item parent cannot be modified. |
item_grandparent |
varchar225 |
0 |
1 |
The item two levels above this item. This value must be predefined as an item on the ITEM_MASTER table. The item grandparent cannot be modified. |
item_master |
item_grandparent |
null |
null |
No |
The item two levels above this item. This value must be predefined as an item on the ITEM_MASTER table. The item grandparent cannot be modified. |
pack_ind |
varchar21 |
1 |
1 |
Indicates if the item is a pack item. Valid values are Y (yes) and N (no). This value cannot be modified. |
item_master |
pack_ind |
null |
null |
No |
Indicates if the item is a pack item. Valid values are Y and N. This value cannot be modified. |
item_level |
number1 |
1 |
1 |
The level of the item. Valid values are 1 (single level or pack item), 2 (child item), and 3 (grandchild item). This value cannot be modified. |
item_master |
item_level |
null |
null |
No |
The level of the item. Valid values are 1 (single level or pack item), 2 (child item), and 3 (grandchild item). This value cannot be modified. |
tran_level |
number1 |
1 |
1 |
The transaction level of the item. Valid values are 1, 2, and 3. If this is a transaction item this will equal the item level. If the item is a pack this will equal 1. This value cannot be modified. |
item_master |
tran_level |
null |
null |
No |
The transaction level of the item. Valid values are 1, 2, and 3. If this is a transaction item, it will equal the item level. If the item is a pack this will equal 1. This value cannot be modified. |
diff_1 |
varchar210 |
0 |
1 |
A differentiator id which differentiates a transaction level item from its parent item. If the item on the message is a parent this field may hold a differentiator group id. This value must be predefined on the DIFF_IDS or DIFF_GROUP_HEAD table. |
item_master |
diff_1 |
null |
null |
No |
A differentiator ID that differentiates a transaction level item from its parent item. If the item on the message is a parent. this field may contain a differentiator group ID. This value must be predefined on the DIFF_IDS or DIFF_GROUP_HEAD table. |
diff_2 |
varchar210 |
0 |
1 |
See description for diff_1. |
item_master |
diff_2 |
null |
null |
No |
See description for diff_1. |
diff_3 |
varchar210 |
0 |
1 |
See description for diff_1. |
item_master |
diff_3 |
null |
null |
No |
See description for diff_1. |
diff_4 |
varchar210 |
0 |
1 |
See description for diff_1. |
item_master |
diff_4 |
null |
null |
No |
See description for diff_1. |
dept |
number4 |
1 |
1 |
The number of the department to which this item belongs. This value must be predefined on the DEPS table. It cannot be modified. |
item_master |
dept |
null |
null |
No |
The number of the department to which this item belongs. This value must be predefined on the DEPS table. It cannot be modified. |
class |
number4 |
1 |
1 |
The number of the class to which the item belongs. This value must be predefined on the CLASS table. It cannot be modified. |
item_master |
class |
null |
null |
No |
The number of the class to which the item belongs. This value must be predefined on the CLASS table. It cannot be modified. |
subclass |
number4 |
1 |
1 |
The number of the subclass to which the item belongs. This value must be predefined on the SUBCLASS table. It cannot be modified. |
item_master |
subclass |
null |
null |
No |
The number of the subclass to which the item belongs. This value must be predefined in the SUBCLASS table. It cannot be modified. |
item_desc |
varchar2250 |
1 |
1 |
The long description of the item. |
item_master |
item_desc |
varchar2 |
250 |
Yes |
The long description of the item. |
iscloc_hier_level |
varchar22 |
0 |
1 |
The level of the organizational hierarchy used to create item\supplier\country\location relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse). |
* |
* |
null |
null |
No |
The level of the organizational hierarchy used to create item\supplier\country\location relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). |
izp_hier_level |
varchar22 |
0 |
1 |
The level of the organizational hierarchy used to create item\zone\price relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). This value should be null if the item is a non sellable pack. |
* |
* |
null |
null |
No |
The level of the organizational hierarchy used to create item\zone\price relationships. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), and W (warehouse). This value should be null if the item is a non sellable pack. |
short_desc |
varchar2120 |
0 |
1 |
The short description of the item. If this field is not populated it will default from the long description. |
item_master |
short_desc |
varchar2 |
120 |
No |
The short description of the item. If this field is not populated it will default from the long description. |
retail_zone_group_id |
number4 |
0 |
1 |
The zone group on the price_zone_group table to which this item belongs. It is required except for non sellable packs. This value cannot be modified. |
item_master |
retail_zone_group_id |
null |
null |
No |
The zone group on the price_zone_group table to which this item belongs. It is required except for non sellable packs. This value cannot be modified. |
cost_zone_group_id |
number4 |
0 |
1 |
The cost zone from the cost_zone_group table to which the item belongs. This should be null if landed cost is not being used in the system or the item is an orderable buyer pack. |
item_master |
cost_zone_group_id |
null |
null |
No |
The cost zone from the cost_zone_group table to which the item belongs. This should be null if landed cost is not being used in the system or the item is an orderable buyer pack. |
standard_uom |
varchar24 |
0 |
1 |
The unit of measure at which the item is tracked at the corporate level. This will be defaulted to EA (eaches) if not populated on the message. It cannot be modified. |
item_master |
standard_uom |
null |
null |
No |
The unit of measure at which the item is tracked at the corporate level. This is defaulted to EA (eaches) if not populated in the message. It cannot be modified. |
store_ord_mult |
varchar21 |
1 |
1 |
The unit type of merchandise shipped from the warehouse to the store for this item. Valid values are C (cases), I (inners), and E (eaches). |
item_master |
store_ord_mult |
varchar2 |
1 |
Yes |
The unit type of merchandise shipped from the warehouse to the store for this item. Valid values are C (cases), I (inners), and E (eaches). |
forecast_ind |
varchar21 |
1 |
1 |
Indicates whether the item is forecastable. Valid value are Y (yes) and N (no). This value should be N if the item is a pack. |
item_master |
forecast_ind |
varchar2 |
1 |
Yes |
Indicates whether the item is forecastable. Valid values are Y and N. Value should be N if the item is a pack. |
simple_pack_ind |
varchar21 |
1 |
1 |
Indicates if the item is a simple pack. This field is required if the item is a pack. Valid values are Y (yes) and N (no). This value cannot be modified. |
item_master |
simple_pack_ind |
null |
null |
No |
Indicates whether the item is a simple pack. This field is required if the item is a pack. Valid values are Y and N. This value cannot be modified. |
contains_inner_ind |
varchar21 |
1 |
1 |
This should be Y (yes) if the item is a pack and at least one component item is a pack; otherwise it should be N (no). |
item_master |
contains_inner_ind |
null |
null |
No |
This should be Y if the item is a pack and at least one component item is a pack. Otherwise, it should be N. |
sellable_ind |
varchar21 |
1 |
1 |
If the item is a pack, this value indicates if the pack can be sold as a unique unit. Valid values are Y (yes) and N (no). This value cannot be modified. It should be Y for a non-pack item. |
item_master |
sellable_ind |
null |
null |
No |
If the item is a pack, this value indicates if the pack can be sold as a unique unit. Valid values are Y and N. This value cannot be modified. It should be Y for a non-pack item. |
orderable_ind |
varchar21 |
1 |
1 |
If the item is a pack, this field indicates if it can be placed on orders. Valid values are Y (yes) and N (no). This field cannot be modified. It should be Y for a non-pack item. |
item_master |
orderable_ind |
null |
null |
No |
If the item is a pack, this field indicates if it can be placed on orders. Valid values are Y and N. This field cannot be modified. It should be Y for a non-pack item. |
pack_type |
varchar21 |
0 |
1 |
If the item is a pack, this field will indicate what type of pack it is. Valid values are B (buyer) and V (vendor). This field cannot be modified. If the item is not a pack this value should be null. |
item_master |
pack_type |
varchar2 |
1 |
No |
If the item is a pack, this field indicates the type of pack. Valid values are B (buyer) and V (vendor). This field cannot be modified. If the item is not a pack, this value should be null. |
order_as_type |
varchar21 |
0 |
1 |
If the item is an orderable buyer pack, this indicates how it will be ordered. Valid values are E (eaches) and P (pack). This field cannot be modified. If the item is not a pack, this should be null. |
item_master |
order_as_type |
null |
null |
No |
If the item is an orderable buyer pack, this field indicates how it will be ordered. Valid values are E (eaches) and P (pack). This field cannot be modified. If the item is not a pack, this should be null. |
comments |
varchar22000 |
0 |
1 |
Comments associated with the item. |
item_master |
comments |
varchar2 |
2000 |
No |
Comments associated with the item. |
create_datetime |
xs:dateTime |
0 |
1 |
Date/time stamp of when the record was created. This date/time will be used in export processing. This value should only be populated on insert - it should never be updated. |
item_master |
create_datetime |
RIBDate |
* |
No |
Date/time stamp from when the record was created. This date/time will be used in export processing. This value should only be initially populated. It should never be updated. |
XItemCtryDesc
|
*
|
0
|
unbounded
|
Child node.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
XItemSupDesc
|
*
|
0
|
unbounded
|
Child node.
|
|
|
|
|
|
|
XItemBOMDesc
|
*
|
0
|
unbounded
|
Child node.
|
|
|
|
|
|
|
XItemVATDesc
|
*
|
0
|
unbounded
|
Child node.
|
|
|
|
|
|
|
XIZPDesc
|
*
|
0
|
unbounded
|
Child node.
|
|
|
|
|
|
|
XItemUDADtl
|
*
|
0
|
unbounded
|
Child node that is not used.
|
|
|
|
|
|
|
XItemSeason
|
*
|
0
|
unbounded
|
Child node that is not used.
|
|
|
|
|
|
|
XItemImage
|
*
|
0
|
unbounded
|
Child node that is not used.
|
|
|
|
|
|
|
status |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
uom_conv_factor |
number20_10 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
package_size |
number12_4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
handling_temp |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
handling_sensitivity |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
mfg_rec_retail |
number20_4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
waste_type |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
waste_pct |
number12_4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
item_number_type |
varchar26 |
0 |
1 |
This type can hold a number of digits count umber_type. |
* |
* |
null |
null |
No |
Not used by RMS. |
catch_weight_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
const_dimen_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
gift_wrap_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
ship_alone_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
ext_source_system |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
size_group1 |
number4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
size_group2 |
number4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
size1 |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
size2 |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
color |
varchar224 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
system_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
upc_supplement |
number5 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
upc_type |
varchar25 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
primary_upc_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
primary_repl_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
item_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
diff_1_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
diff_2_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
diff_3_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
diff_4_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
perishable_ind |
varchar21 |
0 |
1 |
Indicates if an item is perishable. |
NA |
NA |
NA |
NA |
NA |
NA |
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 |
aip_case_type |
varchar26 |
0 |
1 |
Not used. |
NA |
NA |
NA |
NA |
NA |
NA |
banded_item_ind |
varchar21 |
0 |
1 |
Not used. |
NA |
NA |
NA |
NA |
NA |
NA |
Order_type |
varchar26 |
0 |
1 |
This determines how catch weight items are ordered: F - fixed weight, V - Variable weight. |
NA |
NA |
NA |
NA |
NA |
NA |
Sale_type |
varchar26 |
0 |
1 |
This determines how catch weight items are sold in store locations: V - variable weight each, L - Loose weight. |
NA |
NA |
NA |
NA |
NA |
NA |
Catch_weight_uom |
varchar24 |
0 |
1 |
Unit of measure of a catch weight item. |
NA |
NA |
NA |
NA |
NA |
NA |
Deposit_item_type |
varchar26 |
0 |
1 |
This is the deposit item component type: E - Contents, A - Container, Z - Crate, T - Returned Item (Empty bottle), P - Complex pack (with deposit items). |
NA |
NA |
NA |
NA |
NA |
NA |
Inventory_ind |
varchar21 |
0 |
1 |
This indicates if an item holds inventory or not for item transformation. |
NA |
NA |
NA |
NA |
NA |
NA |
Item_xform_ind |
varchar21 |
0 |
1 |
This indicates if an item is associated with an item transformation process. If yes, the item will be either the sellable item or the orderable item in the transformation process. |
NA |
NA |
NA |
NA |
NA |
NA |
Container_item |
varchar225 |
0 |
1 |
This holds the container item number for a content item. |
NA |
NA |
NA |
NA |
NA |
NA |
package_uom |
varchar24 |
0 |
1 |
Not used. |
NA |
NA |
NA |
NA |
NA |
NA |
ExtOfXItemDesc:ExtOfXItemDesc
|
*
|
0
|
1
|
Provide an extension hook to customize XItemDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfXItemDesc:LocOfXItemDesc
|
*
|
0
|
1
|
Provide an extension hook to localize XItemDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|