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 |
...