| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBenefits |
| 1 | PA0171 | HR Master Record: Infotype 0171 (Gen. Benefits Information) | 31 | SMOKE | Benefit smoker indicator | nvarchar | 1 | 0 | | |
| 2 | PA0376 | HR Master Data Record: Infotype 0376 (Medical Benefits Info) | 30 | SMOKE | Benefit smoker indicator | nvarchar | 1 | 0 | | |
| 3 | T5UBI | Benefit cost rule | 10 | SMOKE | Benefit smoker indicator | nvarchar | 1 | 0 | | |
| TOPGeneral Parts |
| 4 | T74_FBN_GB05 | Flexible Benefits Employee Pension Contribution Rule (GB) | 10 | SMOKE | Benefit smoker indicator | nvarchar | 1 | 0 | | |
| TOPTravel Planning |
| 5 | FTPT_CAR | Travel Request Item - Car Rental Service | 63 | SMOKE | Nonsmoking Car Requested | nvarchar | 1 | 0 | | |
| 6 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 9 | SMOKE | Nonsmoking Car Requested | nvarchar | 1 | 0 | | |
| 7 | FTPT_HOTEL | Travel Request Item - Hotel Service | 66 | SMOKE | Nonsmoking Room Requested | nvarchar | 1 | 0 | | |
| 8 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 9 | SMOKE | Nonsmoking Room Requested | nvarchar | 1 | 0 | | |
| 9 | PA0471 | HR master record infotype 0471 (flight preferences) | 24 | SMOKE | Smoker/Nonsmoker | nvarchar | 1 | 0 | | |
| 10 | PA0472 | HR master record infotype 0472 (hotel preferences) | 24 | SMOKE | Nonsmoking Room Requested | nvarchar | 1 | 0 | | |
| 11 | PA0473 | HR master record infotype 0473 (rental car preferences) | 24 | SMOKE | Nonsmoking Car Requested | nvarchar | 1 | 0 | | |
| 12 | PA0474 | HR master record infotype 0474 (train preferences) | 24 | SMOKE | Smoker/Nonsmoker | nvarchar | 1 | 0 | | |
| TOPUSA |
| 13 | PA0106 | HR Master Record: Infotype 0106 (Related Persons NA) | 48 | SMOKE | Benefit smoker indicator | nvarchar | 1 | 0 | | |
