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