The DirectDepositVendor.CSV file format is used to create an export file that can be emailed to a vendor as notification of direct deposit(s) for invoice payment.
The export process generates a comma-delimited file for the selected Vendor ID and Deposit Advice ranges selected on the Direct Deposit Vendor Export tab. The file contains the following information.
This file is a comma separated (CSV) format.
DirectDepositVendor.CSV
|
Field |
Field Name |
Type |
MaxLength |
Description |
|
1 |
Vendor ID |
Character |
10 |
Vendor identifier. |
|
2 |
Long Name |
Character |
50 |
Vendor’s full name. |
|
3 |
Short Name |
Character |
10 |
Short name for reporting. |
|
4 |
Total Deposit Amount |
Character |
|
Amount of the deposit. |
|
5 |
Advice Date |
Character |
10 |
Date of the deposit. |
|
6 |
Advice Number |
Character |
10 |
Number assigned to advice. |
|
7 |
PropertyCompany Name |
Character |
50 |
Paying PropertyCompany name. |
|
8 |
Invoice ID |
Character |
20 |
Invoice being paid. |
|
9 |
Description |
Character |
40 |
Invoice description. |
|
10 |
Amount Paid |
Character |
|
Invoice amount paid. |
|
11 |
Vendor Email |
Character |
255 |
Vendor’s email address. |
|
12 |
Bank Name |
Character |
50 |
Name of the Bank. |
|
13 |
Account Number |
Character |
20 |
Partially redacted bank account number. |
Sample
"550CON","550 Construction LLC","550Constru","17.00","07/25/2012","0000000002","Greenspring Valley Apartments","testFF","Locator Services","17.00","email@Address.com","Last Regional Peoples Bank","#####7324"
See Also
Data Transfer File Formats Overview
Direct Deposit Vendor Export Tab