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

XML-Schema Name:XItemRef Version:13.1 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, District
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

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

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

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

XML-Schema Name:ExtOfXISCLocRef Version:13.1 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:XISCDimRef Version:13.1 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

XML-Schema Name:ExtOfXISCDimRef Version:13.1 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:ExtOfXItemSupCtyRef Version:13.1 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:XItemSupCtyMfrRef Version:13.1 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

XML-Schema Name:ExtOfXItemSupCtyMfrRef Version:13.1 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:ExtOfXItemSupRef Version:13.1 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:XItemVATRef Version:13.1 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 info 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 info 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 info 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 info to be deleted.
ExtOfXItemRef:ExtOfXItemVATRef * 0 1 Provide an extension hook to customize XItemVATRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemVATRef Version:13.1 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:XItemImageRef Version:13.1 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

XML-Schema Name:ExtOfXItemImageRef Version:13.1 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:XItemSeasonRef Version:13.1 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.
diff_id varchar210 0 1 Not used. * * null null No Not used.
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

XML-Schema Name:ExtOfXItemSeasonRef Version:13.1 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:XItemUDARef Version:13.1 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.
uda_value varchar230 0 1 Not used. * * null null No Not used.
ExtOfXItemRef:ExtOfXItemUDARef * 0 1 Provide an extension hook to customize XItemUDARef. NA NA NA NA NA NA

XML-Schema Name:ExtOfXItemUDARef Version:13.1 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:XItemBOMRef Version:13.1 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

XML-Schema Name:ExtOfXItemBOMRef Version:13.1 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:ExtOfXItemRef Version:13.1 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