| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConfirmations |
| 1 | AFRV | Confirmation pool | 56 | EXLGA | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
| 2 | AFRV_DEL | Backup Copy for Confirmation Pool | 56 | EXLGA | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
| TOPPersonnel Time Management |
| 3 | T5550 | [OBSOLETE; NOW USE T705Q] Ext. Wage Types from Subsystem Txt | 5 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
| 4 | T555W | [OBSOLETE; NOW USE T705K] Ext. Wages Types from Subsystem | 4 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
| 5 | T705K | External Wage Types for Subsystem | 4 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
| 6 | T705Q | External Wage Types Long Texts from Subsystem | 5 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
| 7 | TEVEN | Time Events | 11 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
| 8 | TEXLGA | Employee Expenditures | 10 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
| TOPPlant Data Collection |
| 9 | RUECK | Temp. storage for subsystem confirmations | 51 | EXLGA | Employee Expenditures | nvarchar | 4 | 0 | | |
