| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogistics Basic Data |
1 | CMMD_CDT1 | Category | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
2 | CMMD_CDT2 | Master Data Subcategory | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
3 | CMMD_CDT3 | Master Data Segment | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
4 | CMMD_CDT4 | Master Data Subsegment | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
5 | CMMD_CDT5 | Master Data Sub-Subsegment | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
6 | CMMD_CDT6 | Master Data Product Group | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
7 | CMMD_CDT7 | Master Data Brand | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
8 | CMMD_SKU | CDT-SKU Assignment Table | 16 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
9 | WRF_CMMD_CDT1 | Category | 10 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
10 | WRF_CMMD_CDT2 | Subcategory | 11 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
11 | WRF_CMMD_CDT3 | Segment | 11 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
12 | WRF_CMMD_CDT4 | Subsegment | 11 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
13 | WRF_CMMD_CDT5 | Sub-Subsegment | 11 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
14 | WRF_CMMD_CDT6 | Product Group | 11 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
15 | WRF_CMMD_CDT7 | Brand | 11 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
16 | WRF_CMMD_SKU | CDT-SKU Assignment Table | 16 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
17 | WRF_MATGRP_MD1 | Hierarchy Level 1 - Time-Dependent | 14 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
18 | WRF_MATGRP_MD10 | Hierarchy Level 10 - Time-Dependent | 23 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
19 | WRF_MATGRP_MD2 | Hierarchy Level 2 - Time-Dependent | 15 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
20 | WRF_MATGRP_MD3 | Hierarchy Level 3 - Time-Dependent | 16 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
21 | WRF_MATGRP_MD4 | Hierarchy Level 4 - Time-Dependent | 17 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
22 | WRF_MATGRP_MD5 | Hierarchy Level 5 - Time-Dependent | 18 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
23 | WRF_MATGRP_MD6 | Hierarchy Level 6 - Time-Dependent | 19 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
24 | WRF_MATGRP_MD7 | Hierarchy Level 7 - Time-Dependent | 20 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
25 | WRF_MATGRP_MD8 | Hierarchy Level 8 - Time-Dependent | 21 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
26 | WRF_MATGRP_MD9 | Hierarchy Level 9 - Time-Dependent | 22 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |
27 | WRF_MATGRP_PROD | Hierarchy-Product Assignment Table | 23 | SPACEUNIT | CM: Shelf-Space Unit | nvarchar | 3 | 0 | | |