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

XML-Schema Name:XMrchHrRclsDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XMrchHrRclsDesc
Table Name Column Name API Type Column Length API Required API Description
merch_hier_level varchar21 1 1 Indicates the level of the merchandise hierarchy. Valid values are V (division), G (group), D (department), C (class), and S (subclass). pend_merch_hier hier_type null null Yes Indicates the level of the merchandise hierarchy. Valid values are V (division), G (group), D (department), C (class), and S (subclass).
merch_hier_id number4 1 1 Contains the merchandise hierarchy ID. pend_merch_hier merch_hier_id null null Yes Contains the merchandise hierarchy ID.
merch_hier_parent_id number4 0 1 The parent of the hierarchy identified in the merch_hier_id field. pend_merch_hier merch_hier_parent_id number 4 No The parent of the hierarchy identified in the merch_hier_id field.
merch_hier_grandparent_id number4 0 1 The grandparent of the hierarchy identified in the merch_hier_id field. This field will only be used when the hierarchy level indicates subclass. It will contain the number of the department the subclass belongs to. pend_merch_hier merch_hier_grandparent_id null null No The grandparent of the hierarchy identified in the merch_hier_id field. This field will only be used when the hierarchy level indicates subclass. It will contain the number of the department to which the subclass belongs.
merch_hier_name varchar2120 1 1 The name of the hierarchy value. pend_merch_hier merch_hier_name varchar2 120 Yes The name of the hierarchy value.
effective_date xs:dateTime 1 1 The date the hierarchy change will become effective. pend_merch_hier effective_date RIBDate * Yes The date the hierarchy change will become effective.
action_type varchar21 0 1 Indicates if this field is an addition or modification. Valid values are A and M. It is required on a create message and should not be populated on a modify message. pend_merch_hier action_type varchar2 1 No Indicates whether the field is an addition or modification. Valid values are A and M. It is required in a create message and should not be populated on a modify message.
buyer number4 0 1 The number of the buyer associated with the entity. This value must be predefined on the BUYER table. This field should only hold a value if the hierarchy level indicates division, group, or department. pend_merch_hier buyer number 4 No The number of the buyer associated with the entity. This value must be predefined on the BUYER table. This field should only hold a value if the hierarchy level indicates division, group, or department.
purchase_type number1 0 1 The code which indicates whether items in the department are normal merchandise (0) or consignment stock (1). This field will only be used if the hierarchy level indicates department. pend_merch_hier purchase_type varchar2 6 No Indicates whether items in the department are normal merchandise (0) or consignment stock (1). This field will be used only if the hierarchy level indicates department.
total_market_amt number24_4 0 1 The total market amount that is expected for the entity. This field will only be used if the hierarchy value indicates division or department. pend_merch_hier total_market_amt number 24 No The total market amount that is expected for the entity. This field only be used only if the hierarchy value indicates division or department.
merch number4 0 1 The number of the merchandiser associated with the entity. This value must be predefined on the MERCHANT table. This field should hold a value only if the hierarchy level indicates division, group, or department. pend_merch_hier merch number 4 No The number of the merchandiser associated with the entity. This value must be predefined on the MERCHANT table. This field should hold a value only if the hierarchy level indicates division, group, or department.
bud_mkup number12_4 0 1 The budgeted markup percentage. The markup percent of cost. This field will only be used if the hierarchy level indicates department. pend_merch_hier bud_mkup number 12 No The budgeted markup percentage. The markup percent of cost. This field will be used only if the hierarchy level indicates department.
profit_calc_type number1 0 1 The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This field will only be used if the hierarchy level indicates department. pend_merch_hier profit_calc_type number 1 No Indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This field will be used only if the hierarchy level indicates department.
markup_calc_type varchar22 0 1 The code letter which indicates how markup is calculated in the department. This field will only be used if the hierarchy level indicates department. Valid values are C (cost) and R (retail). pend_merch_hier markup_calc_type varchar2 2 No The code letter which indicates how markup is calculated in the department. This field will be used only if the hierarchy level indicates department. Valid values are C (cost) and R (retail).
otb_calc_type varchar21 0 1 The code letter which indicates how OTB is calculated in the department. Valid values are cost (C) and retail (R). This field will only be used if the hierarchy value indicates department. pend_merch_hier otb_calc_type varchar2 1 No The code (letter) that indicates how OTB is calculated in the department. Valid values are cost (C) and retail (R). This field will be used only if the hierarchy value indicates department.
max_avg_counter number5 0 1 The maximum count of days with acceptable data to include in an average for items with the department. This field will only be used if the hierarchy level indicates department. It is required if RPM is installed. pend_merch_hier max_avg_counter number 5 No The maximum count of days with acceptable data to include in an average for items with the department. This field will be used only if the hierarchy level indicates department. It is required if RPM is installed.
avg_tolerance_pct number12_4 0 1 The tolerance percentage value used in averaging for items within this value. This column will hold 70% as 70, not .70. This field will only be used if the hierarchy value indicates department. It is required if RPM is installed. pend_merch_hier avg_tolerance_pct number 12 No The tolerance percentage value used in averaging for items within this value. This column will show 70% as 70, not .70. This field will only be used if the hierarchy value indicates department. It is required if RPM is installed.
bud_int number12_4 0 1 The budgeted intake percentage. The percent of the total take that is income. This field will only be used if the hierarchy value indicates department. pend_merch_hier bud_int number 12 No The budgeted intake percentage. The percentage of the total take that is income. This field will be used only if the hierarchy value indicates department.
dept_vat_incl_ind varchar21 0 1 Indicates the default value for the class VAT indicator. When classes are initially set up they will inherit this value. This field will only be populated when the hierarchy level indicates department. pend_merch_hier dept_vat_incl_ind varchar2 1 No Indicates the default value for the class VAT indicator. When classes are initially set up they will inherit this value. This field will only be populated when the hierarchy level indicates department.
class_vat_ind varchar21 0 1 Indicates if retail is displayed and held with or without VAT for items within a class. Valid values are Y (yes) and N (no). This field will only be used if the hierarchy level indicates class. pend_merch_hier class_vat_ind varchar2 1 No Indicates whether retail is displayed and held with or without VAT for items within a class. Valid values are Y and N. This field will be used only if the hierarchy level indicates class.
ExtOfXMrchHrRclsDesc:ExtOfXMrchHrRclsDesc * 0 1 Provide an extension hook to customize XMrchHrRclsDesc. NA NA NA NA NA NA
LocOfXMrchHrRclsDesc:LocOfXMrchHrRclsDesc * 0 1 Provide an extension hook to localize XMrchHrRclsDesc. NA NA NA NA NA NA

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

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