| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBelgium |
| 1 | T5B9A | Institutions (B) | 25 | PERNO | Appointed person personnel number | nvarchar | 8 | 0 | | |
| TOPClaims Processing Asia |
| 2 | T7XAS6 | Claim variant for Plan | 5 | PERNO | No. of units | decimal | 3 | 0 | | |
| TOPHong Kong |
| 3 | PA0348 | HR Master Record: Infotype 0348 (HK Appraisal and bonus) | 29 | PERNO | Personnel Number | nvarchar | 8 | 0 | | |
| TOPMalaysia |
| 4 | T5LRN | Tax Reporting Receipt no table | 5 | PERNO | Personnel number | nvarchar | 8 | 0 | | |
| 5 | T5LSQ | Serial no Table for EA form - Malaysia | 6 | PERNO | Personnel number | nvarchar | 8 | 0 | | |
| TOPUse AP-MD-BP Components |
| 6 | BUT000 | BP: General data I | 68 | PERNO | Personnel Number | nvarchar | 8 | 0 | | |
| 7 | BUT000_TD | BP: General Data I, Shadow Table Time Dependency | 69 | PERNO | Personnel Number | nvarchar | 8 | 0 | | |
| 8 | BUT000_TDS | BP: General Data I, Shadow Table Time Dependency | 70 | PERNO | Personnel Number | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Application |
| 9 | WFAEM_START_DATE | Start date of the employee | 2 | PERNO | Personnel Number | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Core |
| 10 | WFMEM_START_DATE | Start date of the employee | 2 | PERNO | Personnel Number | nvarchar | 8 | 0 | | |
