Alias: DCC#
Unique Keys: ENTITY_CODE (DEN_ID) + COST_CENTER_CODE + START_DATECost Center information
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| COST_CENTER_CODE | Varchar2(16) | CODE | Y | |
| DEN_ID | Number(10) | ID | Y | link to P2K_CM_ENTITIES |
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| START_DATE | Date() | DATE | ||
| END_DATE | Date() | DATE | ||
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| DISTRIBUTION_MASK | Varchar2(50) | DISTRIBUTION | ||
| DCCS_ID | Number(10) | ID | link to P2K_CM_COST_CENTER_SECURITIES |
Derived Fields#
| Column Name |
|---|
| DRV_ACTIVE_TIME_SHEET_TOTAL |
| DRV_TIME_SHEET_TOTAL |
User Fields: Allowed
Audit Logging: Allowed
