---
title: Authorisations File
slug: authorisations-file
createdAt: 2023-09-02T14:15:32.094Z
---

# Overview

**Context:&#x20;**&#x41;ll authorisations for all merchants on a given day.&#x20;

**File Type**: CSV

**File Name**: \<company\_name>\_authorisations\_YYYYMMDDHHMMss&#x20;

- Example = \<company\_name>\_authorisations\_20221110233030
- company\_name = your companies name
- When uploading test files, please append "\_testing" at the end of the file name
  - Example = \<company\_name>\_authorisations\_20221110233030\_testing

**Frequency**: Daily

# Authorisations - Data Columns

| **Column Name**             | **Mandatory** | **Format Details**                                     | **Example**                             |
| --------------------------- | ------------- | ------------------------------------------------------ | --------------------------------------- |
| Environment                 | Mandatory     | Valid values are: "Production" or "Testing"            | Production                              |
| Authorisation Date/Time     | Mandatory     | DD/MM/YYYY HH\:mm\:SS                                  | 31/01/2022 16:34:45                     |
| Authorisation ID            | Mandatory     |                                                        | a13f1609-7854-47a6-b533-339f3ac80be8    |
| Merchant Registration ID    | Mandatory     | Depends on registered country - see data dictionary    | 12345678-000-11-22-3                    |
| Merchant Category Code      | Mandatory     | 4 digit numeric value based on ISO 18245               | 5812                                    |
| URL                         | Mandatory     | Merchant website URL                                   |                                         |
| Scheme MID                  | Mandatory     |                                                        | 123456                                  |
| Billing Descriptor          | Mandatory     |                                                        | Tim's Tiles                             |
| Authorisation Type          | Mandatory     | Valid values are: "Authorisation" & "Refund"           | Authorisation / Refund                  |
| Authorisation Status        | Mandatory     | Valid values are: "Processed" & "Declined"             | Processed / Declined                    |
| Authorisation Status Reason | Mandatory     | Examples include: "Insufficient funds" & "Invalid CVV" | Null / Insufficient funds / Invalid CVV |
| Card Bin                    | Mandatory     | First 6 digits of the card number.                     | 512345                                  |
| Transaction Currency        | Mandatory     | 3 letter, ISO 4217 currency code                       | USD                                     |
| Transaction Amount          | Mandatory     | Numeric value with no currency symbol.                 | 100                                     |
| Channel                     | Mandatory     | Valid values are: "POS", "Online" & "Other"            | POS / Online / Other                    |
| IP Address                  | Mandatory\*   | IPv6 or IPv4                                           | 101.100.10.100                          |
| Terminal ID                 | Mandatory†    |                                                        | 10350001                                |
| Authentication Method       | Optional      | Examples include: "3DS" & "PIN"                        | 3DS                                     |

&#x20;\* IP address is mandatory for all transactions where channel is "Online".

&#x20;† Terminal ID is mandatory for all transactions where channel is "POS".

**Notes**

- Please adhere by the format details of each column provided.

