File Transfer Formats

PCI Booking supports several file formats for file transfer tokenization and file transfer token replacement. This page provides format specifications and downloadable examples.

Supported Formats

Format	Type	Use Case
Delimited	CSV, TSV, or custom delimiter	General-purpose flat file tokenization
TADC	XML	Travel Agency Data Capture format (AMEX travel reconciliation)
AMEX CSV	CSV	AMEX-specific card data format
AIR	Fixed-width	Airline industry record format
IUR	Fixed-width	Insurance/utility record format

TADC (Travel Agency Data Capture)

TADC is an XML format used by American Express for travel industry card data reconciliation. PCI Booking can tokenize card numbers within TADC files during SFTP/FTPS transfer, and replace tokens with real card data when sending TADC files outbound.

TADC XML Schema (XSD)

The full XML Schema Definition for validating TADC files is available for download: Download TADC XML Schema (tadc-schema.xsd) The schema defines the complete structure including:

Message root element with version, submitter ID, and sequence numbers
TravelBatch elements containing provider and currency info
TravelTran elements with transaction details, card data, and travel segments
Date, amount, and card number format restrictions

TADC Example File

A complete example TADC XML file with realistic (masked) data is available for download: Download TADC Example File (tadc-example.xml) The example includes multiple travel batches with air, hotel, and car rental transactions.

AMEX CSV

The AMEX CSV format is a semicolon-delimited file used for AMEX card data exchange. Each row represents one transaction.

Example

6JC5EE/1;3723******468;EUR;359.1;20200121;F-001 1813000;The Manor Amsterdam;Amsterdam;Netherlands;00 31 99 999 9999;Linnaeusstraat 89;na;3;OFF;https://www.hcorpo.com/book/pnr/6JC5EE;Vernon.bear@customer.FR;12;99999999999;BOUILLO;FG10;SR;DACLIN;na;na;na
TMPBLX/1;3723*****6732;EUR;239.4;20200121;F-001 1814000;The Manor Amsterdam;Amsterdam;Netherlands;00 31 99 999 9999;Linnaeusstraat 89;na;2;OFF;https://www.hcorpo.com/book/pnr/TMPBLX;Vernon.bear@customer.FR;FG10;9999999999;bouillo;fg10;SR;HADJIEV;na;na;na
PF292G/1;3723*****3606;EUR;257.04;20200121;F-001 1812899;The Manor Amsterdam;Amsterdam;Netherlands;00 31 99 999 9999;Linnaeusstraat 89;na;2;OFF;https://www.hcorpo.com/book/pnr/PF292G;Vernon.bear@customer.FR;12;99999999999;bouillo;fg10;SR;jaganna;na;na;na

The card number field (second column) is tokenized/detokenized by PCI Booking during file transfer. Download AMEX CSV Example (amex-csv-example.csv)

Delimited Formats (CSV, TSV)

For standard delimited files, PCI Booking identifies card numbers by column position or pattern matching. Configure the column mapping through target profiles or tokenization profiles.

File Transfer Tokenization

Tokenize card data in SFTP/FTPS file transfers

File Transfer Token Replacement

Replace tokens with card data in outbound file transfers

Start Here

Getting Started

Guides

Concepts

Capture Cards

Payments Library

Manage Tokens

Use Tokens

Account Configuration

Additional Functions

Reference

Support

File Transfer Formats

Supported Formats

TADC (Travel Agency Data Capture)

TADC XML Schema (XSD)

TADC Example File

AMEX CSV

Example

Delimited Formats (CSV, TSV)

File Transfer Tokenization

File Transfer Token Replacement

​Supported Formats

​TADC (Travel Agency Data Capture)

​TADC XML Schema (XSD)

​TADC Example File

​AMEX CSV

​Example

​Delimited Formats (CSV, TSV)

​Related

File Transfer Tokenization

File Transfer Token Replacement

Supported Formats

TADC (Travel Agency Data Capture)

TADC XML Schema (XSD)

TADC Example File

AMEX CSV

Example

Delimited Formats (CSV, TSV)

Related