| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPChina |
| 1 | T7CN69 | Project or Achievement Related Infomation | 11 | PROFI | Project profit | nvarchar | 20 | 0 | | |
| TOPData Collection |
| 2 | CF750 | MCRED | 16 | PROFI | Profit | decimal | 15 | 2 | | |
| TOPMaintenance Processing |
| 3 | /MRSS/D_BAS_REQQ | Required Qualifications for Demands | 9 | PROFI | Optimum Required Qualification Proficiency | nvarchar | 4 | 0 | | |
| 4 | /MRSS/D_RES_QUAL | Resource Qualifications | 12 | PROFI | Optimum Required Qualification Proficiency | nvarchar | 4 | 0 | | |
| TOPMobile data entry |
| 5 | T313A | Determination of Verification Profile | 6 | PROFI | Verification profile for mobile data entry | nvarchar | 6 | 0 | | |
| 6 | T313B | Definition of Verification Profile | 3 | PROFI | Verification profile for mobile data entry | nvarchar | 6 | 0 | | |
| TOPSequencing |
| 7 | TSPG3 | Relationship between order profile and characteristics | 2 | PROFI | Order profile (color assignment) | nvarchar | 10 | 0 | | |
| 8 | TSPG4 | Relationship between charact. values, colors and profile | 3 | PROFI | Order profile (color assignment) | nvarchar | 10 | 0 | | |
| TOPWorkforce Management Core |
| 9 | /SAPAPO/LRPRQPRO | Qualifications Profile | 10 | PROFI | Proficiency of a Qualification | nvarchar | 4 | 0 | | |
| 10 | /SAPAPO/LRPSQPRO | Qualifications Profile | 10 | PROFI | Proficiency of a Qualification | nvarchar | 4 | 0 | | |
