| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCross-Application Components |
| 1 | AAUUFK | Order master data | 22 | ASTNR | Order status | nvarchar | 2 | 0 | | |
| TOPOperative Structures |
| 2 | PROJ | Project definition | 16 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| 3 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 14 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| 4 | TCJ05 | Project applicant | 2 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| TOPOverhead Cost Orders |
| 5 | AUFK | Order master data | 22 | ASTNR | Order status | nvarchar | 2 | 0 | | |
| 6 | TKO03 | Order status | 3 | ASTNR | Order status | nvarchar | 2 | 0 | | |
| 7 | TKO04 | Order Status Descriptions | 4 | ASTNR | Order status | nvarchar | 2 | 0 | | |
| TOPProject Summarization |
| 8 | PSERB | Inheritance data, Project System | 9 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| TOPSimulation |
| 9 | VSAUFK_CN | Version: Order master data | 23 | ASTNR | Order status | nvarchar | 2 | 0 | | |
| 10 | VSPROJ_CN | Version: Project definition | 17 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| 11 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 15 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| TOPTemplates |
| 12 | PROJS | Standard project definition | 16 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
| 13 | PRPSS | Standard WBS Element (WBS element) - Master Data | 14 | ASTNR | Applicant number | nvarchar | 8 | 0 | | |
