| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogistics Basic Data |
1 | WRF_CMMD_CDT1 | Category | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
2 | WRF_CMMD_CDT2 | Subcategory | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
3 | WRF_CMMD_CDT3 | Segment | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
4 | WRF_CMMD_CDT4 | Subsegment | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
5 | WRF_CMMD_CDT5 | Sub-Subsegment | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
6 | WRF_CMMD_CDT6 | Product Group | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
7 | WRF_CMMD_CDT7 | Brand | 15 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
8 | WRF_MATGRP_MD1 | Hierarchy Level 1 - Time-Dependent | 20 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
9 | WRF_MATGRP_MD10 | Hierarchy Level 10 - Time-Dependent | 29 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
10 | WRF_MATGRP_MD2 | Hierarchy Level 2 - Time-Dependent | 21 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
11 | WRF_MATGRP_MD3 | Hierarchy Level 3 - Time-Dependent | 22 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
12 | WRF_MATGRP_MD4 | Hierarchy Level 4 - Time-Dependent | 23 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
13 | WRF_MATGRP_MD5 | Hierarchy Level 5 - Time-Dependent | 24 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
14 | WRF_MATGRP_MD6 | Hierarchy Level 6 - Time-Dependent | 25 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
15 | WRF_MATGRP_MD7 | Hierarchy Level 7 - Time-Dependent | 26 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
16 | WRF_MATGRP_MD8 | Hierarchy Level 8 - Time-Dependent | 27 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
17 | WRF_MATGRP_MD9 | Hierarchy Level 9 - Time-Dependent | 28 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
TOPPromotion |
18 | WAKP | Promotion Item Data | 63 | EPRGR | Price Point Group, Promotion Item | nvarchar | 6 | 0 | | |
19 | WALE | Material to store assignment to promotion | 82 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
TOPRetail Pricing |
20 | TWEGO | Sales Price Calculation: Assignment of price point group | 8 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
21 | TWPG | Sales pr.: price point ranges | 2 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
22 | TWPK | Sales price calculation: price point groups | 2 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
23 | TWPKO | Sales price calculation: data on SOrg/distr.chnn/matcl level | 5 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
24 | TWPKT | Sales price calculation: price point groups (text) | 3 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
25 | WKBP | Pricing document: item | 80 | EPRGR | Price point group | nvarchar | 6 | 0 | | |
26 | WRF_WPPGRHIER | Assignment of Price Point Group to Mat. Hierarchy Node | 7 | EPRGR | Price point group | nvarchar | 6 | 0 | | |