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/MrchHrDeptDesc/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:MrchHrDeptDesc 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 MrchHrDeptDesc 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
dept number4 1 1 Contains the number which uniquely identifies the department. deps dept number 4 Yes Contains the number to uniquely identify the department.
dept_name varchar2120 0 1 Not used by SIM deps dept_name null null Yes Contains the name of the department.
buyer number4 0 1 Contains the number which uniquely identifies the buyer for that department. deps buyer number 4 No Contains the number to uniquely identify the buyer for that department.
purchase_type varchar26 0 1 Contains a code which indicates whether items in this department are normal merchandise or consignment stock. Valid values are:0 = Normal Merchandise1 = Consignment Stock. deps purchase_type null Fill column length. Yes Contains a code to indicate whether items in this department are normal merchandise or consignment stock. Valid values are 0 (normal merchandise) and 1 (consignment stock).
total_market_amt number24_4 0 1 Contains the total market amount that is expected for the department. The field can be used for analytics or reporting. deps total_market_amt number 24 No Contains the total market amount expected for the department. The field can be used for analytics or reporting.
merch number4 0 1 Contains the number which uniquely describes the merchandiser for that department. deps merch number 4 No Contains the number to uniquely describe the merchandiser for that department.
group_no number4 0 1 Contains the number of the group in which the department exists. deps group_no null null Yes Contains the number of the group in which the department exists.
bud_mkup number12_4 0 1 Contains the Budgeted Markup percentage. This term is synonymous with the term Markup Percent of Cost. deps bud_mkup null null Yes Contains the Budgeted Markup percentage (synonymous with Markup Percent of Cost).
profit_calc_type number1 0 1 Contains a number which indicates whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are:1 = Direct Cost, 2 = Retail Inventory deps profit_calc_type null Fill column length. Yes Contains a number to indicate whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are 1 (direct cost) and 2 (retail inventory).
markup_calc_type varchar22 0 1 Contains the code letter which determines how markup is calculated in this department. Valid values are:C = Cost, R = Retail deps markup_calc_type null Fill column length. Yes Contains the code (letter) that determines how markup is calculated in this department. Valid values are C (cost) and R (retail).
otb_calc_type varchar21 0 1 Contains the code letter which determines how OTB is calculated in this department. Valid values are:C = Cost, R = Retail deps otb_calc_type null Fill column length. Yes Contains the code (letter) that determines how OTB is calculated in this department. Valid values are C (cost) and R (retail).
max_avg_counter number5 0 1 A maximum average counter will hold the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is 'Y' (yes) on the system_options table, then this field will be required when maintaining departments online. deps max_avg_counter null null No A maximum average counter contains the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is Y in the system_options table, the field is required when maintaining departments.
avg_tolerance_pct number12_4 0 1 A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data and constrain outliers. This column will hold 70% as 70 - not 0.70. Although not required on the table, if the RPM_ind column deps avg_tolerance_pct number 12 No A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data. This column shows 70% as 70, not 0.70.
bud_int number12_4 0 1 Contains the Budgeted Intake percentage. Budgeted Intake is the percent of total take that is income and is synonymous with the term Markup Percent of Retail. deps bud_int null null Yes Contains the budgeted intake percentage, which is the percent of total take that is income (synonymous with Markup Percent of Retail).
dept_vat_incl_ind varchar21 0 1 This indicator will be be used only to default to the class level indicator when classes are initially set up for the department and will only be available when the system level class vat option is on. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'. deps dept_vat_incl_ind null null Yes This indicator is used only to default to the class level indicator when classes are initially set up for the department and is available only when the system level class VAT option is on. When VAT is turned on in the system and not defined at the class level, the field defaults to Y. When VAT is turned off in the system, the field defaults to N.