| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Expenses |
| 1 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 10 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 2 | PTRV_HEAD | General Trip Data | 10 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 3 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 15 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 4 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 12 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 5 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 12 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 6 | T702H | Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 7 | T702R | Trip Activity Types | 3 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 8 | T702V | Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 9 | T706A | Trip Provision Deduction Amount/Percentage | 6 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 10 | T706B | Travel Expense Types | 4 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 11 | T706B2 | Travel Expense Types: Default Value/Maximum Amounts | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 12 | T706D | Default Values for Dialog | 4 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 13 | T706F | Trip Provision: Flat Rates for Travel Costs | 4 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 14 | T706H | Trip Provision:Per-diem/Maximum Amount for Meals by Time | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 15 | T706R | Names for trip activity types | 4 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 16 | T706S | Trip Schema | 17 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 17 | T706U | Trip Provision: Per Diem for Accommodations | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 18 | T706V | Trip Provision: Meals Per-diem/Maximum Amount by Hours | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 19 | T706_COST_CP | Cost Comparison on Trip Level: Maximum Difference | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| TOPTravel Planning |
| 20 | FTPT_CAR | Travel Request Item - Car Rental Service | 57 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 21 | FTPT_FLIGHT | Travel Request Item - Flight Service | 34 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 22 | FTPT_HOTEL | Travel Request Item - Hotel Service | 57 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 23 | FTPT_REQUEST | Travel Plan Requests | 50 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 24 | FTPT_TM_MEMO | Memo table for Travel Management | 7 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 25 | TA20PHC | Assignment Table of Hotel Catalog Items for Travel Profiles | 3 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 26 | TA20PPI | Assignment Table of Trip Rules for Travel Profiles | 5 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 27 | TA20PPT | Assignment Table of Trip Rules for Travel Profiles | 3 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
| 28 | TA22B | Assignment trip schema - travel plan type | 4 | KZTKT | Trip Activity Type | nvarchar | 1 | 0 | | |
