PROFIT CENTER GROUP WITH ID Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
180 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
840 |
PC_LEVEL1_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL1_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL1_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL2_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL2_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL2_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL3_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL3_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL3_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL4_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL4_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL4_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL5_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL5_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL5_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL6_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL6_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL6_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL7_CATEGORY |
Profit Center Group Category description. |
VARCHAR2 |
40 |
PC_LEVEL7_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL7_SORT |
Profit Center Group sort order. |
NUMBER |
6 |
PC_LEVEL8_CATEGORY |
XXX |
VARCHAR2 |
40 |
PC_LEVEL8_ID |
XXX |
VARCHAR2 |
10 |
PC_LEVEL8_SORT |
XXX |
NUMBER |
6 |
PROFIT_CENTER_GROUP_CODE |
Code of the Profit Center Group as listed in SAP. |
VARCHAR2 |
12 |
PROFIT_CENTER_GROUP_NAME |
Name of the Profit Center Group as listed in SAP. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
The text name of the profit center. |
VARCHAR2 |
50 |
SCHOOL_AREA |
XXX |
VARCHAR2 |
840 |