| 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) | 4 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
2 | PTRV_ARCH_PERIO | Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) | 6 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
3 | PTRV_HEAD | General Trip Data | 4 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
4 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 4 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
5 | PTRV_PERIO | Period Data of a Trip | 6 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
6 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 4 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
7 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 4 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |
8 | PTRV_VERSION | History Table | 8 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | |