| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FITV_MEAL_ACCOM | Additional Amounts for Meals in Accommodations Receipts | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
2 | FITV_NOT_CH_TR | Key Fields of Temp. Non-Changeable Trips/Duty Allocation | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
TOPLocalization |
3 | GLO_PTRV_TRANSP | Reimbursement Amounts for Transport | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
TOPTravel Expenses |
4 | FITV_HINZ_WERB_B | Additional Amounts and Income-Related Expenses for Receipts | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
5 | FITV_HINZ_WERB_S | Additional Amounts and Income-Related Expenses | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
6 | PTRV_ARCH_PERIO | Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
7 | PTRV_BEIH_BEL | Assignment of Receipts to a Subsidy for Trips Home | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
8 | PTRV_BEIH_TAG | Assignment of Days to a Subsidy for Trips Home | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
9 | PTRV_BEIH_WEG | Assignment of Trip Segments to a Subsidy for Trips Home | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
10 | PTRV_CHANGE | Change to Trip | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
11 | PTRV_COMM_AMT | Detail Data: Transfer to FM When Trip Saved | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
12 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
13 | PTRV_COMP | Comparison Calculation Results PS | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
14 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 6 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
15 | PTRV_PERIO | Period Data of a Trip | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
16 | PTRV_REASGN_FM | Conversion of FM Data in Trip (e.g. Fiscal Year Change) | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
17 | PTRV_RECDETAIL | Participant(s) in Entertainment Receipts | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
18 | PTRV_ROT_AWKEY | Assignment of Trip Results to Posting Doc. Number and Line | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
19 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 6 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
20 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 6 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
21 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |
22 | PTRV_VERSION | History Table | 7 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | |