| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBrazil |
| 1 | T7BRTM | Punch clock codes | 2 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| TOPConfirmations |
| 2 | AFRV | Confirmation pool | 54 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| 3 | AFRV_DEL | Backup Copy for Confirmation Pool | 54 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| TOPPersonnel Time Events |
| 4 | TPTCOR_CORE | Core Information (Correction Scenario) | 11 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| TOPPersonnel Time Management |
| 5 | CC1ERP | Incorrect Time Events from CC1, Postings | 11 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| 6 | CC1TEV | Temporary Buffer for Time Events from CC1 | 10 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| 7 | TEVEN | Time Events | 9 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| 8 | TEVEN_MORE | Additional Data for Time Events | 10 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| 9 | TEXLGA | Employee Expenditures | 9 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| TOPPlant Data Collection |
| 10 | RUECK | Temp. storage for subsystem confirmations | 49 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| TOPProduct Cost Planning |
| 11 | TCK01 | Costing Types | 15 | TERID | Date Control | nvarchar | 4 | 0 | | |
| 12 | TCK03 | Costing Variants | 36 | TERID | Date Control | nvarchar | 4 | 0 | | |
| 13 | TCK16 | Date Control | 2 | TERID | Date Control | nvarchar | 4 | 0 | | |
| 14 | TCK17 | Date Control - Descriptions | 3 | TERID | Date Control | nvarchar | 4 | 0 | | |
| TOPTime Tickets |
| 15 | EVHR | HR Order Confirmations (Times/Time Events) | 10 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
| 16 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 10 | TERID | Terminal ID | nvarchar | 4 | 0 | | |
