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