| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBusiness Partners |
| 1 | ACRD | Business Partners - History | 106 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 2 | OCRD | Business Partner | 106 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPGeneral |
| 3 | ARSC | Resource Master Data - Log | 76 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 4 | ORSC | Resources | 76 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| TOPInventory and Production |
| 5 | AITM | Items - History | 141 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 6 | OITM | Items | 141 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 7 | SITM | Items | 141 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
| 8 | UITM | Items | 141 | QryGroup40 | Property 40 | VarChar | 1 | 0 | N | N=No, Y=Yes |
