| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Accounting |
| 1 | TCCRC | Payment Cards: Check Results | 2 | RCATG | Payment Cards: Check Type | nvarchar | 1 | 0 | | |
| 2 | TCCRCT | Payment cards: Results of checks (texts) | 3 | RCATG | Payment Cards: Check Type | nvarchar | 1 | 0 | | |
| TOPCorporate Performance Monitor |
| 3 | UMR_RI000 | Risk: Category | 2 | RCATG | Risk Category | nvarchar | 10 | 0 | | |
| 4 | UMR_RI000T | Risk: Category Text Table | 2 | RCATG | Risk Category | nvarchar | 10 | 0 | | |
| TOPTravel Planning |
| 5 | FTPT_HOTEL | Travel Request Item - Hotel Service | 69 | RCATG | Preferred Room Category | nvarchar | 1 | 0 | | |
| 6 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 12 | RCATG | Preferred Room Category | nvarchar | 1 | 0 | | |
| 7 | PA0472 | HR master record infotype 0472 (hotel preferences) | 27 | RCATG | Preferred Room Category | nvarchar | 1 | 0 | | |
