Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Logistics Basic Data | ||||||||||
1 | WRF_CMMD_CDT1 | Category | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
2 | WRF_CMMD_CDT2 | Subcategory | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
3 | WRF_CMMD_CDT3 | Segment | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
4 | WRF_CMMD_CDT4 | Subsegment | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
5 | WRF_CMMD_CDT5 | Sub-Subsegment | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
6 | WRF_CMMD_CDT6 | Product Group | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
7 | WRF_CMMD_CDT7 | Brand | 16 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
8 | WRF_MATGRP_MD1 | Hierarchy Level 1 - Time-Dependent | 21 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
9 | WRF_MATGRP_MD10 | Hierarchy Level 10 - Time-Dependent | 30 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
10 | WRF_MATGRP_MD2 | Hierarchy Level 2 - Time-Dependent | 22 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
11 | WRF_MATGRP_MD3 | Hierarchy Level 3 - Time-Dependent | 23 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
12 | WRF_MATGRP_MD4 | Hierarchy Level 4 - Time-Dependent | 24 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
13 | WRF_MATGRP_MD5 | Hierarchy Level 5 - Time-Dependent | 25 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
14 | WRF_MATGRP_MD6 | Hierarchy Level 6 - Time-Dependent | 26 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
15 | WRF_MATGRP_MD7 | Hierarchy Level 7 - Time-Dependent | 27 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
16 | WRF_MATGRP_MD8 | Hierarchy Level 8 - Time-Dependent | 28 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
17 | WRF_MATGRP_MD9 | Hierarchy Level 9 - Time-Dependent | 29 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 | ||
18 | WRF_MATGRP_STRUC | Category Structure | 11 | PRODUCTCLF | Goods Schedule Line | nvarchar | 2 | 0 |