| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | PLAN_REQUEST | Plan Request Indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | LOCATION_END | Trip Destination | nvarchar | 59 | 0 | | | | Allow NULL? |
| 7 | COUNTRY_END | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | REQUEST_REASON | Reason for Trip | nvarchar | 59 | 0 | | | | Allow NULL? |
| 9 | DATE_BEG | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | TIME_BEG | Start Time of Trip Segment | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | DATE_END | End Date of Trip Segment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | TIME_END | End Time of Trip Segment | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | ACTIVITY_TYPE | Trip Activity Type | char | 1 | 0 | | | | Allow NULL? |
| 14 | ESTIMATED_COST | Estimated Total Cost of Trip | decimal | 13 | 2 | | | | |
| 15 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | STATUS | Travel Plan Status | char | 1 | 0 | | | | Allow NULL? |
| 17 | DATES | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | TIMES | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 20 | REPID | Change Report | nvarchar | 40 | 0 | | | | Allow NULL? |
| 21 | DEPAR | Departure from Residence or Place of Work | char | 1 | 0 | | | | Allow NULL? |
| 22 | CREATEDBY | User Who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | APPROVEDBY | Agent Who Approved the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | DELIVERY_DATE | Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | DELIVERY_LOC | Delivery Location | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | DELIVERY_AREA | Delivery Area | nvarchar | 64 | 0 | | | | Allow NULL? |
| 27 | DELIVERY_EMPL | Recipient of Delivery | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | ARRIVAL_WORK | Arrival at Accommodations/New Place of Work | char | 1 | 0 | | | | Allow NULL? |
| 29 | RETURN_WORK | Arrival at Home/Workplace | char | 1 | 0 | | | | Allow NULL? |
| 30 | T_ACTYPE | Trip Activity Type | char | 1 | 0 | | | | Allow NULL? |
| 31 | PERM_TRIP_APPR | Standing Approval of Business Trips | char | 1 | 0 | | | | Allow NULL? |
| 32 | TT_STATU | Trip Type: Statutory | char | 1 | 0 | | | | Allow NULL? |
| 33 | TT_COMSP | Trip Type: Enterprise-Specific | char | 1 | 0 | | | | Allow NULL? |
| 34 | GWE | Request for Full Trip Segment Reimbursement | char | 1 | 0 | | | | Allow NULL? |
| 35 | EDI | Significant Official Interest | char | 1 | 0 | | | | Allow NULL? |
| 36 | CARRY_OTH | Number of Employees Carpooling with Me (as the driver) | char | 1 | 0 | | | | Allow NULL? |
| 37 | CARRIED_BY_OTH | Employee is carpooling as a passenger with another employee | char | 1 | 0 | | | | Allow NULL? |
| 38 | DATECOW | Date of Commencement of Work | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | TIMECOW | Time at Which Work Commences | nvarchar | 6 | 0 | | | | Allow NULL? |
| 40 | DATEEOW | Date on Which Work Ends | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | TIMEEOW | Time at Which Work Ends | nvarchar | 6 | 0 | | | | Allow NULL? |
