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/XItemRef/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:XItemRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemRef
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 The unique identifier for the item. item_master item null null Yes The unique identifier for the item.
hier_level varchar22 0 1 The level of the Organizational Hierarchy of the message. Valid values are; Chain, Area, Region, District n/a n/a varchar2 2 No The level of the Organizational Hierarchy of the message. Valid values are Chain, Area, Region, and District.
XItemCtryRef * 0 unbounded Child node. NA NA NA NA NA NA
XItemSupRef * 0 unbounded Child node.
XItemVATRef * 0 unbounded Child node.
XItemImageRef * 0 unbounded Child node that is not used.
XItemSeasonRef * 0 unbounded Child node that is not used.
XItemUDARef * 0 unbounded Child node that is not used.
XItemBOMRef * 0 unbounded Child node.
system_ind varchar21 0 1 Description is not available. NA NA NA NA NA NA
upc_supplement number5 0 1 Description is not available. NA NA NA NA NA NA
ExtOfXItemRef:ExtOfXItemRef * 0 1 Provide an extension hook to customize XItemRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemRef * 0 1 Provide an extension hook to localize XItemRef. NA NA NA NA NA NA

XML-Schema Name:XItemCtryRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemCtryRef
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
ExtOfXItemRef:ExtOfXItemCtryRef * 0 1 Provide an extension hook to customize XItemCtryRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemCtryRef * 0 1 Provide an extension hook to localize XItemCtryRef. NA NA NA NA NA NA

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

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

XML-Schema Name:XItemSupRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSupRef
Table Name Column Name API Type Column Length API Required API Description
supplier varchar210 1 1 Item Supplier affected by the deletion activity. item_supplier supplier null null Yes Item Supplier affected by the deletion activity.
delete_children_ind varchar21 1 1 Indicates whether the deletion should be applied to all associated item/supplier records below the item level of the item specified on the deletion message. * * null null Yes Indicates whether the deletion should be applied to all associated item/supplier records below the item level of the item specified on the deletion message.
XItemSupCtyRef * 0 unbounded Child node.
XItemSupCtyMfrRef:XItemSupCtyMfrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ExtOfXItemRef:ExtOfXItemSupRef * 0 1 Provide an extension hook to customize XItemSupRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemSupRef * 0 1 Provide an extension hook to localize XItemSupRef. NA NA NA NA NA NA

XML-Schema Name:XItemSupCtyRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSupCtyRef
Table Name Column Name API Type Column Length API Required API Description
origin_country_id varchar23 1 1 The supplier country affected by the deletion activity. item_supp_country origin_country_id null null Yes The supplier country affected by the deletion activity.
XISCLocRef * 0 unbounded Child node
XItemCostRef * 0 unbounded Child node NA NA NA NA NA NA
XISCDimRef * 0 unbounded Child node that is not used.
ExtOfXItemRef:ExtOfXItemSupCtyRef * 0 1 Provide an extension hook to customize XItemSupCtyRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemSupCtyRef * 0 1 Provide an extension hook to localize XItemSupCtyRef. NA NA NA NA NA NA

XML-Schema Name:XISCLocRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XISCLocRef
Table Name Column Name API Type Column Length API Required API Description
hier_id number10 1 1 The id of the location hierarchy level affected by the message. * * null null Yes The ID of the location hierarchy level affected by the message.
ExtOfXItemRef:ExtOfXISCLocRef * 0 1 Provide an extension hook to customize XISCLocRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXISCLocRef * 0 1 Provide an extension hook to localize XISCLocRef. NA NA NA NA NA NA

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

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

XML-Schema Name:XItemCostRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemCostRef
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
ExtOfXItemRef:ExtOfXItemCostRef * 0 1 Provide an extension hook to customize XItemCostRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemCostRef * 0 1 Provide an extension hook to localize XItemCostRef. NA NA NA NA NA NA

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

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

