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.
| 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 |
| Group name | First record ID of group |
| Payment | PR |
| Distribution | IV |
| 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 |
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 |