NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Customer Bank Account Import
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Paying Customer Code |
12 |
Character |
Yes |
Enter a valid customer code for a customer set up as a paying customer. Note The combination of the paying customer code, routing number, and bank account number must be unique. |
B |
2 |
ABA Routing Number |
20 |
Integer |
No |
Enter the bank's routing number for the customer's bank account. Note The combination of the paying customer code, routing number, and bank account number must be unique. |
C |
3 |
Bank Account Number |
20 |
Integer |
Yes |
Enter the paying customer's account number. Note The combination of the paying customer code, routing number, and bank account number must be unique. |
D |
4 |
Bank Account Name |
40 |
Character |
No |
Enter the name of the account holder for the bank account. |
E |
5 |
IBAN |
40 |
Character |
No |
Enter the International Bank Account Number (IBAN) for the customer's bank account. |
F |
6 |
Bank Code |
12 |
Character |
No |
Enter a valid bank code for the customer's bank account. For information on setting up bank codes, see Bank Code Maintenance. |
Before using this import, the following must be set up:
customers