| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_20100_T801E | Org. derivation (LIB,RNAME) by T801E | 3 | LIB | | nvarchar | 3 | 0 | | |
2 | T801A | Report Writer: Exceptions in Row/Column Coordinates | 2 | LIB | Library | nvarchar | 3 | 0 | | |
3 | T801C | Report Writer: Parallel Report Windows | 2 | LIB | Library | nvarchar | 3 | 0 | | |
4 | T801N | Report Writer: Library Texts | 3 | LIB | Library | nvarchar | 3 | 0 | | |
5 | T801P | Report Writer: Key Figures for Libraries | 2 | LIB | Library | nvarchar | 3 | 0 | | |
6 | T803A | Report Writer: Key Figure Blocks (Header) | 2 | LIB | Library | nvarchar | 3 | 0 | | |
7 | T803B | Report Writer: Key Figure Blocks (Descriptions) | 3 | LIB | Library | nvarchar | 3 | 0 | | |
8 | T803C | Report Writer: Key Figure Blocks (Rows) | 2 | LIB | Library | nvarchar | 3 | 0 | | |
9 | T803D | Report Writer: Key Figure Blocks (Row/Column Texts) | 3 | LIB | Library | nvarchar | 3 | 0 | | |
10 | T803E | Report Writer: Key Figure Blocks (Columns) | 2 | LIB | Library | nvarchar | 3 | 0 | | |
11 | T803I | Report Writer: Row Formulas / Texts | 3 | LIB | Library | nvarchar | 3 | 0 | | |
12 | T803Z | Obsolete: Report Usage | 2 | LIB | Library | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
13 | FAGL_RMIGR_LOG1 | Report Migration: Log Status | 6 | LIB | Library | nvarchar | 3 | 0 | | |
14 | FAGL_RMIGR_LOG2 | Report Migration: Log Header | 3 | LIB | Library | nvarchar | 3 | 0 | | |
15 | FAGL_RMIGR_LOG3 | Report Migration: Log Detail | 3 | LIB | Library | nvarchar | 3 | 0 | | |
16 | FAGL_RMIGR_LOG4 | Report Migration: Log Messages | 3 | LIB | Library | nvarchar | 3 | 0 | | |
TOPInformation System |
17 | T800 | Report Writer: Reports | 2 | LIB | Library | nvarchar | 3 | 0 | | |
18 | T800T | Report Writer: Texts for Reports | 3 | LIB | Library | nvarchar | 3 | 0 | | |
19 | T801B | Report Writer: Texts for Logical Rows | 3 | LIB | Library | nvarchar | 3 | 0 | | |
20 | T801D | Report Writer: Row/Column Characteristics | 2 | LIB | Library | nvarchar | 3 | 0 | | |
21 | T801E | Report Writer: Selection Sets | 2 | LIB | Library | nvarchar | 3 | 0 | | |
22 | T801F | Report Writer: Rest Blocks (Rows, Columns) | 2 | LIB | Library | nvarchar | 3 | 0 | | |
23 | T801G | Report Writer: Sections | 2 | LIB | Library | nvarchar | 3 | 0 | | |
24 | T801H | Report Writer: Parallel Reports | 2 | LIB | Library | nvarchar | 3 | 0 | | |
25 | T801K | Report Writer: Libraries | 2 | LIB | Library | nvarchar | 3 | 0 | | |
26 | T801L | Report Writer: Library Fields | 2 | LIB | Library | nvarchar | 3 | 0 | | |
27 | T801M | Report Writer: Rows/Columns | 2 | LIB | Library | nvarchar | 3 | 0 | | |
28 | T801Q | Report Writer: Key Figures for Libraries | 2 | LIB | Library | nvarchar | 3 | 0 | | |
29 | T801S | Report Writer: Cell Assignment | 2 | LIB | Library | nvarchar | 3 | 0 | | |
30 | T801T | Report Writer: Texts for Parallel Reports | 3 | LIB | Library | nvarchar | 3 | 0 | | |
31 | T803F | Report Writer: Key Figure Blocks (Formulas) | 2 | LIB | Library | nvarchar | 3 | 0 | | |
32 | T803G | Report Writer: Key Figure Blocks (Cells in Formulas) | 2 | LIB | Library | nvarchar | 3 | 0 | | |
33 | T803H | Report Writer: Row Formulas | 2 | LIB | Library | nvarchar | 3 | 0 | | |
34 | T803J | Report Writer: Report Groups | 3 | LIB | Library | nvarchar | 3 | 0 | | |
TOPMerchandise and Assortment Planning |
35 | TWISPS01 | Retail Planning: Assignment Info Structure/Library | 3 | LIB | Library | nvarchar | 3 | 0 | | |
TOPReporting |
36 | TMCSA | LIS Evaluations | 4 | LIB | Library | nvarchar | 3 | 0 | | |
37 | TMCSD | LIS Readings for Internal Number Assignment: Alphanumeric | 2 | LIB | LIS library number (current) | nvarchar | 2 | 0 | | |
38 | TMCSE | LIS Default Sets and Format Classes | 2 | LIB | Library | nvarchar | 3 | 0 | | |
TOPSets |
39 | SETUSE_REP | Set Use in Reports and Libraries | 2 | LIB | Library | nvarchar | 3 | 0 | | |