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

XML-Schema Name:XMrchHrDeptDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XMrchHrDeptDesc
Table Name Column Name API Type Column Length API Required API Description
dept number4 1 1 The number which uniquely identifies the department. This value cannot be modified. deps dept number 4 Yes The number which uniquely identifies the department. This value cannot be modified.
dept_name varchar2120 1 1 The name of the department. deps dept_name varchar2 120 Yes The name of the department.
buyer number4 0 1 The number of the buyer associated to the department. This value must be predefined on the BUYER table. deps buyer number 4 No The number of the buyer associated to the department. This value must be predefined on the BUYER table.
purchase_type number1 1 1 The code which indicates whether items in this department are normal merchandise (0) or consignment stock (1). This field cannot be modified. deps purchase_type varchar2 6 Yes The code which indicates whether items in this department are normal merchandise (0) or consignment stock (1). This field cannot be modified.
total_market_amt number24_4 0 1 The total market amount that is expected for the department. This value cannot be less than 1000. deps total_market_amt number 24 No The total market amount that is expected for the department. This value cannot be less than 1000.
merch number4 0 1 The number of the merchandiser that is associated to the department. This value must be predefined on the MERCHANT table. deps merch number 4 No The number of the merchandiser that is associated to the department. This value must be predefined on the MERCHANT table.
group_no number4 1 1 The number of the group to which the department belongs. This value must be predefined on the GROUPS table. deps group_no number 4 Yes The number of the group to which the department belongs. This value must be predefined on the GROUPS table.
bud_mkup number12_4 0 1 The budgeted markup percentage. The markup percent of cost. If this value is not populated on the message it will be calculated to be the inverse of the budgeted intake percentage. This column will hold 70% as 70, not .70. deps bud_mkup number 12 No The budgeted markup percentage. The markup percent of cost. If this value is not populated on the message it will be calculated to be the inverse of the budgeted intake percentage. This column will hold 70% as 70, not .70.
profit_calc_type number1 1 1 The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This value cannot be modified. deps profit_calc_type number 1 Yes The number which indicates whether profit will be calculated by direct cost (1) or retail inventory (2). This value cannot be modified.
markup_calc_type varchar22 1 1 The code letter that indicates how markup is calculated in this department. Valid values are cost (C) and retail (R). deps markup_calc_type varchar2 2 Yes The code letter that indicates how markup is calculated in this department. Valid values are cost (C) and retail (R).
otb_calc_type varchar21 0 1 The code letter which indicates how OTB is calculated for this department. Valid values are cost (C) and retail (R). This value cannot be modified. deps otb_calc_type varchar2 1 Yes The code letter which indicates how OTB is calculated for this department. Valid values are cost (C) and retail (R). This value cannot be modified.
max_avg_counter number5 0 1 The maximum count of days with acceptable data to include in an average for items within the department. This value is required if RPM is installed. deps max_avg_counter number 5 No The maximum count of days with acceptable data to include in an average for items within the department. This value 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 value is required if RPM is installed. deps avg_tolerance_pct number 12 No The tolerance percentage value used in averaging for items within this value. This column will hold 70% as 70, not .70. This value 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. If this field is not populated on the message it will be calculated as the inverse of the budgeted markup percentage. This column will hold 70% as 70, not .70. deps bud_int number 12 No The budgeted intake percentage. The percent of the total take that is income. If this field is not populated on the message it will be calculated as the inverse of the budgeted markup percentage. This column will hold 70% as 70, not .70.
XMrchHrDeptVAT * 0 unbounded Description is not available.
ExtOfXMrchHrDeptDesc:ExtOfXMrchHrDeptDesc * 0 1 Provide an extension hook to customize XMrchHrDeptDesc. NA NA NA NA NA NA

XML-Schema Name:XMrchHrDeptVAT Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XMrchHrDeptVAT
Table Name Column Name API Type Column Length API Required API Description
vat_region number4 1 1 The number of the VAT region to which this department is associated. This value must be predefined on the VAT_REGION table. vat_deps vat_region null null Yes The number of the VAT region to which this department is associated. This value must be predefined on the VAT_REGION table.
vat_code varchar26 1 1 The alphanumeric identifier of the VAT code. This value must be predefined on the VAT_CODES table. vat_deps vat_code null null Yes The alphanumeric identifier of the VAT code. This value must be predefined on the VAT_CODES table.
vat_type varchar21 1 1 Indicates if the VAT rate is used for purchasing (C), selling (R), or both (B). vat_deps vat_type null null Yes Indicates if the VAT rate is used for purchasing (C), selling (R), or both (B).
ExtOfXMrchHrDeptDesc:ExtOfXMrchHrDeptVAT * 0 1 Provide an extension hook to customize XMrchHrDeptVAT. NA NA NA NA NA NA

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

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