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