...
Airfare Segment | Field Name | Description | Format | Tab Position |
| RecordType | Default Value must be: A | String | 1 |
RecordLocator | Trip Record locator | String | 2 | |
TripNo | unique id for trip | long | 3 | |
EmployeeId | Databasics user id | String | 4 | |
AirlineName | Name of airline carrier | String | 5 | |
AirlineCode | Airline carrier code for this leg | String | 6 | |
SegmentCost | Cost of this leg | decimal | 7 | |
SegmentCostCurrency | 3 letter currency code | String | 8 | |
ResevationDate | Reservation Date | Date (mm-dd-yyyy) | 9 | |
DepartureDate | Date of departure for this leg | Date (mm-dd-yyyy) | 10 | |
ArrivalDate | Date of arrival for this leg | Date (mm-dd-yyyy) | 11 | |
DepartureAirport | Airport code for originating city for this leg | String | 12 | |
ArrivalAirport | Airport code for destination city for this leg | String | 13 | |
ServiceClass | Class of service for this leg | String | 14 | |
LegNumber | Leg Number | Integer | 15 | |
TicketNo | Ticket number | String | 16 |
Car Rental Segment | Field Name | Description | Format | Tab Position |
| RecordType | Value must be: C |
| 1 |
RecordLocator | Trip Record locator | String | 2 | |
TripNo | unique id for trip | long | 3 | |
EmployeeId | Databasics user id | String | 4 | |
RentalCarAgencyName | Renatl Rental agency name | String | 5 | |
RentalCarAgencyCode | Two-character code that designates rental agency | String | 6 | |
RentalCarAmount | cost | decimal | 7 | |
RentalCarCurrency | 3 letter currency code | String | 8 | |
ResevationDate | Date when reservation is made | Date (mm-dd-yyyy) | 9 | |
PickUpDate | Date when car is picked up from the rental company | Date (mm-dd-yyyy) | 10 | |
DropOffDate | Date whenwhere when car is returned to the rental company | Date (mm-dd-yyyy) | 11 | |
CarPickUpLocation | Originating city where car is picked up from the rental company | String | 12 | |
DropOffLocation | Destination city where car is returned to the rental company | String | 13 | |
CarSizeCategoryCode | Two-character code that designates car class | String | 14 |
Lodging Segment | Field Name | Description | Format | Tab Position |
| RecordType | Value must be: L | String | 1 |
RecordLocator | Trip Record locator | String | 2 | |
TripNo | unique id for trip | long | 3 | |
EmployeeId | Databasics user id | String | 4 | |
HotelName | Hotel name | String | 5 | |
HotelCode | Two-character code that designates hotel chain | String | 6 | |
Amount | cost | decimal | 7 | |
Currency | 3 letter currency code | String | 8 | |
ResevationDate | Reservation date | Date (mm-dd-yyyy) | 9 | |
CheckInDate | The data of check-in or if a no show or advance lodging, the scheduled date. | Date (mm-dd-yyyy) | 10 | |
CheckOutDate | The data of check-out or advance lodging, the scheduled date. | Date(mm-dd-yyyy) | 11 | |
City | City where hotel is located | String | 12 |