Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XOrgHrDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
hier_value |
number10 |
1 |
1 |
The identifier of the
hierarchy value. This value must be unique among
other values of the same hierarchy level. It cannot
be modified. |
chain, area, region, district |
chain, area, region, district |
null |
null |
Yes |
The identifier of the hierarchy value. This value must be unique among other values of the same hierarchy level. It cannot be modified. |
hier_desc |
varchar2120 |
1 |
1 |
The description of the
hierarchy value. |
chain, area, region, district |
chain_name, area_name, region_name, district_name |
null |
null |
Yes |
The description of the hierarchy value. |
hier_level |
varchar22 |
1 |
1 |
Value is restricted by
message type. The value will indicate either CH
(chain), AR (area), RE (region), or DI (district).
|
n/a |
n/a |
null |
null |
Yes |
Value is restricted by message type. The value will indicate either CH (chain), AR (area), RE (region), or DI (district). |
parent_id |
number10 |
0 |
1 |
The identifier of the
hierarchy value's parent hierarchy value. This
value must be predefined on either the CHAIN, AREA
or REGION table. |
chain, area, region |
chain, area, region |
null |
null |
No |
The identifier of the hierarchy value's parent hierarchy value. This value must be predefined on either the CHAIN, AREA or REGION table. |
mgr_name |
varchar2120 |
0 |
1 |
The manager name of the
hierarchy value. |
chain, area, region, district |
mgr_name |
null |
null |
No |
The manager name of the hierarchy value. |
currency_code |
varchar23 |
0 |
1 |
The code which identifies the
currency under which the hierarchy value operates.
This value must be predefined on the CURRENCIES
table. |
chain, area, region, district |
currency_code |
null |
null |
No |
The code which identifies the currency under which the hierarchy value operates. This value must be predefined on the CURRENCIES table. |
XOrgHrLocTrt:XOrgHrLocTrt
|
*
|
0
|
unbounded
|
It's a referenced element.
For detailed description, please refer referenced
element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
ExtOfXOrgHrDesc:ExtOfXOrgHrDesc
|
*
|
0
|
1
|
Provide an extension hook to
customize XOrgHrDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|