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

XML-Schema Name:XOrgHrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrgHrDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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. It cannot be modified. 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. It cannot be modified.
hier_desc varchar2120 1 1 The description of the hierarchy value. chain, area, region, district chain_name, area_name, region_name, district_name null null Yes The description of the hierarchy value.
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 either CH (chain), AR (area), RE (region), or DI (district).
parent_id number10 0 1 The identifier of the hierarchy value's parent hierarchy value. This value must be predefined on either the CHAIN, AREA or REGION table. chain, area, region chain, area, region null CHAIN, AREA, REGION. No The identifier of the hierarchy value's parent hierarchy value. This value must be predefined on one of these tables
mgr_name varchar2120 0 1 The manager name of the hierarchy value. chain, area, region, district mgr_name null null No The manager name of the hierarchy value.
currency_code varchar23 0 1 The code which identifies the currency under which the hierarchy value operates. This value must be predefined on the CURRENCIES table. chain, area, region, district currency_code null null No The code that identifies the currency under which the hierarchy value operates. This value must be predefined in the CURRENCIES table.
XOrgHrLocTrt:XOrgHrLocTrt * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:XOrgHrLocTrt Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrgHrLocTrt in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's 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 on LOC_TRAITS table. A location trait cannot be associated with (or deleted from) a chain.