Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/XItemDesc/v1
Version 1.3
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:XItemDesc Version:13.2.0 Return to Top
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

XML-Schema Name:XItemCtryDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemCtryDesc
Table Name Column Name API Type Column Length API Required API Description
country_id varchar23 1 1 Id of the country associated with the item. NA NA NA NA NA NA
ExtOfXItemDesc:ExtOfXItemCtryDesc * 0 1 Provide an extension hook to customize XItemCtryDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemCtryDesc * 0 1 Provide an extension hook to localize XItemCtryDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemCtryDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemCtryDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemCtryDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemCtryDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemCtryDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemCtryDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemSupDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSupDesc
Table Name Column Name API Type Column Length API Required API Description
supplier varchar210 1 1 The identifier of the supplier who sources the item. This value must be predefined on the SUPS table. item_supplier supplier varchar2 10 Yes The identifier of the supplier that sources the item. This value must be predefined in the SUPS table.
primary_supp_ind varchar23 1 1 Indicates if the supplier is the primary supplier for the item. Valid values are Y (yes) and N (no). item_supplier primary_supp_ind varchar2 3 Yes Indicates whether the supplier is the primary supplier for the item. Valid values are Y and N.
vpn varchar230 0 1 The vendor product number associated with the item. item_supplier vpn varchar2 30 No The vendor product number associated with the item.
supp_label varchar215 0 1 The supplier label for the item. item_supplier supp_label varchar2 15 No The supplier label for the item.
XItemSupCtyDesc * 0 unbounded Child node.
consignment_rate number12_4 0 1 Not used. * * null null No Not used by RMS.
supp_discontinue_date xs:dateTime 0 1 Not used. * * null null No Not used by RMS.
direct_ship_ind varchar21 0 1 Not used. * * null null No Not used by RMS.
pallet_name varchar26 0 1 Not used. * * null null No Not used by RMS.
case_name varchar26 0 1 Not used. * * null null No Not used by RMS.
inner_name varchar26 0 1 Not used. * * null null No Not used by RMS.
XItmSupCtyMfrDesc:XItmSupCtyMfrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
primary_case_size varchar26 0 1 Not used. NA NA NA NA NA NA
ExtOfXItemDesc:ExtOfXItemSupDesc * 0 1 Provide an extension hook to customize XItemSupDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemSupDesc * 0 1 Provide an extension hook to localize XItemSupDesc. NA NA NA NA NA NA

XML-Schema Name:XItemSupCtyDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSupCtyDesc
Table Name Column Name API Type Column Length API Required API Description
origin_country_id varchar23 1 1 The identifier for the country where the item is sourced. This value must be predefined on the COUNTRY table. item_supp_country origin_country_id null null Yes The identifier for the country where the item is sourced. This value must be predefined in the COUNTRY table.
primary_country_ind varchar21 1 1 This indicates if the country is the primary country for the item\supplier. Valid values are Y (yes) and N (no). item_supp_country primary_country_ind varchar2 1 Yes Indicates whether the country is the primary country for the item\supplier. Valid values are Y and N.
unit_cost number20_4 0 1 The current corporate unit cost for the item in the supplier's currency. This field will only be used to establish the item\supplier\country unit cost; it cannot be modified. item_supp_country unit_cost null null No The current corporate unit cost for the item in the supplier's currency. This field is used only to establish the item\supplier\country unit cost; it cannot be modified.
XItemCostDesc * 0 unbounded Child node. NA NA NA NA NA NA
XISCLocDesc * 0 unbounded Child node.
lead_time number4 0 1 Not used. * * null null No Not used.
pickup_lead_time number4 0 1 Not used. * * null null No Not used by RMS.
min_order_qty number12_4 0 1 Not used. * * null null No Not used by RMS.
max_order_qty number12_4 0 1 Not used. * * null null No Not used by RMS.
supp_hier_lvl_1 varchar210 0 1 Not used. * * null null No Not used by RMS.
supp_hier_lvl_2 varchar210 0 1 Not used. * * null null No Not used by RMS.
supp_hier_lvl_3 varchar210 0 1 Not used. * * null null No Not used by RMS.
default_uop varchar26 0 1 Not used. * * null null No Not used by RMS.
supp_pack_size number12_4 0 1 Not used. * * null null No Not used.
inner_pack_size number12_4 0 1 Not used. * * null null No Not used by RMS.
ti number12_4 0 1 Not used. * * null null No Not used by RMS.
hi number12_4 0 1 Not used. * * null null No Not used by RMS.
XISCDimDesc * 0 unbounded Child node that is not used.
Cost_uom varchar24 0 1 Unit of measure associated with the item cost. It is held to allow costs to be managed in a separate UOM from the standard UOM. NA NA NA NA NA NA
Tolerance_type varchar26 0 1 The unit of the tolerances for catch weight simple packs: A - actual, P - percent. NA NA NA NA NA NA
Min_tolerance number12_4 0 1 The minimum tolerance value for a catch weight simple pack. NA NA NA NA NA NA
Max_Tolerance number12_4 0 1 The maximum tolerance value for a catch weight simple pack. NA NA NA NA NA NA
ExtOfXItemDesc:ExtOfXItemSupCtyDesc * 0 1 Provide an extension hook to customize XItemSupCtyDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemSupCtyDesc * 0 1 Provide an extension hook to localize XItemSupCtyDesc. NA NA NA NA NA NA

