| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLocalization |
1 | GLO_PTRV_TRANSP | Reimbursement Amounts for Transport | 8 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
TOPTravel Expenses |
2 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 28 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
3 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 14 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
4 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 14 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
5 | T702H | Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
6 | T702O | Trip country/Trip region/Trip country group | 4 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
7 | T702V | Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
8 | T706B | Travel Expense Types | 6 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
9 | T706B2 | Travel Expense Types: Default Value/Maximum Amounts | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
10 | T706F | Trip Provision: Flat Rates for Travel Costs | 6 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
11 | T706H | Trip Provision:Per-diem/Maximum Amount for Meals by Time | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
12 | T706L | Assignment of Trip Country - Country Group - Region | 4 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
13 | T706M | Input Tax for International Per Diems | 4 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
14 | T706O | Names for Trip Country/Trip Country Group/Trip Region | 5 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
15 | T706S | Trip Schema | 15 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
16 | T706U | Trip Provision: Per Diem for Accommodations | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
17 | T706V | Trip Provision: Meals Per-diem/Maximum Amount by Hours | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
18 | T706_COST_CP | Cost Comparison on Trip Level: Maximum Difference | 7 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |
TOPTravel Planning |
19 | FTPT_REQUEST | Travel Plan Requests | 36 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | |