This report captures status information of all applications / accounts for ISVs under a partner that are pending during the onboarding process (excludes terminal statuses i.e. Withdrawn, Enabled, Rejected in Risk). Further, ISVs can develop the merchant onboarding pipeline and conduct appropriate analysis utilizing reports.
The report also captures the following statuses:
- Simplified Onboarding App form: ‘Registration pending’, ‘Business info pending’, ‘Owner Info pending’, ‘KYC check pending’, ‘Bank Info Pending’, ‘Bank Documents Pending’, ‘Submit Pending’.
- Credit Underwriting: ‘Processing’, ‘Approved’ (excludes terminal statuses i.e. ‘Withdrawn’, ‘Enabled’, ‘Disabled’, ‘Rejected in Risk’).
This report processes two sets of data - a) Before the merchant application is submitted b) After the merchant application is submitted. The creation date definition varies for these two sets of data.
- CREATION_DATE (before the merchant application is submitted): If the merchant application is not submitted, the creation date corresponds to the day when the application was first accessed by the merchant.
- CREATION_DATE (after the merchant application is submitted): Once the merchant application is submitted, the creation date corresponds to the day when the merchant application is actually submitted.
There are a number of fields that get populated only after the merchant application is submitted. These fields will have the value "NA" before the merchant application is submitted: (PRODUCT_NAME,PRODUCT_ID,ACCOUNT_ID,ACCOUNT_NAME,LEGAL NAME, COUNTRY, PROCESSING_CURRENCY, BUSINESS_CATEGORY, LAST_COMMENT_ENTERED, ON_HOLD_INDICATOR, ON_HOLD_REASON_CODE, ON_HOLD_REASON, NOTE, AMEX_MID, PROCESSING_TYPE, AGENT_PROFILE_1, AGENT_PROFILE_2, DEFAULT_BANK, ENABLED_DATE)
By default the report returns data for CREATION_DATE = (Current date (UTC) - 30 days) to Current date
|Column||Column Header Description||Definition||Data Type||Sample Value|
|A||APPLICATION_ID||This is the unique id created for merchant application||String||XYZ123|
|B||PARTNER_NAME||Name of the ISV Partner||String||XYZ Ltd|
|ID number of the ISV Partner||String||2610|
|D||PRODUCT_NAME||ISV Partner Product Name (Product = Payfac Link or Account Management API)||String||Rentmoola-DD|
|E||PRODUCT_ID||ID number of the Product page in Geneva/Netbanx||String||2490|
|F||ACCOUNT_ID||FMA # of the account boarded||String||1002591892|
|G||ACCOUNT_NAME||DBA name of the account boarded||String||Aspire|
|H||CREATION_DATE||Date when the FMA was created / Date the Application was started||String||2019-12-09 18:37:12.0|
|I||LEGAL_NAME||Legal name of the account boarded||String||Confidential|
|J||COUNTRY||Country of the account boarded||String||CANADA|
|K||PROCESSING_CURRENCY||Processing currency of the account boarded||String||CAD|
|L||BUSINESS_CATEGORY||MCC (Merchant Category Code) of the account boarded||String||7997 MBRSHIP CLUBS COUNTRY CLUBS PRIVATE GOLF COURSES|
|N||LAST_COMMENT_ENTERED||Comments from Ops or Risk team||String||Tsys Onboarding Request Sent.|
|O||ON_HOLD_INDICATOR||Notates if there are Payment Holds||String||Y|
|P||ON_HOLD_REASON_CODE||Reason code for Hold||String||RMD|
|Q||ON_HOLD_REASON||Hold Reason code definition||String||Require Micro Deposit|
|R||NOTE||Additional Notes||String||Please provide DL due to Equifax fail|
|S||APPLICANT_EMAIL||Email address of merchant applicant||String||CONFIDENTIAL@domain.com|