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 |
---|---|---|---|---|
A | NOTES | NOT USED | String | |
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 |