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

XML-Schema Name:XItemDesc Version:13.1 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 (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

XML-Schema Name:XItemSupDesc Version:13.1 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 who sources the item. This value must be predefined on 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 if the supplier is the primary supplier for the item. Valid values are Y (yes) and N (no).
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.
supp_discontinue_date xs:dateTime 0 1 Not used. * * null null No Not used.
direct_ship_ind varchar21 0 1 Not used. * * null null No Not used.
pallet_name varchar26 0 1 Not used. * * null null No Not used.
case_name varchar26 0 1 Not used. * * null null No Not used.
inner_name varchar26 0 1 Not used. * * null null No Not used.
XItmSupCtyMfrDesc:XItmSupCtyMfrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ExtOfXItemDesc:ExtOfXItemSupDesc * 0 1 Provide an extension hook to customize XItemSupDesc. NA NA NA NA NA NA

XML-Schema Name:XItemSupCtyDesc Version:13.1 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 on 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 This indicates if the country is the primary country for the item\supplier. Valid values are Y (yes) and N (no).
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 will only be used to establish the item\supplier\country unit cost; it cannot be modified.
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.
min_order_qty number12_4 0 1 Not used. * * null null No Not used.
max_order_qty number12_4 0 1 Not used. * * null null No Not used.
supp_hier_lvl_1 varchar210 0 1 Not used. * * null null No Not used.
supp_hier_lvl_2 varchar210 0 1 Not used. * * null null No Not used.
supp_hier_lvl_3 varchar210 0 1 Not used. * * null null No Not used.
default_uop varchar26 0 1 Not used. * * null null No Not used.
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.
ti number12_4 0 1 Not used. * * null null No Not used.
hi number12_4 0 1 Not used. * * null null No Not used.
XISCDimDesc * 0 unbounded Child node that is not used..
ExtOfXItemDesc:ExtOfXItemSupCtyDesc * 0 1 Provide an extension hook to customize XItemSupCtyDesc. NA NA NA NA NA NA

XML-Schema Name:XISCLocDesc Version:13.1 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 with 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 will be used for creating new records, not updating existing records.
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 if the location is the primary location for the item\supplier\country. Valid values are Y (yes) and N (no).
pickup_lead_time number4 0 1 Not used. * * null null No Not used.
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 will be 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

XML-Schema Name:ExtOfXISCLocDesc Version:13.1 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:XISCDimDesc Version:13.1 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

XML-Schema Name:ExtOfXISCDimDesc Version:13.1 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:ExtOfXItemSupCtyDesc Version:13.1 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:XItmSupCtyMfrDesc Version:13.1 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

XML-Schema Name:ExtOfXItmSupCtyMfrDesc Version:13.1 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:ExtOfXItemSupDesc Version:13.1 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:XItemBOMDesc Version:13.1 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 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.
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

XML-Schema Name:ExtOfXItemBOMDesc Version:13.1 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:XItemVATDesc Version:13.1 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 if 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 that 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

XML-Schema Name:ExtOfXItemVATDesc Version:13.1 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:XIZPDesc Version:13.1 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 value used in izp_hier_level field.
base_retail_ind varchar21 0 1 Not used. * * null null No Not used.
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.
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 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.
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

XML-Schema Name:ExtOfXIZPDesc Version:13.1 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:XItemUDADtl Version:13.1 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

XML-Schema Name:ExtOfXItemUDADtl Version:13.1 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:XItemSeason Version:13.1 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

XML-Schema Name:ExtOfXItemSeason Version:13.1 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:XItemImage Version:13.1 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

XML-Schema Name:ExtOfXItemImage Version:13.1 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:ExtOfXItemDesc Version:13.1 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