TMC Data Import Definition

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