| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RD_ANVERS | Payroll Result - Cluster RD: Structure for Imp. on Pension | 17 | BEREI | Adjusted Amount | decimal | 9 | 2 | | |
| TOPTravel Expenses |
| 2 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 9 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 3 | PTRV_HEAD | General Trip Data | 9 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 4 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 17 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 5 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 11 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 6 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 11 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 7 | T702H | Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time | 8 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 8 | T702V | Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours | 8 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 9 | T702X | Enterprise-specific Trip Types | 3 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 10 | T706B | Travel Expense Types | 7 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 11 | T706B2 | Travel Expense Types: Default Value/Maximum Amounts | 4 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 12 | T706F | Trip Provision: Flat Rates for Travel Costs | 7 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 13 | T706H | Trip Provision:Per-diem/Maximum Amount for Meals by Time | 8 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 14 | T706S | Trip Schema | 13 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 15 | T706U | Trip Provision: Per Diem for Accommodations | 8 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 16 | T706V | Trip Provision: Meals Per-diem/Maximum Amount by Hours | 8 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 17 | T706X | Names for enterprise-specific trip types | 4 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 18 | T706_COST_CP | Cost Comparison on Trip Level: Maximum Difference | 4 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| TOPTravel Planning |
| 19 | FTPT_REQUEST | Travel Plan Requests | 49 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
| 20 | FTPT_TM_MEMO | Memo table for Travel Management | 6 | BEREI | Trip Type: Enterprise-Specific | nvarchar | 1 | 0 | | |
