SING PROFIT CENTER GROUP Table
View exposing Singapore profit center group reference records including hierarchy and grouping attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
PC_LEVEL1_CATEGORY |
Pc level1 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL1_SORT |
Pc level1 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL2_CATEGORY |
Pc level2 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL2_SORT |
Pc level2 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL3_CATEGORY |
Pc level3 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL3_SORT |
Pc level3 sort associated with the record. |
NUMBER |
|
PC_LEVEL4_CATEGORY |
Pc level4 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL4_SORT |
Pc level4 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL5_CATEGORY |
Pc level5 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL5_SORT |
Pc level5 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL6_CATEGORY |
Pc level6 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL6_SORT |
Pc level6 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL7_CATEGORY |
Pc level7 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL7_SORT |
Pc level7 sort associated with the record. |
NUMBER |
6 |
PC_LEVEL8_CATEGORY |
Pc level8 category associated with the record. |
VARCHAR2 |
40 |
PC_LEVEL8_SORT |
Pc level8 sort associated with the record. |
NUMBER |
6 |
PROFIT_CENTER_GROUP_CODE |
Code identifying profit center group. |
VARCHAR2 |
12 |
PROFIT_CENTER_GROUP_NAME |
Profit center group name associated with the record. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |