| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | S953E | S953 - Strukturinformationen | 3 | BONNR | Bon-Nummer | nvarchar | 15 | 0 | | |
| 2 | S954E | S954 - Strukturinformationen | 3 | BONNR | Bon-Nummer | nvarchar | 15 | 0 | | |
| TOPData Collection |
| 3 | S117 | Receipt/article | 3 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 4 | S117E | S117 - Structural Information | 3 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 5 | S119 | Transaction Number (Till Receipt) | 3 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 6 | S119E | S119 - Structural Information | 3 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 7 | S120 | Sales as per receipts | 6 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 8 | S120BIW1 | S120BIW1 * Sales as Per Receipts | 6 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 9 | S120BIW2 | S120BIW2 * Sales as Per Receipts | 6 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 10 | S120E | S120 - Structural Information | 6 | BONNR | Transaction number (till receipt) | nvarchar | 15 | 0 | | |
| 11 | S953 | BW Vorl.für BON/Artikel S117 | 8 | BONNR | Bon-Nummer | nvarchar | 15 | 0 | | |
| 12 | S954 | BW Vorl.für BON S119 | 8 | BONNR | Bon-Nummer | nvarchar | 15 | 0 | | |
| TOPLocalization |
| 13 | J_1BPOSCOUPONS | POS-Database Coupons (Brazilian) | 6 | BONNR | External reference no. (GR/I slip) | nvarchar | 15 | 0 | | |
