| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | ATT1 | Bill of Materials - Components - History | 13 | Uom | Inventory UOM | nVarChar | 100 | 0 | | |
| 2 | AWOR | Production Order - History | 21 | Uom | Inv. UoM in Production Order | nVarChar | 100 | 0 | | |
| 3 | ITT1 | Bill of Materials - Components | 13 | Uom | Inventory UoM | nVarChar | 100 | 0 | | |
| 4 | OWOR | Production Order | 21 | Uom | Inv. UoM in Production Order | nVarChar | 100 | 0 | | |
| 5 | UWOR | Production Order | 21 | Uom | Inv. UoM in Production Order | nVarChar | 100 | 0 | | |
| TOPMarketing Documents |
| 6 | GTI1 | GTS Invoice Details | 6 | Uom | Unit of Measurement | nVarChar | 16 | 0 | | |
| TOPMRP |
| 7 | ORCM | Recommendation Data | 8 | UOM | Buy or Inventory UoM | nVarChar | 100 | 0 | | |
