| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | DFKKRDI_PERIOD | Assignment of Distribution Periods to Distribution Groups | 5 | DATE_BEG | Start Date of Distribution Period | nvarchar | 8 | 0 | | |
TOPTravel Expenses |
2 | T706_REQ_CAT | Types of Transport/Accomm. and Est.Cost of Travel Request | 5 | DATE_BEG | Start Date | nvarchar | 8 | 0 | | |
TOPTravel Planning |
3 | FTPT_CAR | Travel Request Item - Car Rental Service | 10 | DATE_BEG | Start Date for Rental Car | nvarchar | 8 | 0 | | |
4 | FTPT_ITEM | Travel Service Request Item | 11 | DATE_BEG | Start Date of Request Item | nvarchar | 8 | 0 | | |
5 | FTPT_OTHER | Travel Reservation Request Item - Other Service | 11 | DATE_BEG | Start Date of Other Service | nvarchar | 8 | 0 | | |
6 | FTPT_PLAN | General Plan Data | 5 | DATE_BEG | Start Date of Travel Plan | nvarchar | 8 | 0 | | |
7 | FTPT_PLANHISTORY | General Plan Data | 6 | DATE_BEG | Start Date of Travel Plan | nvarchar | 8 | 0 | | |
8 | FTPT_QT_ITEM | Quicktrip Travel Service Request Item | 7 | DATE_BEG | Start Date of Request Item | nvarchar | 8 | 0 | | |
9 | FTPT_REQUEST | Travel Plan Requests | 11 | DATE_BEG | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
10 | FTPT_REQ_HEAD | Framework Data of Travel Request | 9 | DATE_BEG | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | |
11 | TA23OS | Field Control for Travel Res. Request Item: Other Services | 5 | DATE_BEG | Field Control Start Date | nvarchar | 1 | 0 | | |