Old File Format for Upload
Guide to formatting the standard booking file for all upload methods.
Last updated
Guide to formatting the standard booking file for all upload methods.
Last updated
The standard file format is due to be sunset on 31 December 2023. New implementations should go straight the the extended file format. For those looking to set up/migrate please review the extended file format documentation and contact your account manager or email support@travelledger.org if you wish to access to our sandbox environment.
Below is a guide to the format required for the standard file to be imported into Travel Ledger. The file can be uploaded manually or automatically.
The format of the file can be either .TXT, .DAT or .CSV, all are accepted by the platform.
The Seller Invoice file will contain a header record, transaction record and trailer record.
The transaction record is followed by 0 - 99999 transaction records.
The file should have a fixed record size of 38 chars.
Field sizes are fixed.
All alphanumeric and text fields are left justified and padded with spaces.
All numeric fields are right justified and padded with zeroes with the sign ‘-‘ as the first digit on the left if the value is a credit.
Only numeric digits are transmitted for decimal numbers, the position of the decimal point is inferred as shown in the value columns of the following table. (Operator = Seller / Travel Agent = Buyer)
Invoice File Format Example:
HHHSG77709APR21 (tour op abta number or reference number)
TRASG888HQ01004 GREEN 23MAY210010000 (booking ref number)
TRASG888HQ01008 TREASU29MAY210005000 (lead name)
TRASG888HQ01009 BOAT 30MAY210045998 (departure date)
TRASG888HQ1010 SMITH 06JUN210799999 (value of booking, 7999.99)
ZZZ00004000860997 (transaction count in the file/total amount of the value of the submitted transactions)
Please note, in order to support files created by different operating systems, files can have an end of line (EoL) indicator of "[LF]" (Line Feed/Unix), or "[CR]" (Carriage Return/Mac) or "[CR][LF]" (Windows).
For guidance on formatting the extended file format, see the link below:
For method specific guidance on file upload, select one of the following links:
Field Name
Description
Type
Header ID
Header Record Identifier
3 char, value 'HHH'
Operator ABTA Number
Operator ABTA Number
5 char, alphanumeric
Date Created
Date File Created
7 char, date in format 'DDMMMYY'
Filler
Filler
23 char
Field Name
Description
Type
Tran ID
Transaction Record Identifier
3 char, value 'TRA'
Travel Agent ABTA Number
Agent ABTA Number
5 char, alphanumeric
Booking Reference
Holiday Booking Reference
10 char, alphanumeric
Lead Name
Short Customer Name
6 char, alphanumeric
Departure Date
Holiday Departure Date
7 char, date in format 'DDMMMYY'
Transaction Amount
Payment Amount
7 char, numeric, 2 implied decimals
-9999.99 to 99999.99
(-999999 to 9999999)
-ve to debit Operator
+ve to credit Operator
Field Name
Description
Type
Trailer ID
Trailer Record Identifier
3 char, value 'ZZZ'
Number of Records
Number of transaction records on the Transfer File
5 char, numeric
Total Value
Total Value of transactions on the Transfer File
9 char, numeric, 2 implied decimals
-9999.99 to 9999999.99
(-999999 to 999999999)
Filler
Filler
22 char