| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PTRV_DELETE_LOG | Log Table for Deleted Trips | 12 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |
TOPTravel Expenses |
2 | PTRV_ARCH_PERIO | Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) | 13 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |
3 | PTRV_CHANGE | Change to Trip | 12 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |
4 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 33 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |
5 | PTRV_PERIO | Period Data of a Trip | 13 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |
6 | PTRV_VERSION | History Table | 16 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |
TOPTravel Management |
7 | FITV_REJECT | Rejected Trips | 12 | ABREC | Open / To be Settled / Settled (Indicator) | nvarchar | 1 | 0 | | |