The DATABASICS Booking Import program allows you to import booking data from any booking system or travel agency systems on daily or weekly bases to integrate with DATABASICS Expense.
File Type | CSV, Text (Tab Delimited) | |
Location | FTP Provided by DATABASICS per customer | |
File Definition
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 | 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 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 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 | 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 |