| 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) | 17 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | |
2 | PTRV_BEIH_TAG | Assignment of Days to a Subsidy for Trips Home | 8 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | |
3 | PTRV_COMP | Comparison Calculation Results PS | 21 | UHRV1 | Fictitious Start Time (Comparison Calculation) | nvarchar | 6 | 0 | | |
4 | PTRV_HEAD | General Trip Data | 17 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | |
5 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 23 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | |
6 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 23 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | |
TOPTravel Planning |
7 | FTPT_TM_MEMO | Memo table for Travel Management | 13 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | |