PROFIT CENTER HIERARCHY Table
View exposing multi-level hierarchical relationships for profit centers used to support search, rollup, and reporting structures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LEVEL1_ID |
Identifier representing hierarchy level 1. |
VARCHAR2 |
10 |
LEVEL1_NAME |
Name associated with hierarchy level 1. |
VARCHAR2 |
40 |
LEVEL2_ID |
Identifier representing hierarchy level 2. |
VARCHAR2 |
10 |
LEVEL2_NAME |
Name associated with hierarchy level 2. |
VARCHAR2 |
40 |
LEVEL3_ID |
Identifier representing hierarchy level 3. |
VARCHAR2 |
10 |
LEVEL3_NAME |
Name associated with hierarchy level 3. |
VARCHAR2 |
40 |
LEVEL4_ID |
Identifier representing hierarchy level 4. |
VARCHAR2 |
10 |
LEVEL4_NAME |
Name associated with hierarchy level 4. |
VARCHAR2 |
40 |
LEVEL5_ID |
Identifier representing hierarchy level 5. |
VARCHAR2 |
10 |
LEVEL5_NAME |
Name associated with hierarchy level 5. |
VARCHAR2 |
40 |
LEVEL6_ID |
Identifier representing hierarchy level 6. |
VARCHAR2 |
10 |
LEVEL6_NAME |
Name associated with hierarchy level 6. |
VARCHAR2 |
40 |
LEVEL7_ID |
Identifier representing hierarchy level 7. |
VARCHAR2 |
10 |
LEVEL7_NAME |
Name associated with hierarchy level 7. |
VARCHAR2 |
40 |
PROFIT_CENTER_KEY |
Surrogate identifier for the profit center associated with the hierarchy record. |
VARCHAR2 |
11 |
SEARCH_ID |
Identifier used to support hierarchical search or grouping of profit centers. |
VARCHAR2 |
12 |
SEARCH_NAME |
Name associated with the hierarchical search identifier. |
VARCHAR2 |
40 |