| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPData Collection |
| 1 | S077 | STRPS: Movements | 12 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 2 | S077E | S077 - Structural Information | 7 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 3 | S078 | STRPS: Stock | 6 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 4 | S078E | S078 - Structural Informaton | 7 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 5 | S079 | STRPS: Movements + Stock | 12 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 6 | S079E | S079 - Structural Information | 7 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 7 | S080 | Purchasing: Movements | 12 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 8 | S080E | S080 - Structural Information | 7 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 9 | S081 | Purchasing: Stock | 6 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 10 | S081E | S081 - Structural Information | 7 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 11 | S082 | Purchasing: Movements + Stock | 12 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 12 | S082E | S082 - Structural Information | 7 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 13 | S083 | Material: Movements | 9 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 14 | S083E | S083 - Structural Information | 4 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 15 | S084 | Material: Stock | 3 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 16 | S084E | S084 - Structural Information | 4 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 17 | S085 | Material: Movements + Stock | 9 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 18 | S085E | S085 - Structural Information | 4 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 19 | S086 | Promotion | 10 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 20 | S086E | S086 - Structural Information | 5 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 21 | S087 | Material/add-on | 9 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 22 | S087E | S087 - Structural Information | 4 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 23 | S108 | Additionals | 5 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 24 | S108E | S108 - Structural Information | 4 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 25 | S160 | Perishables | 10 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 26 | S160E | S160 - Structural Information | 5 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
| 27 | S200 | Inventory Controlling Stores | 40 | BTRKZ | Plant category | nvarchar | 1 | 0 | | |
