| 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) | 8 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 2 | PTRV_HEAD | General Trip Data | 8 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 3 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 14 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 4 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 10 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 5 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 10 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 6 | T702G | Statutory trip types | 3 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 7 | T702H | Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 8 | T702V | Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 9 | T706A | Trip Provision Deduction Amount/Percentage | 5 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 10 | T706B | Travel Expense Types | 3 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 11 | T706B2 | Travel Expense Types: Default Value/Maximum Amounts | 3 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 12 | T706D | Default Values for Dialog | 3 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 13 | T706F | Trip Provision: Flat Rates for Travel Costs | 3 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 14 | T706G | Names for statutory trip types | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 15 | T706H | Trip Provision:Per-diem/Maximum Amount for Meals by Time | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 16 | T706S | Trip Schema | 16 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 17 | T706T_ABWH | Texts for Absence Types (PS Separation Allowance) | 5 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 18 | T706U | Trip Provision: Per Diem for Accommodations | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 19 | T706V | Trip Provision: Meals Per-diem/Maximum Amount by Hours | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 20 | T706_ABWH | Absence Types from Place of Work (PS; Separation Allowance) | 4 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 21 | T706_COST_CP | Cost Comparison on Trip Level: Maximum Difference | 3 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| TOPTravel Planning |
| 22 | FTPT_REQUEST | Travel Plan Requests | 48 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
| 23 | FTPT_TM_MEMO | Memo table for Travel Management | 5 | KZREA | Trip Type: Statutory | nvarchar | 1 | 0 | | |
