| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogistics Basic Data |
1 | CMMD_CDT1 | Category | 2 | CDT1 | Category | nvarchar | 18 | 0 | | |
2 | CMMD_CDT1T | Master Data Texts Category | 2 | CDT1 | Category | nvarchar | 18 | 0 | | |
3 | CMMD_CDT2 | Master Data Subcategory | 7 | CDT1 | Category | nvarchar | 18 | 0 | | |
4 | CMMD_CDT3 | Master Data Segment | 7 | CDT1 | Category | nvarchar | 18 | 0 | | |
5 | CMMD_CDT4 | Master Data Subsegment | 7 | CDT1 | Category | nvarchar | 18 | 0 | | |
6 | CMMD_CDT5 | Master Data Sub-Subsegment | 7 | CDT1 | Category | nvarchar | 18 | 0 | | |
7 | CMMD_CDT6 | Master Data Product Group | 7 | CDT1 | Category | nvarchar | 18 | 0 | | |
8 | CMMD_CDT7 | Master Data Brand | 7 | CDT1 | Category | nvarchar | 18 | 0 | | |
9 | CMMD_SKU | CDT-SKU Assignment Table | 5 | CDT1 | Category | nvarchar | 18 | 0 | | |
10 | WRF_CMMD_CDT1 | Category | 2 | CDT1 | Category | nvarchar | 18 | 0 | | |
11 | WRF_CMMD_CDT1T | Category Texts | 2 | CDT1 | Category | nvarchar | 18 | 0 | | |
12 | WRF_CMMD_CDT2 | Subcategory | 8 | CDT1 | Category | nvarchar | 18 | 0 | | |
13 | WRF_CMMD_CDT3 | Segment | 8 | CDT1 | Category | nvarchar | 18 | 0 | | |
14 | WRF_CMMD_CDT4 | Subsegment | 8 | CDT1 | Category | nvarchar | 18 | 0 | | |
15 | WRF_CMMD_CDT5 | Sub-Subsegment | 8 | CDT1 | Category | nvarchar | 18 | 0 | | |
16 | WRF_CMMD_CDT6 | Product Group | 8 | CDT1 | Category | nvarchar | 18 | 0 | | |
17 | WRF_CMMD_CDT7 | Brand | 8 | CDT1 | Category | nvarchar | 18 | 0 | | |
18 | WRF_CMMD_SKU | CDT-SKU Assignment Table | 5 | CDT1 | Category | nvarchar | 18 | 0 | | |
TOPMerchandise and Assortment Planning |
19 | S212 | CatMan: Hohe Ebene | 9 | CDT1 | Categorie | nvarchar | 18 | 0 | | |
20 | S212BIW1 | S212BIW1 * CatMan: High Level | 4 | CDT1 | Category | nvarchar | 18 | 0 | | |
21 | S212BIW2 | S212BIW2 * CatMan: High Level | 4 | CDT1 | Category | nvarchar | 18 | 0 | | |
22 | S212E | S212 - Strukturinformationen | 4 | CDT1 | Categorie | nvarchar | 18 | 0 | | |
23 | S214 | CatMan: Indizees für ROP | 9 | CDT1 | Categorie | nvarchar | 18 | 0 | | |
24 | S214BIW1 | S214BIW1 * CatMan: Indexes for Space Management Program | 4 | CDT1 | Category | nvarchar | 18 | 0 | | |
25 | S214BIW2 | S214BIW2 * CatMan: Indexes for Space Management Program | 4 | CDT1 | Category | nvarchar | 18 | 0 | | |
26 | S214E | S214 - Strukturinformationen | 4 | CDT1 | Categorie | nvarchar | 18 | 0 | | |
27 | S219 | CatMan: Feine Ebene | 9 | CDT1 | Categorie | nvarchar | 18 | 0 | | |
28 | S219BIW1 | S219BIW1 * CatMan: Fine Level | 4 | CDT1 | Category | nvarchar | 18 | 0 | | |
29 | S219BIW2 | S219BIW2 * CatMan: Detailed Level | 4 | CDT1 | Category | nvarchar | 18 | 0 | | |
30 | S219E | S219 - Strukturinformationen | 4 | CDT1 | Categorie | nvarchar | 18 | 0 | | |