> ## Documentation Index
> Fetch the complete documentation index at: https://developers.pcibooking.net/llms.txt
> Use this file to discover all available pages before exploring further.

# File Transfer Formats

> Supported file formats for SFTP/FTPS tokenization and token replacement: TADC XML, AMEX CSV, and standard delimited formats.

PCI Booking supports several file formats for [file transfer tokenization](/capture-cards/file-transfer-tokenization) and [file transfer token replacement](/use-tokens/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:

<a href="/public/tadc-schema.xsd" download>Download TADC XML Schema (tadc-schema.xsd)</a>

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:

<a href="/public/tadc-example.xml" download>Download TADC Example File (tadc-example.xml)</a>

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

```text theme={null}
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.

<a href="/public/amex-csv-example.csv" download>Download AMEX CSV Example (amex-csv-example.csv)</a>

## 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](/account-setup/target-profiles) or [tokenization profiles](/api-reference/tokenize-cards/get-tokenization-profiles).

## Related

<CardGroup cols={2}>
  <Card title="File Transfer Tokenization" icon="book" href="/capture-cards/file-transfer-tokenization">
    Tokenize card data in SFTP/FTPS file transfers
  </Card>

  <Card title="File Transfer Token Replacement" icon="book" href="/use-tokens/file-transfer-token-replacement">
    Replace tokens with card data in outbound file transfers
  </Card>
</CardGroup>