This example shows the information you would specify in the various forms to import an A/R payment file for a particular bank.
A/R Payment Import Mapping
| Field |
Value |
| Map ID |
AR00000001 |
| Type |
Delimited |
| Delimiter |
| (pipe) |
| Amounts contain implied decimal |
Yes |
| Digits following implied decimals |
2 |
| Date format |
YYMMDD |
| Record IDs are used |
Yes |
| Record ID field number |
1 |
A/R Payment Import Mapping
| Group name |
First record ID of group |
| Payment |
PR |
| Distribution |
IV |
A/R Payment Import Conversions
Define this information in the A/R Payment Import Field Mappings form:
| Value conversion ID |
Source value |
Converted value |
| PaymentType |
ACH |
C |
| PaymentType |
BKW |
C |
| PaymentType |
FWT |
C |
| PaymentType |
LBX |
C |
| PaymentType |
SWT |
C |
| PaymentType |
WIR |
W |
A/R Payment Import Field Mappings
| Table group |
Table name |
Column name |
Field number |
Record ID |
Field is amount |
Field is date |
Value conversion ID |
| Payment |
arpmt_import_payment |
account_num |
8 |
PR |
|
|
|
| Payment |
arpmt_import_payment |
check_amt |
4 |
PR |
Yes |
|
|
| Payment |
arpmt_import_payment |
deposit_date |
9 |
PR |
|
Yes |
|
| Payment |
arpmt_import_payment |
payment_type |
2 |
PR |
|
|
PaymentType |
| Payment |
arpmt_import_payment |
routing_num |
7 |
PR |
|
|
|
| Payment |
arpmt_import_payment |
check_num |
16 |
SP |
|
|
|
| Distribution |
arpmt_import_distribution |
amt_paid_amt |
5 |
IV |
Yes |
|
|
| Distribution |
arpmt_import_distribution |
disc_amt |
7 |
IV |
Yes |
|
|
| Distribution |
arpmt_import_distribution |
inv_num |
3 |
IV |
|
|
|