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

XML-Schema Name:XMrchHrCompDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XMrchHrCompDesc
Table Name Column Name API Type Column Length API Required API Description
company number4 1 1 The unique number which identifies the company for which the system is running. This value cannot be modified. comphead company number 4 Yes The unique number which identifies the company for which the system is running. This value cannot be modified.
company_name varchar2120 1 1 The name of the company for which the system is running. comphead co_name varchar2 120 Yes The name of the company for which the system is running.
add_1 varchar2240 1 1 The first line of the company headquarters address. comphead co_add1 varchar2 240 Yes The first line of the company headquarters address.
add_2 varchar2240 0 1 The second line of the company headquarters address. comphead co_add2 varchar2 240 No The second line of the company headquarters address.
add_3 varchar2240 0 1 The third line of the company headquarters address. comphead co_add3 varchar2 240 No The third line of the company headquarters address.
city varchar2120 1 1 The city the company headquarters. comphead co_city varchar2 120 Yes The city the company headquarters.
state varchar23 0 1 The abbreviation of the state of the company headquarters. This value must be predefined on the STATE table. comphead co_state varchar2 3 No The abbreviation of the state of the company headquarters. This value must be predefined on the STATE table.
country_code varchar23 1 1 The abbreviation of the country of the company headquarters. This value must be predefined on the COUNTRY table. comphead co_country varchar2 3 Yes The abbreviation of the country of the company headquarters. This value must be predefined on the COUNTRY table.
postal_code varchar230 0 1 The postal zip code of the company headquarters. comphead co_post varchar2 30 No The postal zip code of the company headquarters.
ExtOfXMrchHrCompDesc:ExtOfXMrchHrCompDesc * 0 1 Provide an extension hook to customize XMrchHrCompDesc. NA NA NA NA NA NA

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