Authorisations File
Overview
Context: All authorisations for all merchants on a given day.
File Type: CSV
File Name: <company_name>_authorisations_YYYYMMDDHHMMss
- 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 |
* IP address is mandatory for all transactions where channel is "Online".
† Terminal ID is mandatory for all transactions where channel is "POS".
Notes
- Please adhere by the format details of each column provided.