 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:XOrgHrDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| hier_value | chain, area, region, district | chain, area, region, district | 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 | chain, area, region, district | chain_name, area_name, region_name, district_name | Yes | The description of the hierarchy value. |
| hier_level | n/a | n/a | Yes | Value is restricted by message type. The value will indicate either CH (chain), AR (area), RE (region), or DI (district). |
| parent_id | chain, area, region | chain, area, region | No | The identifier of the hierarchy value's parent hierarchy value. This value must be predefined on either the CHAIN, AREA or REGION table. |
| mgr_name | chain, area, region, district | mgr_name | No | The manager name of the hierarchy value. |
| currency_code | chain, area, region, district | currency_code | No | The code which identifies the currency under which the hierarchy value operates. This value must be predefined on the CURRENCIES table. |
| XOrgHrLocTrt | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:XOrgHrLocTrt |
| Tag Name | Table Name | Column Name | API Req | Description |
| hier_trait_id | loc_area_traits, loc_region_traits, loc_district_traits | loc_trait | 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. |