Clover Extract
Portico generates extract files containing merchant and transaction data for Clover. Clover uses the merchant and transaction data to allow your small business members to analyze sales data, customize reward programs and grow their business. Portico creates a transmission file on the 3rd of each month and transmits it to Clover by the 5th of each month.
Clover Transaction Record
|
Field Type |
Clover Field |
Field Length |
Portico Field Name |
Location |
|---|---|---|---|---|
|
numeric |
FI ID | 9 | IRS Tax ID | Credit Union Profile |
|
alpha-numeric |
FI NAME |
25 |
Name 1 | Credit Union Profile |
| numeric | ABA PRIMARY | 8 | Credit Union R/T | Credit Union Profile - ACH/Payroll |
| N/A | ABA SECONDARY | N/A | N/A | N/A |
| alpha-numeric | FI HEAD OFF ADDR 1 |
25 |
Address Line 1 |
Credit Union Profile |
| alpha-numeric | FI HEAD OFF ADDR 2 |
25 |
Address Line 2 |
Credit Union Profile |
| N/A | FI HEAD OFF ADDR 3 | N/A | N/A | N/A |
| alpha-numeric | FI HEAD OFF CITY |
18 |
City |
Credit Union Profile |
| alpha-numeric | FI HEAD OFF STATE |
2 |
State |
Credit Union Profile |
| numeric | FI HEAD OFF ZIP |
9 |
ZIP |
Credit Union Profile |
| N/A | DATA CENTER ID | N/A | N/A | N/A |
| alpha-numeric | DATA CENTER NAME | FRISCO | N/A | N/A |
| numeric | BRANCH ID |
3 |
Member Branch |
Ownership Information |
| alpha-numeric | BRANCH NAME |
25 |
Name 1 |
Credit Union Profile |
| alpha-numeric | BRANCH ADDR 1 |
25 |
Address Line 1 |
Credit Union Profile |
| alpha-numeric | BRANCH ADDR 2 |
25 |
Address Line 2 |
Credit Union Profile |
| N/A | BRANCH ADDR 3 | N/A | N/A | N/A |
| alpha-numeric | BRANCH CITY |
18 |
City |
Credit Union Profile |
| alpha-numeric | BRANCH STATE |
2 |
State |
Credit Union Profile |
| alpha-numeric | BRANCH ZIP |
9 |
ZIP |
Credit Union Profile |
| N/A | OFFICER PRIM ID | N/A | N/A | N/A |
| N/A | OFFICER PRIM NAME | N/A | N/A | N/A |
| N/A | OFFICER PRIM PHONE | N/A | N/A | N/A |
| N/A | OFFICER PRIM EMAIL | N/A | N/A | N/A |
| numeric | ACCOUNT NUMBER |
13 |
Member Number |
toolbar |
| N/A | SUFFIX | N/A | N/A | N/A |
| N/A | ACCOUNT TYPE | N/A | N/A | N/A |
| N/A | ACCOUNT SUB TYPE | N/A | N/A | N/A |
| alpha-numeric | ACCOUNT STATUS |
ACTIVE (default) DORMANT DECEASED CLOSED |
DORMANT DECEASED CLOSE DATE |
Contact Information |
| numeric | ACCOUNT START |
8 |
Opened Date |
Share Information |
| numeric | AVG DAILY BALANCE |
13 |
Share Balance |
Share Information |
| numeric | NBR OF OVERDRAFTS |
5 |
Returns Activity Counter |
Share Information |
| numeric | CUSTOMER ID |
13 |
Member Number |
toolbar |
| alpha-numeric | CUSTOMER NAME | 25 | Statement Name | Contact Information |
| N/A | CUST FIRST NAME | N/A | N/A | N/A |
| N/A | CUST LAST NAME | N/A | N/A | N/A |
| N/A | CUST SALUTATION |
N/A |
N/A | N/A |
| numeric | CUSTOMER TAX |
11 |
SSN |
Contact Information |
| N/A | CUSTOMER CLASS | N/A | N/A | N/A |
| alpha-numeric | CUSTOMER TYPE | BUSINESS | N/A | N/A |
| N/A | CUST BUS. TYPE | N/A | N/A | N/A |
| numeric | CUST REL START |
8 |
Date Joined |
Contact Information |
| N/A | CUST REL INDICATOR | N/A | N/A | N/A |
| N/A | NAICS | N/A | N/A | N/A |
| alpha-numeric | ADDRESS TYPE |
PRIMARY SECONDARY |
Use Alternate Address | Contact Information |
| alpha-numeric | ADDRESS LINE 1 |
35 |
Address Line 1 |
Contact Information |
| alpha-numeric | ADDRESS LINE 2 |
35 |
Address Line 2 |
Contact Information |
| ADDRESS LINE 3 | N/A | N/A | N/A | |
| alpha-numeric | ADDRESS CITY |
18 |
City |
Contact Information |
| alpha-numeric | ADDRESS STATE |
2 |
State |
Contact Information |
| numeric | ZIP CODE |
10 |
ZIP |
Contact Information |
| alpha-numeric | PHONE TYPE |
HOME PHONE ALTERNATE 1 |
Home Cellular Alternate 1 |
Contact Information |
| numeric | PHONE |
10 |
Phone |
Contact Information |
| alpha-numeric | EMAIL TYPE | PRIMARY | Default Email | Contact Information |
| alpha-numeric | 50 | Email 1, Email 2, Email 3 | Contact Information | |
| alpha-numeric | DO NOT DISTR | 1 | Disclosure 1 | Stmts/Reporting/Notices |
| N/A | WEB ADDRESS | N/A | N/A | N/A |
| alpha-numeric | TRANSACTION ID |
SHARE DRAFT DEPOSIT (22) SHARE DRAFT WITHDRAWAL (27) SHARE DEPOSIT (32) SHARE WITHDRAWAL (37) |
NACHA Txn Code | ACH History Inquiry |
| numeric | TRANSACTION AMT | 11 | Txn Amount | ACH History Inquiry |
| numeric | DATE POSTING TRXN | 6 | Effective Date | ACH History Inquiry |
| alpha-numeric | TRANSACTION TYPE |
CREDIT (22) DEBIT (27) CREDIT (32) DEBIT (37) |
NACHA Txn Code | ACH History Inquiry |
| alpha-numeric | COMPANY NAME | 16 | Company Name | ACH History Inquiry |
| alpha-numeric | COMPANY ID NBR | 10 | Company ID | ACH History Inquiry |
| alpha-numeric | CLASS CODE | 3 | Standard Entry Class | ACH History Inquiry |
| N/A | TRANS SOURCE | N/A | N/A | N/A |
| alpha-numeric | STATEMENT DESC 1 | 35 | Statement Description | Financial Transaction History |
| alpha-numeric | STATEMENT DESC 2 | 35 | Statement Description | Financial Transaction History |
| N/A | ENTRY DESCRIPTION | N/A | N/A | N/A |
Clover Relationship Record
|
Field Type |
Clover Field |
Field Length |
Portico Field Name |
Location |
|---|---|---|---|---|
|
numeric |
FI ID | 9 | IRS Tax ID | Credit Union Profile |
|
alpha-numeric |
FI NAME |
25 |
Name 1 |
Credit Union Profile |
| numeric | ABA PRIMARY | 8 | Credit Union R/T | Credit Union Profile - ACH/Payroll |
| alpha-numeric | FI HEAD OFF ADDR 1 |
25 |
Address Line 1 |
Credit Union Profile |
| alpha-numeric | FI HEAD OFF ADDR 2 |
25 |
Address Line 2 |
Credit Union Profile |
| N/A | FI HEAD OFF ADDR 3 | N/A | N/A | N/A |
| alpha-numeric | FI HEAD OFF CITY |
18 |
City |
Credit Union Profile |
| alpha-numeric | FI HEAD OFF STATE |
2 |
State |
Credit Union Profile |
| numeric | FI HEAD OFF ZIP |
9 |
ZIP |
Credit Union Profile |
| numeric | BRANCH ID |
3 |
Member Branch |
Ownership Information |
| alpha-numeric | BRANCH NAME |
25 |
Name 1 |
Credit Union Profile |
| numeric | ACCOUNT NUMBER |
13 |
Member Number |
toolbar |
| N/A | SUFFIX | N/A | N/A | N/A |
| N/A | ACCOUNT TYPE | N/A | N/A | N/A |
| N/A | ACCOUNT SUB TYPE | N/A | N/A | N/A |
| alpha-numeric | ACCOUNT STATUS |
ACTIVE (default) DORMANT DECEASED CLOSED |
Dormant Deceased Close Date |
Contact Information |
| numeric | CUSTOMER ID |
13 |
Member Number |
toolbar |
| alpha-numeric | CUSTOMER NAME | 25 | Statement Name | Contact Information |
| N/A | CUST FIRST NAME | N/A | N/A | N/A |
| N/A | CUST LAST NAME | N/A | N/A | N/A |
| N/A | CUST SALUTATION | N/A | N/A | N/A |
| alpha-numeric | CUSTOMER TYPE |
BUSINESS PERSONAL |
N/A | N/A |
| N/A | RELATIONSHIP DESC | N/A | N/A | N/A |
| alpha-numeric | ADDRESS TYPE |
PRIMARY SECONDARY |
Use Alternate Address | Contact Information |
| alpha-numeric | ADDRESS LINE 1 |
35 |
Address Line 1 |
Contact Information |
| alpha-numeric | ADDRESS LINE 2 |
35 |
Address Line 2 |
Contact Information |
| N/A | ADDRESS LINE 3 | N/A | N/A | N/A |
| alpha-numeric | ADDRESS CITY |
18 |
City |
Contact Information |
| alpha-numeric | ADDRESS STATE |
2 |
State |
Contact Information |
| numeric | ZIP CODE |
10 |
ZIP |
Contact Information |
| alpha-numeric | PHONE TYPE |
HOME PHONE ALTERNATE1 |
Home Cellular Alternate 1 |
Contact Information |
| numeric | PHONE |
10 |
Phone |
Contact Information |
| alpha-numeric | EMAIL TYPE | PRIMARY | Default Email | Contact Information |
| alpha-numeric | 50 | Email 1, Email 2, Email 3 | Contact Information | |
| alpha-numeric | DO NOT DISTR | 1 | Disclosure 1 | Stmts/Reporting/Notices |
| N/A | WEB ADDRESS | N/A | N/A | N/A |