RIB Mappings Report Release: 13.0.1

Retail Integration Bus Mappings Report Release: 13.0.1

Application Name: Retail Merchandising System

Version 13.0.1

XML-Schema or Node Name:XMrchHrRclsDesc.xsd

Tag Name	Table Name	Column Name	API Req	Description
merch_hier_level	pend_merch_hier	hier_type	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	pend_merch_hier	merch_hier_id	Yes	Contains the merchandise hierarchy ID.
merch_hier_parent_id	pend_merch_hier	merch_hier_parent_id	No	The parent of the hierarchy identified in the merch_hier_id field.
merch_hier_grandparent_id	pend_merch_hier	merch_hier_grandparent_id	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 the subclass belongs to.
merch_hier_name	pend_merch_hier	merch_hier_name	Yes	The name of the hierarchy value.
effective_date	pend_merch_hier	effective_date	Yes	The date the hierarchy change will become effective.
action_type	pend_merch_hier	action_type	No	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.
buyer	pend_merch_hier	buyer	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	pend_merch_hier	purchase_type	No	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.
total_market_amt	pend_merch_hier	total_market_amt	No	The total market amount that is expected for the entity. This field will only be used if the hierarchy value indicates division or department.
merch	pend_merch_hier	merch	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	pend_merch_hier	bud_mkup	No	The budgeted markup percentage. The markup percent of cost. This field will only be used if the hierarchy level indicates department.
profit_calc_type	pend_merch_hier	profit_calc_type	No	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.
markup_calc_type	pend_merch_hier	markup_calc_type	No	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).
otb_calc_type	pend_merch_hier	otb_calc_type	No	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.
max_avg_counter	pend_merch_hier	max_avg_counter	No	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.
avg_tolerance_pct	pend_merch_hier	avg_tolerance_pct	No	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.
bud_int	pend_merch_hier	bud_int	No	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.
dept_vat_incl_ind	pend_merch_hier	dept_vat_incl_ind	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	pend_merch_hier	class_vat_ind	No	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.