Example: Bank Import File Mapping

This example shows the information you would specify in the various forms to import an A/R payment file for a particular bank.

Electronic File Transfer Mappings

Field Value
Map ID AR00000001
Import Logical Folder EFTImport
Archive Logical Folder EFTArchive
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

Electronic File Transfer Mappings - Groups

Group name First record ID of group
Payment PR
Distribution IV

Electronic File Transfer 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