| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinance |
| 1 | ORTM | Rate Differences | 10 | Valid | Confirmed | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | RTM1 | Rate Differences - Rows | 8 | Valid | Confirmed | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| TOPGeneral |
| 3 | APH8 | Project Management - Summary - History | 36 | Valid | If the calculated data is valid | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 4 | APM8 | Project Management - Summary - History | 36 | Valid | If the calculated data is valid | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 5 | PHA8 | Project Management - Summary | 36 | Valid | If the calculated data is valid | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | PMG8 | Project Management - Summary | 36 | Valid | If the calculated data is valid | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPInventory and Production |
| 7 | ASPP | Special Prices | 15 | Valid | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
| 8 | OSPP | Special Prices | 15 | Valid | Active | VarChar | 1 | 0 | Y | N=No, Y=Yes |
