Merchant Details File

overview context the merchant details should contain details of all active merchants within your platform file type csv file name \<company name> merchants yyyymmddhhmmss example = \<company name> merchants 20221110233030 company name = your companies name when uploading test files, please append " testing" at the end of the file name example = \<company name> merchants 20221110233030 testing frequency daily files should only contain records for new merchants to be onboarded and/or existing merchants to be offboarded if there are no merchants being added or removed, the daily file can contain a single line with the column headers, and no data records below merchant details data columns column name mandatory format details example environment mandatory valid values are "production" or "testing" production action mandatory valid values are "onboard" or "offboard" onboard registered country mandatory 2 letter (alpha 2) iso 3166 country code sg merchant registration id type mandatory depends on registered country see data dictionary uen merchant registration id mandatory depends on registered country see data dictionary 12345678 merchant legal name mandatory abc trading ltd merchant category code mandatory 4 digit numeric value based on iso 18245 1234 billing descriptor mandatory tim's tiles url mandatory merchant website url www timstiles com company registration date mandatory dd/mm/yyyy 31/01/2001 trading currency mandatory 3 letter, iso 4217 currency code gbp estimated annual tpv mandatory numeric value with no currency symbol 8,000,000 merchant trading name recommended tim's tiles business description recommended tile & bathroom supplies wholesaler registered address line 1 recommended 100 high street registered address line 2 recommended registered city recommended berkhamsted registered postcode / zip recommended standard postcode/zip based on registered country hp1 1ab trading address line 1 recommended 1 london bridge road trading address line 2 recommended trading city recommended london trading postcode / zip recommended standard postcode/zip based on trading country ec1a 1ab trading country recommended 2 letter (alpha 2) iso 3166 country code uk director 1 title recommended mr director 1 first name recommended john director 1 surname recommended smith director 1 home address line 1 recommended 123 high street director 1 home address line 2 recommended director 1 home city recommended berkhamsted director 1 home postcode / zip recommended standard postcode/zip based on country hp1 1 ab director 1 home country recommended 2 letter (alpha 2) iso 3166 country code uk director 1 date of birth recommended dd/mm/yyyy 01/01/1975 director 1 phone number recommended phone number including international dialing code (no spaces) 6580010001 director 1 email address recommended john smith\@timstiles com ubo 1 title recommended mr ubo 1 first name recommended john ubo 1 surname recommended smith ubo 1 home address line 1 recommended 123 high street ubo 1 home address line 2 recommended ubo 1 home city recommended berkhamsted ubo 1 home postcode / zip recommended standard postcode/zip based on country hp1 1 ab ubo 1 home country recommended 2 letter (alpha 2) iso 3166 country code uk ubo 1 date of birth recommended dd/mm/yyyy 01/01/1975 ubo 1 phone number recommended phone number including international dialing code (no spaces) 6580010001 ubo 1 email address recommended john smith\@timstiles com ubo 1 % ownership recommended % value 100% indicates a field is mandatory for envisso risk protection insurance integration only for envisso score & monitor it is a recommended field notes please adhere by the format details of each column provided if a merchant has multiple merchant category codes, urls and/or billing descriptors please send multiple rows for that merchant with the relevant details for merchant registration id please refer to the merchant registration id section of the data dictionary ubo = ultimate beneficial owner to send multiple director or ubo information, please add additional columns and increment the number in the column titles example = ubo 2 first name