| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Collection |
1 | S077 | STRPS: Movements | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
2 | S079 | STRPS: Movements + Stock | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
3 | S080 | Purchasing: Movements | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
4 | S082 | Purchasing: Movements + Stock | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
5 | S083 | Material: Movements | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
6 | S085 | Material: Movements + Stock | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
7 | S086 | Promotion | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
8 | S105 | Season: Movements | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
9 | S107 | Season: Movements + Stock | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
10 | S110 | OTB | 23 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
11 | S117 | Receipt/article | 39 | PRSNLS | Price reduction from sales as per receipts/aggregated sales | decimal | 19 | 2 | | |
12 | S119 | Transaction Number (Till Receipt) | 30 | PRSNLS | Price reduction from sales as per receipts/aggregated sales | decimal | 19 | 2 | | |
13 | S120 | Sales as per receipts | 27 | PRSNLS | Price reduction from sales as per receipts/aggregated sales | decimal | 19 | 2 | | |
14 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 27 | PRSNLS | Price reduction from sales as per receipts/aggregated sales | decimal | 19 | 2 | | |
15 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 27 | PRSNLS | Price reduction from sales as per receipts/aggregated sales | decimal | 19 | 2 | | |
16 | S121 | Material aggregation - POS | 21 | PRSNLS | Price reduction | decimal | 19 | 2 | | |
17 | S122 | Cashier | 19 | PRSNLS | Price reduction based on cashier statistics | decimal | 19 | 2 | | |
18 | S122BIW1 | S122BIW1 * Cashier | 19 | PRSNLS | Price reduction based on cashier statistics | decimal | 19 | 2 | | |
19 | S122BIW2 | S122BIW2 * Cashier | 19 | PRSNLS | Price reduction based on cashier statistics | decimal | 19 | 2 | | |
20 | S123 | Customer / material group | 60 | PRSNLS | Third-party sales deviation | decimal | 19 | 2 | | |
21 | S124 | Customer / material | 59 | PRSNLS | Third-party sales deviation | decimal | 19 | 2 | | |
22 | S160 | Perishables | 63 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
23 | S952 | Reference Structure for Generating Info Structures | 40 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
24 | S953 | BW Vorl.für BON/Artikel S117 | 39 | PRSNLS | Preisnachlaß aus bongenauem/verdichteten Umsatz | decimal | 19 | 2 | | |
25 | S954 | BW Vorl.für BON S119 | 30 | PRSNLS | Preisnachlaß aus bongenauem/verdichteten Umsatz | decimal | 19 | 2 | | |
26 | S957 | Reference Structure for Generating Info Structures | 20 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
TOPMerchandise and Assortment Planning |
27 | S202 | MAP: Merchandise Planning Structure | 40 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
28 | S204 | MAP: Merchandise Planning Movements | 26 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
29 | S207 | MAP: Store Planning Structure | 20 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
30 | S216 | MAP: Average Retail WOC | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
31 | S217 | MAP: AvgRetail MON | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
32 | S218 | MAP: AvgRetail BUP | 25 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |
TOPReporting |
33 | S205 | MAP: Store Planning Movements | 20 | PRSNLS | Sales deviation during sales | decimal | 19 | 2 | | |