| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Expenses |
| 1 | PTRV_ARCHIVE | Administrative Table for Archived Trip Data | 9 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
| 2 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 16 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
| 3 | PTRV_COMP | Comparison Calculation Results PS | 19 | DATV1 | Fictitious Start of Trip (Comparison Calculation | nvarchar | 8 | 0 | | |
| 4 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 30 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
| 5 | PTRV_HEAD | General Trip Data | 16 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
| 6 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 22 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
| 7 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 22 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
| TOPTravel Planning |
| 8 | FTPT_TM_MEMO | Memo table for Travel Management | 12 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
