| 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 | 10 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |
2 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 18 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |
3 | PTRV_COMP | Comparison Calculation Results PS | 20 | DATB1 | Fictitious End of Trip (Comparision Calculation) | nvarchar | 8 | 0 | | |
4 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 31 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |
5 | PTRV_HEAD | General Trip Data | 18 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |
6 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 24 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |
7 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 24 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |
TOPTravel Planning |
8 | FTPT_TM_MEMO | Memo table for Travel Management | 14 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | | |