| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPTravel Expenses |
| 1 | FTPT_REQ_CAT | Type of Transport/Accomm. and Est.Cost of Travel Request | 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
| 2 | PTRV_VERSION | History Table | 9 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
| TOPTravel Planning |
| 3 | FTPT_REQUEST | Travel Plan Requests | 7 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
| 4 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
| 5 | FTPT_REQ_ADVANCE | Travel Request Advance | 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
| 6 | FTPT_REQ_HEAD | Framework Data of Travel Request | 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
| 7 | FTPT_REQ_REASON | Reason for Travel Request | 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | |
