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

XML-Schema Name:XMrchHrDivDesc Version:13.2.0 Return to Top Tag Name Type Min Occurs Max Occurs Description rms Mapping For XMrchHrDivDesc Table Name Column Name API Type Column Length API Required API Description division number4 1 1 The unique identifier of the division. This field cannot be modified. division division number 4 Yes The unique identifier of the division. This field cannot be modified. div_name varchar2120 1 1 The name of the division. division div_name varchar2 120 Yes The name of the division. merch number4 0 1 The number of the merchant associated with the division. This value must be predefined on the MERCHANT table. division merch number 4 No The number of the merchant associated with the division. This value must be predefined on the MERCHANT table. buyer number4 0 1 The number of the buyer associated with the division. This value must be predefined on the BUYER table. division buyer number 4 No The number of the buyer associated with the division. This value must be predefined on the BUYER table. total_market_amt number24_4 0 1 The total market amount that is expected for the division. If this field is not null it must be at least 1000. division total_market_amt number 24 No The total market amount that is expected for the division. If this field is not null it must be at least 1000. ExtOfXMrchHrDivDesc:ExtOfXMrchHrDivDesc * 0 1 Provide an extension hook to customize XMrchHrDivDesc. NA NA NA NA NA NA LocOfXMrchHrDivDesc:LocOfXMrchHrDivDesc * 0 1 Provide an extension hook to localize XMrchHrDivDesc. NA NA NA NA NA NA

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

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