This file layout is used to import payments made via the Internet from a third party source to eSite (refer to Import Web Payments tab).
The following table includes the file layout for importing Web Payments with eSite. This file is in comma-delimited format.
|
Field |
Type |
Max Length |
Value |
|
Record Type (P) |
Characters |
1 |
“P” |
|
Property |
Characters |
10 |
eSite Property ID |
|
Building |
Characters |
5 |
eSite Building ID |
|
Unit |
Characters |
8 |
eSite Unit ID |
|
Resident ID |
Integer |
Max value 32767 |
eSite Resident ID |
|
Resident Name |
Characters |
52 |
Resident Name |
|
Trans. Date
|
Date |
|
Transaction Date. If blank, the system uses the eSite Login date. Allowed date formats include: MM/DD/YY, MMDDYY, MM/DD/YYYY, and MMDDYYYY |
|
Amount |
Numeric |
|
|
|
Payment Type |
Characters |
1 |
Always “W” for Web Payment |
|
Check /Ref# |
Characters |
20 |
|
|
Description |
Characters |
30 |
|
|
TransType |
Characters |
2 |
“DC” Check Draft via web |
|
Bank |
Characters |
50 |
Bank Name |
|
Transit Number |
Numeric |
9 |
Bank Transit Number |
|
Bank Account Number |
Numeric |
|
Resident’s Bank Account Number |
|
TransferFlag |
Character |
1 |
“N” or “Y” or “” – Not used currently. |
Example:
P,"TX375","01","1000",2,"Mountain, Tracey","04/11/2005 ", 443 ,"W","Web Pay 04/11/2005 ","Web Pay 04/11/2005 ","DC","Wells Fargo","011000028","855745745","N"
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.