Onboarding Holds

This report captures accounts under a partner that are on-hold during the onboarding process. The report includes data for ISVs who are using Simplified Onboarding App form. It captures the applications put on hold before enabling the merchant/partner for the first time as part of the onboarding process. This report does not capture data for cases when an enabled merchant/partner is put on hold.

Creation Date

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 day) to Current date

Column Column Header Description Definition Data Type Sample Value
B PARTNER_NAME Name of the ISV Partner String Merchant1
C ACCOUNT_ID FMA # of the account boarded String 1002581622
D ACCOUNT_NAME DBA name of the account boarded String Studio Unis
E LEGAL_NAME Legal name of the account boarded String John Doe
F STATE/PROVINCE State or Province location of the account boarded String QC
G COUNTRY Country of the account boarded String CANADA
H CONTACT_NAME Name of contact person for the account boarded String Jerome Ouellet
I WORK_PHONE_NUMBER Contact Person's Phone Number String 0912345678
J EMAIL_ADDRESS Contact Person's E-mail String xyz@abc.com
K LOCALE Language preference for communications and interfaces String french - Canada
L ENABLED_DATE Date the account was set to 'Enabled' status String 2019-11-26 06:42:37.0
M FIRST_TRANSACTION_DATE The date of the first transaction performed on the account boarded String 2019-11-27 00:00:00.0
N AMOUNT_IN_CURRENT_ACCOUNT Current Balance that has not been paid out yet String 4237.59
O STATUS 'Enabled' vs 'Disabled' status String Enabled
p ON_HOLD_REASON_CODE Reason code for Payments Hold String RMD
Q ON _HOLD_REASON Payments Hold Reason code definition String Require Micro Deposit
R APPLICANT_EMAIL Email address of merchant applicant String xyz@abc.com
S AUTO_SENT_EMAIL_COUNT Count of automated e-mails sent to advise of hold / reasons String 2

On-Hold Reasons

Reason Code Description
PRI Pending Risk Investigation
CIT Collection Item
MDF Micro Deposit Failed
PCW Pending Compliant Website
FMB Failed Monthly Billing
RSD Require Security Deposit
APN Merchant Payment - No Debit
RMD Require Micro Deposit
PCB Pending Compliant Website and Banking Info
MDR Micro Deposit Returned
PUA Payable upon Account Manager request
RPD Rejection/Return on Payment or Debit
INC Incomplete Application
RBI Require Banking Info
Did you find this page useful?