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

XML-Schema Name:XOrgHrRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XOrgHrRef
Table Name Column Name API Type Column Length API Required API Description
hier_value number10 1 1 The identifier of the hierarchy value. This value must be unique among other values of the same hierarchy level. chain, area, region, district chain, area, region, district null null Yes The identifier of the hierarchy value. This value must be unique among other values of the same hierarchy level.
hier_level varchar22 1 1 Value is restricted by message type. The value will indicate either CH (chain), AR (area), RE (region), or DI (district). n/a n/a null null Yes Value is restricted by message type. The value will indicate CH (chain), AR (area), RE (region), or DI (district).
XOrgHrLocTrt:XOrgHrLocTrt * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ExtOfXOrgHrRef:ExtOfXOrgHrRef * 0 1 Provide an extension hook to customize XOrgHrRef. NA NA NA NA NA NA
LocOfXOrgHrRef:LocOfXOrgHrRef * 0 1 Provide an extension hook to localize XOrgHrRef. NA NA NA NA NA NA

XML-Schema Name:XOrgHrLocTrt Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XOrgHrLocTrt
Table Name Column Name API Type Column Length API Required API Description
hier_trait_id number4 1 1 The location trait associated to the hierarchy value. This value must be predefined on LOC_TRAITS table. A location trait cannot be associated with (or deleted from) a chain. loc_area_traits, loc_region_traits, loc_district_traits loc_trait null null Yes The location trait associated to the hierarchy value. This value must be predefined in the LOC_TRAITS table. A location trait cannot be associated with (or deleted from) a chain.
ExtOfXOrgHrLocTrt:ExtOfXOrgHrLocTrt * 0 1 Provide an extension hook to customize XOrgHrLocTrt. NA NA NA NA NA NA
LocOfXOrgHrLocTrt:LocOfXOrgHrLocTrt * 0 1 Provide an extension hook to localize XOrgHrLocTrt. NA NA NA NA NA NA

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

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

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

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