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 |
|
|
|