Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Logistics Basic Data | ||||||||||
1 | WRF_CMMD_CDT1T | Category Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
2 | WRF_CMMD_CDT2T | Subcategory Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
3 | WRF_CMMD_CDT3T | Segment Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
4 | WRF_CMMD_CDT4T | Subsegment Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
5 | WRF_CMMD_CDT5T | Sub-Subsegment Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
6 | WRF_CMMD_CDT6T | Product Group Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
7 | WRF_CMMD_CDT7T | Brand Texts | 5 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
8 | WRF_MATGRP_MD10T | Hierarchy Level 10 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
9 | WRF_MATGRP_MD1T | Hierarchy Level 1 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
10 | WRF_MATGRP_MD2T | Hierarchy Level 2 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
11 | WRF_MATGRP_MD3T | Hierarchy Level 3 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
12 | WRF_MATGRP_MD4T | Hierarchy Level 4 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
13 | WRF_MATGRP_MD5T | Hierarchy Level 5 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
14 | WRF_MATGRP_MD6T | Hierarchy Level 6 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
15 | WRF_MATGRP_MD7T | Hierarchy Level 7 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
16 | WRF_MATGRP_MD8T | Hierarchy Level 8 Texts | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
17 | WRF_MATGRP_MD9T | Texts - Hierarchy Level 9 | 6 | LTEXTLG | Long Name | nvarchar | 60 | 0 | ||
18 | WRF_MATGRP_STRCT | Language-Dependent Name of a Hierarchy Node | 7 | LTEXTLG | Long Name | nvarchar | 60 | 0 |