| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNV_20000_MCDX | Fiscal Year conversion -- data | 5 | SELDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| TOPBasic Data and Tools |
| 2 | RMSDX | RMS: Data Repository for User Settings | 6 | SELDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| TOPBasic Functions |
| 3 | MCDX | Compressed Consolidation transaction data | 5 | SELDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| 4 | T863X | Selections for reporting | 7 | SELDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| TOPConsolidation |
| 5 | MCDX2 | Compressed Consolidation transaction data | 5 | SELDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| TOPData Retention Tool |
| 6 | TXW_DIR | Data file log (replaced by txw_dir2, use of guids) | 8 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 7 | TXW_DIR2 | Data file log | 10 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 8 | TXW_DIRSEG | Data file segment directory (replaced by txw_dirsg2: uuids) | 22 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 9 | TXW_DIRSG2 | Data file segment directory | 22 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 10 | TXW_VWLOG | View query log (replaced by txw_vwlog2: uuids) | 12 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 11 | TXW_VWLOG2 | View query log | 14 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| TOPData Staging |
| 12 | RSSDLINIT | Last Valid Initializations to an OLTP Source | 8 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 13 | RSSDLINITDEL | Last Valid Initializations to an OLTP Source | 8 | SELDATE | System Date | nvarchar | 8 | 0 | | |
| 14 | RSSELDONE | Monitor: Selections for executed request | 35 | SELDATE | Date | nvarchar | 8 | 0 | | |
| TOPGeneral Ledger Accounting |
| 15 | FAGL_PROT_DATA | Logged Data | 5 | SELDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| TOPOrganizational Management |
| 16 | T77OMFRAM | Hierarchy Framework Scenario: Scenario Attributes | 15 | SELDATE | Set/Get parameter ID | nvarchar | 20 | 0 | | |
| TOPSCM Basis |
| 17 | CIF_IMPPM | Int. Model Reference Table for Production Process Model | 15 | SELDATE | Selection Date for PPM Updating | nvarchar | 1 | 0 | | |
