| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S952E | S952 - Structural information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
2 | S957E | S957 - Structural information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
TOPData Collection |
3 | S952 | Reference Structure for Generating Info Structures | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
4 | S957 | Reference Structure for Generating Info Structures | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
TOPMaterial Master |
5 | WSTN_BW_EXTRACT | Sample DB Table that contains pre-extracted data from B.W. | 6 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
TOPMerchandise and Assortment Planning |
6 | S202 | MAP: Merchandise Planning Structure | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
7 | S202E | S202 - Structural Information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
8 | S203 | MAP: Merchandise Planning Stock | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
9 | S203E | S203 - Structural Information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
10 | S204 | MAP: Merchandise Planning Movements | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
11 | S204E | S204 - Structural Information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
12 | S206 | MAP: Store Planning Stocks | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
13 | S206E | S206 - Structural Information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
14 | S207 | MAP: Store Planning Structure | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
15 | S207E | S207 - Structural Information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
16 | S209 | MAP: OTB Movements | 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
17 | S209E | S209 - Structural Information | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
18 | S210 | MAP: OTB Stock | 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
19 | S210E | S210 - Structural Information | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
20 | S211 | MAP: OTB Evaluation Structure | 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
21 | S211E | S211 - Structural Information | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
22 | S212 | CatMan: Hohe Ebene | 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
23 | S212BIW1 | S212BIW1 * CatMan: High Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
24 | S212BIW2 | S212BIW2 * CatMan: High Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
25 | S212E | S212 - Strukturinformationen | 11 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
26 | S214 | CatMan: Indizees für ROP | 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
27 | S214BIW1 | S214BIW1 * CatMan: Indexes for Space Management Program | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
28 | S214BIW2 | S214BIW2 * CatMan: Indexes for Space Management Program | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
29 | S214E | S214 - Strukturinformationen | 11 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
30 | S219 | CatMan: Feine Ebene | 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
31 | S219BIW1 | S219BIW1 * CatMan: Fine Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
32 | S219BIW2 | S219BIW2 * CatMan: Detailed Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
33 | S219E | S219 - Strukturinformationen | 11 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
34 | TWISPA_AVERAGERT | Merchandise and Assortment Planning: Average Retail | 13 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
35 | TWISPA_AVGRET | Merchandise and Assortment Planning: Average Retail | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
36 | TWISPC_PLSZN | Retail Planning: Planning Scenario | 3 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
TOPReporting |
37 | S205 | MAP: Store Planning Movements | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
38 | S205E | S205 - Structure Information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |