| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAPAFP | IS-M/AM: Contract Determination Log for OPM Item | 11 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| 2 | JJTIKOHY | IS-M/AM: Content Components Hierarchy | 12 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| TOPAnalyzer |
| 3 | JBRHISPHBAUMS | Tree Structure for Deactivated Portfolio Hierarchies | 12 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| TOPMarket Risk Analyzer |
| 4 | JBRRHBAUM | Tree Structure of Risk Hierarchy | 11 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| 5 | JBRRHBAUMH | Tree Structure of Risk Hierarchy (History) | 12 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| 6 | JBRRHBAUM_BACK | Backup Table JBRRHBAUM (Required for Transport Imports) | 11 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| TOPMaterial Groups |
| 7 | WTREE | Version Management for Reclassification Trees | 13 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| TOPRepository Browser |
| 8 | TREELOG | Change log for table TREE (tree administration) | 10 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| TOPRisk Analysis |
| 9 | JBRNODETXT | All Information for Display of Hierarchies | 10 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| 10 | JBRPHBAUMS | Storage of Portfolio Hierarchy | 12 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| 11 | JBRSVPHBAUM | RM: Portfolio Hierarchy for Saved Datasets (Backtesting) | 13 | TLOCK | Internal: Selection ID | nvarchar | 1 | 0 | | |
| TOPTravel Expenses |
| 12 | PTRV_ARCH_PERIO | Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) | 17 | TLOCK | Indicator: Trip locked | nvarchar | 1 | 0 | | |
| 13 | PTRV_PERIO | Period Data of a Trip | 17 | TLOCK | Indicator: Trip locked | nvarchar | 1 | 0 | | |