XML-Schema Name:XItemCostDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemCostDesc
Table Name Column Name API Type Column Length API Required API Description
delivery_country_id varchar23 1 1 Country where the Item will be delivered. NA NA NA NA NA NA
primary_dlvy_ctry_ind varchar21 1 1 Indicates if the country is the primary delivery country of the item. NA NA NA NA NA NA
nic_static_ind varchar21 1 1 Indicates if the Negotiated Item Cost (NIC) is static or not. If NIC is static, then the Base Cost of the item will vary based on the location/tax region; if NIC is not static, then NIC will vary based on the location/tax region. NA NA NA NA NA NA
base_cost number20_4 1 1 This will hold the tax exclusive cost of the item. NA NA NA NA NA NA
negotiated_item_cost number20_4 1 1 This will hold the supplier negotiated item cost. NA NA NA NA NA NA
extended_base_cost number20_4 1 1 This will hold the extended base cost of the item. Extended base cost is the cost inclusive of all the taxes that affect the Weighted Average Cost (WAC). NA NA NA NA NA NA
inclusive_cost number20_4 1 1 This will hold the tax-inclusive cost of the item. This includes both the recoverable and non-recoverable taxes. NA NA NA NA NA NA
ExtOfXItemDesc:ExtOfXItemCostDesc * 0 1 Provide an extension hook to customize XItemCostDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemCostDesc * 0 1 Provide an extension hook to localize XItemCostDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemCostDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemCostDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemCostDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemCostDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemCostDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemCostDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XISCLocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XISCLocDesc
Table Name Column Name API Type Column Length API Required API Description
hier_id number10 1 1 The specific location id for this Item Supplier Country Loc message. Corresponds with the value used in the iscloc_hier_level field. item_supp_country_loc loc null null Yes The specific location ID for this Item Supplier Country Loc message. Corresponds to the value used in the iscloc_hier_level field.
unit_cost number20_4 0 1 The unit cost for the item at the item\supplier\country\loc level in the supplier's currency. This field will be used for creating new records, not updating existing records. item_supp_country_loc unit_cost number 20 No The unit cost for the item at the item\supplier\country\loc level in the supplier's currency. This field is used for creating new records, not updating existing records.
nic_static_ind varchar21 0 1 Indicates if the Negotiated Item Cost (NIC) is static or not. If NIC is static, then the Base Cost of the item will vary based on the location/tax region; if NIC is not static, then NIC will vary based on the location/tax region. NA NA NA NA NA NA
negotiated_item_cost number20_4 0 1 This will hold the supplier negotiated item cost. NA NA NA NA NA NA
extended_base_cost number20_4 0 1 This will hold the extended base cost of the item. Extended base cost is the cost inclusive of all the taxes that affect the Weighted Average Cost (WAC). NA NA NA NA NA NA
inclusive_cost number20_4 0 1 This will hold the tax-inclusive cost of the item. This includes both the recoverable and non-recoverable taxes. NA NA NA NA NA NA
primary_loc_ind varchar21 0 1 Indicates if the location is the primary location for the item\supplier\country. Valid values are Y (yes) and N (no). item_supp_country_loc primary_loc_ind varchar2 1 No Indicates whether the location is the primary location for the item\supplier\country. Valid values are Y and N.
pickup_lead_time number4 0 1 Not used. * * null null No Not used by RMS.
round_lvl varchar26 0 1 This column will be used to determine how order quantities will be rounded to Case, Layer and Pallet. item_supp_country_loc round_lvl varchar2 6 No This column is used to determine how order quantities will be rounded to case, layer, and pallet.
round_to_case_pct number12_4 0 1 The Case Rounding Threshold value. Used to determine whether to round partial case quantities up or down. item_supp_country_loc round_to_case_pct null null No The Case Rounding Threshold value. Used to determine whether to round partial case quantities up or down.
round_to_layer_pct number12_4 0 1 The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down. item_supp_country_loc round_to_layer_pct null null No The Layer Rounding Threshold value. Used to determine whether to round partial Layer quantities up or down.
round_to_pallet_pct number12_4 0 1 The Pallet Rounding Threshold value. Used to determine whether to round partial Pallet quantities up or down. item_supp_country_loc round_to_pallet_pct null null No The Pallet Rounding Threshold value. Used to determine whether to round partial pallet quantities up or down.
ExtOfXItemDesc:ExtOfXISCLocDesc * 0 1 Provide an extension hook to customize XISCLocDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXISCLocDesc * 0 1 Provide an extension hook to localize XISCLocDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXISCLocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXISCLocDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXISCLocDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXISCLocDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXISCLocDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXISCLocDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XISCDimDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XISCDimDesc
Table Name Column Name API Type Column Length API Required API Description
dim_object varchar26 1 1 This entire node is not used. * * null null No This entire node is not used.
tare_weight number12_4 0 1 Description is not available. * * number 12 * *
tare_type varchar26 0 1 Description is not available. * * varchar2 6 * *
lwh_uom varchar24 0 1 Description is not available. * * varchar2 4 * *
length number12_4 0 1 Description is not available. * * number 12 * *
width number12_4 0 1 Description is not available. * * number 12 * *
dim_height number12_4 0 1 Description is not available. * * number 12 * *
liquid_volume number12_4 0 1 Description is not available. * * number 12 * *
liquid_volume_uom varchar24 0 1 Description is not available. * * varchar2 4 * *
stat_cube varchar212 0 1 Description is not available. * * varchar2 12 * *
weight_uom varchar24 0 1 Description is not available. * * varchar2 4 * *
weight number12_4 0 1 Description is not available. * * number 12 * *
net_weight varchar212 0 1 Description is not available. * * varchar2 12 * *
presentation_method varchar26 0 1 Description is not available. * * varchar2 6 * *
ExtOfXItemDesc:ExtOfXISCDimDesc * 0 1 Provide an extension hook to customize XISCDimDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXISCDimDesc * 0 1 Provide an extension hook to localize XISCDimDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXISCDimDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXISCDimDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXISCDimDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXISCDimDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXISCDimDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXISCDimDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemSupCtyDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemSupCtyDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemSupCtyDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemSupCtyDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemSupCtyDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemSupCtyDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItmSupCtyMfrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItmSupCtyMfrDesc
Table Name Column Name API Type Column Length API Required API Description
manufacturer_ctry_id varchar23 1 1 Country ID of manufacturer. NA NA NA NA NA NA
primary_manufacturer_ctry_ind varchar21 1 1 Indicates if it's the primary country of manufacturer. NA NA NA NA NA NA
ExtOfXItmSupCtyMfrDesc:ExtOfXItmSupCtyMfrDesc * 0 1 Provide an extension hook to customize XItmSupCtyMfrDesc. NA NA NA NA NA NA
LocOfXItmSupCtyMfrDesc:LocOfXItmSupCtyMfrDesc * 0 1 Provide an extension hook to localize XItmSupCtyMfrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItmSupCtyMfrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItmSupCtyMfrDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItmSupCtyMfrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItmSupCtyMfrDesc
Table Name Column Name API Type Column Length API Required API Description
InXItmSupCtyMfrDesc:InXItmSupCtyMfrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItmSupCtyMfrDesc:BrXItmSupCtyMfrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemSupDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemSupDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemSupDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemSupDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemSupDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemSupDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemBOMDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemBOMDesc
Table Name Column Name API Type Column Length API Required API Description
component_item varchar225 1 1 The component item within the pack. This value must be predefined on ITEM_MASTER. It will only be populated if the item on the message is a pack item. This value cannot be modified. Only transaction level items can be pack components. packitem item null null Yes The component item within the pack. This value must be predefined on ITEM_MASTER. It is populated onliy if the item on the message is a pack item. This value cannot be modified. Only transaction level items can be pack components.
pack_qty number12_4 1 1 The quantity of the component item. This value cannot be modified. packitem pack_qty null null Yes The quantity of the component item. This value cannot be modified.
ExtOfXItemDesc:ExtOfXItemBOMDesc * 0 1 Provide an extension hook to customize XItemBOMDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemBOMDesc * 0 1 Provide an extension hook to localize XItemBOMDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemBOMDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemBOMDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemBOMDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemBOMDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemBOMDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemBOMDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemVATDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemVATDesc
Table Name Column Name API Type Column Length API Required API Description
vat_type varchar21 1 1 Indicates if the VAT rate is used for purchasing or selling. Valid values are C (cost) and R (retail). vat_item vat_type null null Yes Indicates whether the VAT rate is used for purchasing or selling. Valid values are C (cost) and R (retail).
vat_region number6 1 1 The identifier for the VAT region. This value must be predefined on the VAT_REGION table. This node is optional, if it is included this field is required. vat_item vat_region null null Yes The identifier for the VAT region. This value must be predefined on the VAT_REGION table. This node is optional. If it is included, this field is required.
vat_code varchar26 1 1 The identifier for the VAT code. This node is optional, if it is included in the message this field is required. vat_item vat_code null null Yes The identifier for the VAT code. This node is optional. If it is included in the message, this field is required.
active_date xs:dateTime 1 1 The date that the VAT rate became active for the item/VAT region combination. vat_item active_date null null Yes The date on which the VAT rate became active for the item/VAT region combination.
ExtOfXItemDesc:ExtOfXItemVATDesc * 0 1 Provide an extension hook to customize XItemVATDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemVATDesc * 0 1 Provide an extension hook to localize XItemVATDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemVATDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemVATDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemVATDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemVATDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemVATDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemVATDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XIZPDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XIZPDesc
Table Name Column Name API Type Column Length API Required API Description
hier_id number10 1 1 The specific hierarchy id for this Item Zone Price message. Corresponds with value used in izp_hier_level field. * * null null Yes The specific hierarchy ID for this Item Zone Price message. Corresponds with the value used in the izp_hier_level field.
base_retail_ind varchar21 0 1 Not used. * * null null No Not used by RMS.
selling_unit_retail number20_4 1 1 The selling unit retail value in the currency and the selling UOM on the message. This field cannot be modified. rpm_item_zone_price selling_retail null null Yes The selling unit retail value in the currency and the selling UOM on the message. This field cannot be modified.
selling_uom varchar24 1 1 The selling unit of measure for the item's single unit retail. This field cannot be modified. rpm_item_zone_price selling_uom null null Yes The selling unit of measure for the item's single unit retail. This field cannot be modified.
multi_selling_uom varchar24 0 1 The selling unit of measure for the item's multi unit retail. This field cannot be modified. rpm_item_zone_price multi_selling_uom null null No The selling unit of measure for the item's multi unit retail. This field cannot be modified.
country_id varchar23 0 1 Not used. * * null null No Not used by RMS.
currency_code varchar23 1 1 The code of the currency the retail value and zones are in. Item\zone\price records will only be created for stores with the same currency as the retail value on the message. * * null null No The code for retail value and zone currency. Item\zone\price records are created for stores with the same currency as the retail value in the message.
multi_units number12_4 0 1 The multi units for the item\zone. This field cannot be modified. rpm_item_zone_price multi_units null null No The multi units for the item\zone. This field cannot be modified.
multi_unit_retail number20_4 0 1 The multi unit retail in the currency and the multi unit UOM specified on the message. This field cannot be modified. rpm_item_zone_price multi_unit_retail null null No The multi unit retail in the currency and the multi unit UOM specified on the message. This field cannot be modified.
ExtOfXItemDesc:ExtOfXIZPDesc * 0 1 Provide an extension hook to customize XIZPDesc. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXIZPDesc * 0 1 Provide an extension hook to localize XIZPDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfXIZPDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXIZPDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXIZPDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXIZPDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXIZPDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXIZPDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemUDADtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemUDADtl
Table Name Column Name API Type Column Length API Required API Description
uda_id number5 1 1 This entire node is not used. * * null null No This entire node is not used.
display_type varchar22 1 1 Description is not available. * * varchar2 2 * *
uda_date xs:dateTime 0 1 Description is not available. * * RIBDate * * *
uda_value varchar230 0 1 Description is not available. * * varchar2 30 * *
uda_text varchar2250 0 1 Description is not available. * * varchar2 250 * *
create_datetime xs:dateTime 0 1 Description is not available. * * RIBDate * * *
last_update_datetime xs:dateTime 0 1 Description is not available. * * RIBDate * * *
last_update_id varchar230 0 1 Description is not available. * * varchar2 30 * *
ExtOfXItemDesc:ExtOfXItemUDADtl * 0 1 Provide an extension hook to customize XItemUDADtl. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemUDADtl * 0 1 Provide an extension hook to localize XItemUDADtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemUDADtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemUDADtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemUDADtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemUDADtl
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemUDADtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemUDADtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemSeason Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSeason
Table Name Column Name API Type Column Length API Required API Description
season_id number3 1 1 This entire node is not used. * * null null No This entire node is not used.
phase_id number3 1 1 Description is not available. * * number 3 * *
item_season_seq_no number4 0 1 Description is not available. * * number 4 * *
diff_id varchar210 0 1 Description is not available. * * varchar2 10 * *
create_datetime xs:dateTime 0 1 Description is not available. * * RIBDate * * *
last_update_datetime xs:dateTime 0 1 Description is not available. * * RIBDate * * *
last_update_id varchar230 0 1 Description is not available. * * varchar2 30 * *
color number4 0 1 Description is not available. NA NA NA NA NA NA
ExtOfXItemDesc:ExtOfXItemSeason * 0 1 Provide an extension hook to customize XItemSeason. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemSeason * 0 1 Provide an extension hook to localize XItemSeason. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemSeason Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemSeason
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemSeason Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemSeason
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemSeason * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemSeason * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:XItemImage Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemImage
Table Name Column Name API Type Column Length API Required API Description
image_name varchar2120 1 1 This entire node is not used. * * null null No This entire node is not used.
image_addr varchar2255 1 1 Description is not available. * * varchar2 255 * *
image_desc varchar240 1 1 Description is not available. * * varchar2 40 * *
create_datetime xs:dateTime 0 1 Description is not available. * * RIBDate * * *
last_update_datetime xs:dateTime 0 1 Description is not available. * * RIBDate * * *
last_update_id varchar230 0 1 Description is not available. * * varchar2 30 * *
ExtOfXItemDesc:ExtOfXItemImage * 0 1 Provide an extension hook to customize XItemImage. NA NA NA NA NA NA
LocOfXItemDesc:LocOfXItemImage * 0 1 Provide an extension hook to localize XItemImage. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemImage Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemImage
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemImage Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemImage
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemImage * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemImage * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfXItemDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfXItemDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfXItemDesc
Table Name Column Name API Type Column Length API Required API Description
InXItemDesc:InXItemDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrXItemDesc:BrXItemDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA