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

XML-Schema Name:MrchHrDivDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For MrchHrDivDesc Table Name Column Name API Type Column Length API Required API Description division number4 1 1 Contains the number which uniquely identifies the division of the company. division division number 4 Yes Contains the number to uniquely identify the division of the company. div_name varchar2120 1 1 Contains the name which, along with the division number, identifies the division of the company. division div_name varchar2 120 Yes Contains the name of the division of the company. buyer number4 0 1 Contains the number of the buyer associated with the division. division buyer number 4 No Contains the number of the buyer associated with the division. merch number4 0 1 Contains the number of the merchandiser associated with the division. division merch number 4 No Contains the number of the merchandiser associated with the division. total_market_amt number24_4 0 1 Contains the total market amount that is expected for the division. The field can be used for analytics or reporting. division total_market_amt number 24 No Contains the total market amount expected for the division. The field can be used for analytics or reporting. ExtOfMrchHrDivDesc:ExtOfMrchHrDivDesc * 0 1 Provide an extension hook to customize MrchHrDivDesc. NA NA NA NA NA NA LocOfMrchHrDivDesc:LocOfMrchHrDivDesc * 0 1 Provide an extension hook to localize MrchHrDivDesc. NA NA NA NA NA NA

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

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