| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_20000_MCDX | Fiscal Year conversion -- data | 6 | SELTIME | System Time | nvarchar | 6 | 0 | | |
TOPBasic Data and Tools |
2 | RMSDX | RMS: Data Repository for User Settings | 7 | SELTIME | System Time | nvarchar | 6 | 0 | | |
TOPBasic Functions |
3 | MCDX | Compressed Consolidation transaction data | 6 | SELTIME | System Time | nvarchar | 6 | 0 | | |
4 | T863X | Selections for reporting | 8 | SELTIME | TIME Data Element for SYST | nvarchar | 6 | 0 | | |
TOPConsolidation |
5 | MCDX2 | Compressed Consolidation transaction data | 6 | SELTIME | System Time | nvarchar | 6 | 0 | | |
TOPData Retention Tool |
6 | TXW_DIR | Data file log (replaced by txw_dir2, use of guids) | 9 | SELTIME | System Time | nvarchar | 6 | 0 | | |
7 | TXW_DIR2 | Data file log | 11 | SELTIME | System Time | nvarchar | 6 | 0 | | |
8 | TXW_DIRSEG | Data file segment directory (replaced by txw_dirsg2: uuids) | 23 | SELTIME | System Time | nvarchar | 6 | 0 | | |
9 | TXW_DIRSG2 | Data file segment directory | 23 | SELTIME | System Time | nvarchar | 6 | 0 | | |
10 | TXW_VWLOG | View query log (replaced by txw_vwlog2: uuids) | 13 | SELTIME | System Time | nvarchar | 6 | 0 | | |
11 | TXW_VWLOG2 | View query log | 15 | SELTIME | System Time | nvarchar | 6 | 0 | | |
TOPData Staging |
12 | RSSELDONE | Monitor: Selections for executed request | 36 | SELTIME | Time | nvarchar | 6 | 0 | | |
TOPGeneral Ledger Accounting |
13 | FAGL_PROT_DATA | Logged Data | 6 | SELTIME | System Time | nvarchar | 6 | 0 | | |