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 |