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 (yes) and N (no). 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 this 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 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. |
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 on 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), 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 will be defaulted to EA (eaches) if not populated on 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 value are Y (yes) and N (no). This 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 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. |
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 (yes) if the item is a pack and at least one component item is a pack; otherwise it should be N (no). |
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 (yes) and N (no). 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 (yes) and N (no). 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 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. |
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 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 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. |
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. |
uom_conv_factor |
number20_10 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
package_size |
number12_4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
handling_temp |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
handling_sensitivity |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
mfg_rec_retail |
number20_4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
waste_type |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
waste_pct |
number12_4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
item_number_type |
varchar26 |
0 |
1 |
This type can hold a number of digits count umber_type. |
* |
* |
null |
null |
No |
Not used. |
catch_weight_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
const_dimen_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
gift_wrap_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
ship_alone_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
ext_source_system |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
size_group1 |
number4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
size_group2 |
number4 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
size1 |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
size2 |
varchar26 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
color |
varchar224 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
system_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
upc_supplement |
number5 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
upc_type |
varchar25 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
primary_upc_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
primary_repl_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
item_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
diff_1_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
diff_2_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
diff_3_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
diff_4_aggregate_ind |
varchar21 |
0 |
1 |
Not used. |
* |
* |
null |
null |
No |
Not used. |
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 |
ExtOfXItemDesc:ExtOfXItemDesc
|
*
|
0
|
1
|
Provide an extension hook to customize XItemDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|