| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T731 | Key Figures in Info Library (Transport Table) | 2 | KENNI | Key figure in the Logistics Information Library (LIL) | nvarchar | 8 | 0 | | |
2 | T731T | Key Figure Texts (Transport Table) | 3 | KENNI | Key figure in the Logistics Information Library (LIL) | nvarchar | 8 | 0 | | |
TOPCapacity Evaluations |
3 | TCYF | Profile detailed list: Displayed fields | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
4 | TCYFT | Texts for displayed fields profile | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
5 | TCYP | Profile detailed list: Criteria grouping | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
6 | TCYPT | Texts for criteria grouping | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
7 | TCYS | Profile detailed list: Sort criteria | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
8 | TCYST | Texts for sort criteria profile | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
TOPInformation System |
9 | TCNA | Project Information System: Summarization Criteria (Aggr.) | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
10 | TCNAT | Texts for project information system summarization criteria | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
11 | TCNEG | Project Information System: Field Selecton for Graphic | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
12 | TCNEGT | Texts for Fields Displayed in the Project Info System | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
13 | TCNF | Project Information System: Displayed Fields | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
14 | TCNFT | Texts for Fields Displayed in the Project Info System | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
15 | TCNP | Project Info System: Grouping Criteria | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
16 | TCNPT | Text for Grouping Criteria in Project Info System | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
17 | TCNS | Project Info System: Sort Criteria | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
18 | TCNST | Texts for Sort Criteria in Project Info System | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
19 | TCNVG | Project Information System: Version Comparison Criteria | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
20 | TCNVGT | Texts for Project Info System Version Comparision Criteria | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
TOPLogistics Information Library |
21 | MCLI | Key Figures in Information Library | 2 | KENNI | Key figure in the Logistics Information Library (LIL) | nvarchar | 8 | 0 | | |
22 | MCLIT | Key Figure Texts | 3 | KENNI | Key figure in the Logistics Information Library (LIL) | nvarchar | 8 | 0 | | |
TOPProduction Orders |
23 | TCOAOB | Profile order progress report: Displayed fields objects | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
24 | TCOAOBT | Profile order progress report: Displayed fields objs (Text) | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
25 | TCOFF | Profile for Missing Parts Info System: Displayed Fields | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
26 | TCOFFT | Texts for Missing Parts Info System: Displayed Fields | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
27 | TCOFG | Profile for missing parts info system: criteria for grouping | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
28 | TCOFGT | Texts for Missing Parts Info System: Criteria for Grouping | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
29 | TCOFS | Profile for Missing Parts Info System: Sort Criteria | 4 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
30 | TCOFST | Texts for Missing Parts Info System: Sort Criteria | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
31 | TCOPS | Field selection profile | 5 | KENNI | Numc3, internal use | nvarchar | 3 | 0 | | |
TOPReporting |
32 | TMC8 | Predefined Key Figures per Analysis | 6 | KENNI | Number of key figure/information item in LIS | nvarchar | 8 | 0 | | |