| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | OCRN | Currency Codes | 6 | FrgnName | English | nVarChar | 20 | 0 | | |
| TOPFinance |
| 2 | AACT | G/L Account - History | 40 | FrgnName | Foreign Name | nVarChar | 100 | 0 | | |
| 3 | OACT | G/L Accounts | 40 | FrgnName | Foreign Name | nVarChar | 100 | 0 | | |
| 4 | OFRC | Financial Report Categories | 4 | FrgnName | Foreign Name | nVarChar | 254 | 0 | | |
| TOPGeneral |
| 5 | ARSC | Resource Master Data - Log | 7 | FrgnName | Description in Foreign Lang. | nVarChar | 100 | 0 | | |
| 6 | ORSC | Resources | 7 | FrgnName | Description in Foreign Lang. | nVarChar | 100 | 0 | | |
| TOPInventory and Production |
| 7 | AITM | Items - History | 3 | FrgnName | Description in Foreign Lang. | nVarChar | 100 | 0 | | |
| 8 | OITM | Items | 3 | FrgnName | Description in Foreign Lang. | nVarChar | 100 | 0 | | |
| 9 | SITM | Items | 3 | FrgnName | Description in Foreign Lang. | nVarChar | 100 | 0 | | |
| 10 | UITM | Items | 3 | FrgnName | Description in Foreign Lang. | nVarChar | 100 | 0 | | |
