Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:MrchHrDeptDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For MrchHrDeptDesc
Table Name Column Name API Type Column Length API Required API Description
dept number4 1 1 Contains the number which uniquely identifies the department. deps dept number 4 Yes Contains the number which uniquely identifies 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 which uniquely identifies 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 null Yes Contains a code which indicates whether items in this department are normal merchandise or consignment stock. Valid values are:0 = Normal Merchandise1 = 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 that is 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 which uniquely describes 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. This term is synonymous with the term 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 null Yes 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
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 null Yes Contains the code letter which determines how markup is calculated in this department. Valid values are:C = Cost, 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 null Yes Contains the code letter which determines how OTB is calculated in this department. Valid values are:C = Cost, 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 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.
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 and constrain outliers. This column will hold 70% as 70 - not 0.70. Although not required on the table, if the RPM_ind column
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. Budgeted Intake is the percent of total take that is income and is synonymous with the term 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 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'.
ExtOfMrchHrDeptDesc:ExtOfMrchHrDeptDesc * 0 1 Provide an extension hook to customize MrchHrDeptDesc. NA NA NA NA NA NA

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