Fundings File

overview context all funding/settlement transactions for all merchants on a given day file type csv file name \<company name> funding yyyymmddhhmmss example = \<company name> funding 20221110233030 company name = your companies name when uploading test files, please append " testing" at the end of the file name example = \<company name> funding 20221110233030 testing frequency daily funding data columns column name mandatory format details example environment mandatory valid values are "production" or "testing" production settlement date/time mandatory dd/mm/yyyy hh\ mm\ ss 31/01/2022 16 34 45 transaction id mandatory a13f1609 7854 47a6 b533 339f3ac80be8 authorisation id mandatory b533 339f3ac80be8 100122 merchant registration id mandatory depends on registered country see data dictionary 12345678 payment method mandatory depends on registered country see data dictionary credit card transaction type mandatory valid values are "purchase" & "refund" purchase / refund merchant category code mandatory 4 digit numeric value based on iso 18245 5812 url mandatory merchant website url www timstiles com billing descriptor mandatory tim's tiles scheme mid mandatory mid used within the card scheme network 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 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 the funding file should contain all purchase/sale events, as well as any refunds that occur each funding/settlement should have a corresponding authorisation in the authorisations file (but not neccessarly on the same day) this should be linkable via the authorisation id values in both files scheme mid is the card scheme/network merchant id