| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPExternal personnel administration |
| 1 | HRSM_HEAD | External employee data: Header data | 5 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| 2 | HRSM_PROTOCOL | Assignment of external ID to SAP R/3 personnel number | 5 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| TOPField Service |
| 3 | IWWO | Pervasive Service: Cluster with Internet Data | 11 | PERSON_NO | Personnel number | nvarchar | 8 | 0 | | |
| TOPPersonnel Time Management |
| 4 | HRAAITM | HR Interface Table: Document Item for Activity Allocation | 15 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| TOPSAP Retail Store |
| 5 | WSMAN_PT_BUFFER | Store Manager Portal: Buffer for Availability Display | 2 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| TOPWaste Management |
| 6 | EWA_ORDER_HD_CO | Header Table for Waste Disposal Order (CO Data) | 16 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| 7 | EWA_ORDER_OBJ_CO | Item Table in Waste Disposal Order (CO Data) | 17 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| 8 | EWA_ORDER_WGH_CO | Weighing Data Table for Waste Disposal Order (CO Data) | 17 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
| 9 | EWA_WA_WPROC_CO | Weighing Transaction (CO Data) | 16 | PERSON_NO | Personnel Number | nvarchar | 8 | 0 | | |
