| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAnalyzer |
| 1 | AFWCH_PHDEFALT | Alternative Portfolio Hierarchy Definition | 7 | HIERTYPE | Category of Characteristic Hierarchy | nvarchar | 1 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 2 | TPFO_SGT | Segmenttyp | 8 | HIERTYPE | Hierarchietyp eines Segmenttyps | nvarchar | 4 | 0 | | |
| TOPRisk Analysis |
| 3 | JBRPHDEF | Definitions Used to Derive Portfolio Hierarchy | 6 | HIERTYPE | Category of Characteristic Hierarchy | nvarchar | 1 | 0 | | |
| 4 | JBRPHDEFBK | RM: Backup for Table JBRPHDEF | 6 | HIERTYPE | Category of Characteristic Hierarchy | nvarchar | 1 | 0 | | |
