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