| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPEnergy Data Management |
| 1 | EPROFVALCSTATCST | Display for User Status of Profile Values | 5 | COLOUR | Color of status for graphical profile display | nvarchar | 2 | 0 | | |
| 2 | EPROFVALSTATCUST | Display for System Status of Profile Values | 5 | COLOUR | Color of status for graphical profile display | nvarchar | 2 | 0 | | |
| TOPPrice Planning Workbench |
| 3 | WRFT_PPW_TSHP_C | Tree Profile Column Attributes | 11 | COLOUR | Font Color | tinyint | 3 | 0 | | |
| 4 | WRFT_PPW_TSHP_CD | Default for Tree Profile Column Attributes | 10 | COLOUR | Font Color | tinyint | 3 | 0 | | |
| 5 | WRFT_PPW_TSHP_H | Tree Profile Hierarchy | 11 | COLOUR | Font Color | tinyint | 3 | 0 | | |
| 6 | WRFT_PPW_TSHP_HD | Default for Hierarchy Tree Profile | 10 | COLOUR | Font Color | tinyint | 3 | 0 | | |
| TOPSAP Business Workflow |
| 7 | TETYP | Workflow Definition: Node Types (Central) | 3 | COLOUR | Color | nvarchar | 1 | 0 | | |
| TOPWaste Management |
| 8 | EWA_EL_SAMPLE | Sample | 11 | COLOUR | Color of Sample | nvarchar | 254 | 0 | | |