XML-Schema Name:XISCDimRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XISCDimRef
Table Name Column Name API Type Column Length API Required API Description
dim_object varchar26 1 1 This node is not used. * * null null No This node is not used.
ExtOfXItemRef:ExtOfXISCDimRef * 0 1 Provide an extension hook to customize XISCDimRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXISCDimRef * 0 1 Provide an extension hook to localize XISCDimRef. NA NA NA NA NA NA

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

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

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

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

XML-Schema Name:XItemSupCtyMfrRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSupCtyMfrRef
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
ExtOfXItemSupCtyMfrRef:ExtOfXItemSupCtyMfrRef * 0 1 Provide an extension hook to customize XItemSupCtyMfrRef. NA NA NA NA NA NA
LocOfXItemSupCtyMfrRef:LocOfXItemSupCtyMfrRef * 0 1 Provide an extension hook to localize XItemSupCtyMfrRef. NA NA NA NA NA NA

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

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

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

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

XML-Schema Name:XItemVATRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemVATRef
Table Name Column Name API Type Column Length API Required API Description
vat_type varchar21 1 1 The vat type of the vat item info to be deleted. vat_item vat_type null null Yes The VAT type of the VAT item information to be deleted.
vat_region number6 1 1 The vat region of the vat item info to be deleted. vat_item vat_region null null Yes The VAT region of the VAT item information to be deleted.
vat_code varchar26 1 1 The vat code of the vat item info to be deleted. vat_item vat_code null null Yes The VAT code of the VAT item information to be deleted.
active_date xs:dateTime 1 1 The active date of the vat item info to be deleted. vat_item active_date null null Yes The active date of the VAT item information to be deleted.
ExtOfXItemRef:ExtOfXItemVATRef * 0 1 Provide an extension hook to customize XItemVATRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemVATRef * 0 1 Provide an extension hook to localize XItemVATRef. NA NA NA NA NA NA

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

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

XML-Schema Name:XItemImageRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemImageRef
Table Name Column Name API Type Column Length API Required API Description
image_name varchar2120 1 1 This node is not used. * * null null No This node is not used.
ExtOfXItemRef:ExtOfXItemImageRef * 0 1 Provide an extension hook to customize XItemImageRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemImageRef * 0 1 Provide an extension hook to localize XItemImageRef. NA NA NA NA NA NA

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

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

XML-Schema Name:XItemSeasonRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemSeasonRef
Table Name Column Name API Type Column Length API Required API Description
season_id number3 1 1 This node is not used. * * null null No This node is not used.
phase_id number3 1 1 Not used. * * null null No Not used by RMS.
diff_id varchar210 0 1 Not used. * * null null No Not used by RMS.
color number4 0 1 Description is not available. NA NA NA NA NA NA
ExtOfXItemRef:ExtOfXItemSeasonRef * 0 1 Provide an extension hook to customize XItemSeasonRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemSeasonRef * 0 1 Provide an extension hook to localize XItemSeasonRef. NA NA NA NA NA NA

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

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

XML-Schema Name:XItemUDARef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemUDARef
Table Name Column Name API Type Column Length API Required API Description
uda_id number5 1 1 This node is not used. * * null null No This node is not used.
display_type varchar22 1 1 Not used. * * null null No Not used by RMS.
uda_value varchar230 0 1 Not used. * * null null No Not used by RMS.
ExtOfXItemRef:ExtOfXItemUDARef * 0 1 Provide an extension hook to customize XItemUDARef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemUDARef * 0 1 Provide an extension hook to localize XItemUDARef. NA NA NA NA NA NA

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

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

XML-Schema Name:XItemBOMRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XItemBOMRef
Table Name Column Name API Type Column Length API Required API Description
component_item varchar225 1 1 The pack item to be deleted. packitem item null null Yes The pack item to be deleted.
ExtOfXItemRef:ExtOfXItemBOMRef * 0 1 Provide an extension hook to customize XItemBOMRef. NA NA NA NA NA NA
LocOfXItemRef:LocOfXItemBOMRef * 0 1 Provide an extension hook to localize XItemBOMRef. NA NA NA NA NA NA

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

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

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

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