XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XMrchHrCompDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's 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 that 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. |