| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | REFXCN_SALES | Sales Data | 16 | BBYNR | Promotion Type | nvarchar | 6 | 0 | | |
TOPConditions |
2 | KONDN | Conditions: Free goods - Data section | 21 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
TOPData Collection |
3 | S120 | Sales as per receipts | 64 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
4 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 64 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
5 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 64 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
TOPFree Goods |
6 | BBY_USED | Bonus Buy: Stores/Bonus Buys/Deletion Indicator | 3 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
7 | KONBBYH | Bonus Buys: Header | 2 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
8 | KONBBYPRQ | Bonus Buys: Prerequisites | 2 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
9 | KONBBYT | Bonus Buys: Text | 3 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
10 | KOTN201 | Sales Org./Distr.Channel/Bonus Buy/Material/Sales Unit | 6 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
11 | KOTN202 | SalesOrg./SalesChan/PriceList/BonusBuy/Material/SalesUnit | 7 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
12 | KOTN203 | SalesOrg./SalesChan/Plant/BonusBuy/Material/SalesUnit | 7 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
TOPRetail Demand Management |
13 | RDM_BBY_MQTY_DIS | Quantity Distribution for BBY Materials in a promotion | 2 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |
TOPRetail Enterprise Services |
14 | WESD_BBY_SENT | Bonus Buy: Stores Supplied via Service | 4 | BBYNR | Bonus buy | nvarchar | 12 | 0 | | |