| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBusiness Planning |
| 1 | UPB_HI_REF | Planning Applucations: Reference to Hierarchy | 3 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| TOPBusiness Planning and Simulation |
| 2 | UPC_NODES | Hierarchy Node | 5 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 3 | UPC_STEPS | Relations between Characteristics of a Planning Area | 7 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 4 | UPC_VAR_HIE | Variables - Hierarchies | 5 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 5 | UPC_VAR_HIE_SEL | Variables - Selections using Hierarchies | 7 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 6 | UPC_VAR_HIE_SELA | Variables - Selections using Hierarchies (Active Values) | 7 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 7 | UPP_DOC | Planning: Layout Builder Info about Document | 14 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 8 | UPS_TP_HIERARCHY | Connection Subplan-Hierarchy | 5 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| 9 | UPX_DSRC_HEAD | UPX: Data Sources - Header | 6 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
| TOPCapacity Evaluations |
| 10 | TCY08 | Option profiles | 3 | HIEVER | Cumulate capacity requirements using work center hierarchy | nvarchar | 1 | 0 | | |
| TOPCapacity Leveling |
| 11 | TCY34 | Evaluation profile for capacity leveling | 4 | HIEVER | Cumulate capacity requirements using work center hierarchy | nvarchar | 1 | 0 | | |
| TOPPlanning |
| 12 | RSPLS_CR_STEPS | Relationships Between Characteristics in Basic InfoProvider | 10 | HIEVER | Hierarchy version | nvarchar | 3 | 0 | | |
| TOPStakeholder Relationship Management |
| 13 | USS_BW_HIERARCHY | USTH0: BW Hierarchy | 4 | HIEVER | Hierarchy Version | nvarchar | 3 | 0 | | |
