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. For more information about the steps, see Mapping Bank Files to A/R Payments and Distributions.

A/R Import Mapping - Header

 

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 Import Mapping - Groups

 

Group name First record ID of group
Payment PR
Distribution IV

 

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      

 

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

 


Related Topics

Mapping Bank Files to A/R Payments and Distributions

Importing A/R Payment and Distribution Data from Bank Files