| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConsolidation |
1 | TF9N1 | Master Data Table: & | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
TOPData Collection |
2 | T242B | Characteristic values per characteristic | 6 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
3 | T2700 | Master data table: Region | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
4 | T2701 | Master data table: Brand | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
5 | T2702 | Master data table: Production group | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
6 | T2703 | Master data table: Manufacturer | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
7 | T2704 | Master data table: Region | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
8 | T2705 | Master data table: Area | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
9 | T2706 | Master data table: Trade channel | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
10 | T2707 | Master data table: Area | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
11 | T2708 | Master data table: Country | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
12 | T2709 | Master data table: Plant | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
13 | T270A | Master data table: Division | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
14 | T270B | Master data table: Product Group | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
15 | T270C | Master data table: Customer Group | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
16 | T270D | Master data table: Distribution Channel | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
17 | T270E | Master data table: Company | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
18 | T270F | Master data table: Month | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
19 | T270G | Master data table: Division | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
20 | T270H | Master data table: Region | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
21 | T270I | Master data table: Product type | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
22 | T270J | Master data table: Source of data | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
23 | T2710 | Master data table: Area (Countries) | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
24 | T2711 | Master data table: Continent | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
25 | T2712 | Master data table: countries | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
26 | T2713 | Master data table: regions | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
27 | T2714 | Master data table: product groups | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
28 | T2715 | Master data table: Continent | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
29 | T2716 | Master data table: Land | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
30 | T2717 | Master data table: State | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
31 | T2718 | Master data table: Prod. Group | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
32 | T2719 | Master data table: Sales Channel | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
33 | T271A | Master Data Table: Company | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
34 | T271B | Master Data Table: Strategic Business U | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
35 | T271C | Master Data Table: demo | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
36 | T271D | Master Data Table: xxrk1 | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
37 | T271E | Stammdatentabelle: T-Segment | 5 | DFLAG | Kennzeichen für Dokumenten-Anschluß | nvarchar | 1 | 0 | | |
38 | T271F | Stammdatentabelle: T-Business Unit | 6 | DFLAG | Kennzeichen für Dokumenten-Anschluß | nvarchar | 1 | 0 | | |
39 | T271G | Stammdatentabelle: T-Division | 6 | DFLAG | Kennzeichen für Dokumenten-Anschluß | nvarchar | 1 | 0 | | |
40 | T271H | Stammdatentabelle: T-Product Line | 6 | DFLAG | Kennzeichen für Dokumenten-Anschluß | nvarchar | 1 | 0 | | |
41 | T271I | Master data table: town xx | 6 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
42 | T2720 | Master data table: xarea (Description) | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
43 | T2721 | Master data table: CITY (X) | 6 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
44 | T2722 | Master data table: PRODUCTS (X) | 8 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
45 | T2723 | Master data table: MAYOR (X) | 6 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
46 | T2737 | Master Data Table: Customer Group 00 | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
47 | T2738 | Master Data Table: Customer 00 | 6 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
48 | T27NN | Master Data Table: & | 5 | DFLAG | Flag for connection of documents | nvarchar | 1 | 0 | | |
TOPSyntax, Compiler, Runtime |
49 | SABP_ACC_CLASSES | INTERNAL * NO ACCESS OUTSIDE PACKAGE * Restricted Classes | 5 | DFLAG | INTERNAL * NO REUSE OUTSIDE PACKAGE - Soft Deletion | nvarchar | 1 | 0 | | |