Wire File Format - View Format Details |
|
Format name: |
Custom_Format |
Description: |
ABC Import |
File type: |
Delimited |
Details location: |
File |
Field delimiter: |
Comma |
Date format: |
MMDDYY |
Amount format: |
Decimal included (i.e. 123.00) |
Wire initiator name: |
ABC Corporation INC LTD. |
Wire initiator address 1: |
123 main avenue |
Wire initiator address 2: |
Suite 101 |
Wire initiator address 3: |
My Towne, MI 48236 |
The field properties below describe the relative locations for the data in the record. "Not Used" indicates no format was made for this optional data, and will not be loaded from the file.
ABA/TRC: |
1 |
Numeric only (0-9), 9 characters. |
Account type: |
2 |
2 valid types: C (checking) or S (savings) |
Account number: |
3 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Amount: |
4 |
Numeric only (0-9), greater than 0.00 and less than 100,000,000.00 |
Send on date: |
5 |
Numeric date in specified format (for example, MMDDYY) |
Currency: |
6 |
Currency code Alpha (A-Z), 3 characters max. |
Bank ID type: |
7 |
3 Valid types: ABA, SWIFT, or CHIPS. |
Bank ID: |
8 |
Numeric and 9 characters for ABA, Alphanumeric and 11 characters max for SWIFT, or numeric and 6 characters max for CHIPS. |
Recipient account: |
9 |
Alpha (A-Z), Numeric (0-9), 35 characters max. If appropriate provide IBAN. |
Bank name: |
10 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 1: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 2: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 3: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Recipient name: |
11 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Recipient address 1: |
12 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Recipient address 2: |
13 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Recipient address 3: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Additional information for recipient: |
Not used |
Alpha (A-Z), Numeric (0-9), 140 characters max. |
Bank ID type: |
14 |
3 Valid types: ABA, SWIFT, or CHIPS. |
Bank ID: |
15 |
Numeric and 9 characters for ABA, Alphanumeric and 11 characters max for SWIFT, or numeric and 6 characters max for CHIPS. |
Intermediary account: |
16 |
Alpha (A-Z), Numeric (0-9), 35 characters max. If appropriate provide IBAN. |
Bank name: |
17 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 1: |
18 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 2: |
19 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 3: |
20 |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank ID type: |
Not used |
3 Valid types: ABA, SWIFT, or CHIPS. |
Bank ID: |
Not used |
Numeric and 9 characters for ABA, Alphanumeric and 11 characters max for SWIFT, or numeric and 6 characters max for CHIPS. |
Intermediary account: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. If appropriate provide IBAN. |
Bank name: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 1: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 2: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Bank address 3: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Wire initiator name: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Wire initiator address 1: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Wire initiator address 2: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
Wire initiator address 3: |
Not used |
Alpha (A-Z), Numeric (0-9), 35 characters max. |
|
|
|
|