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 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. |
ExtOfXMrchHrCompDesc:ExtOfXMrchHrCompDesc
|
*
|
0
|
1
|
Provide an extension hook to customize XMrchHrCompDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfXMrchHrCompDesc:LocOfXMrchHrCompDesc
|
*
|
0
|
1
|
Provide an extension hook to localize XMrchHrCompDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|