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