Requests for Transfer Import File Layouts |
The Requests for Transfer import function enables users to import information to create One Time Requests for Transfer or Requests for Transfer from Templates.
All mandatory information must be available to create a request for transfer. If the payment is to be created using a template, information from the template will be used along with information from the import file to create the payment. If a payment is to be created as a one-time wire payment, all mandatory information must be available in the import file.
Note: For fixed length files all fields must be included with exact length and format indicated in the definition column. |
One Time Request for Transfer Import |
Field name |
Description |
Length |
Type |
Mandatory To Indicate One Time Request for Transfer |
Char (2) value ‘RO’ |
Debit Account |
Mandatory Must be a valid account for the customer and must be associated to the Request for Transfer service |
Char (35) |
Execution Date |
Optional If it is blank, will default to the current date |
Char (10) mm/dd/yyyy |
Payment Amount |
Mandatory Must be > 0 unless the Request for Transfer is cross currency and the Rate Reference is SPOT and Original Amount is > 0 |
Decimal (15,3) |
Payment Currency |
Mandatory Must be valid currency |
Char (3) |
Current FX Rate |
Same currency Requests for Transfer: FX Rate must be 0 or blank. If the Request for Transfer is cross currency and the Rate Reference is NOT equal to “SPOT”, the FX Rate must be > 0. If the Request for Transfer is cross currency and the Rate Reference is equal to “SPOT”, the FX Rate must be blank. |
Decimal (13,8) |
Rate Reference |
Mandatory if cross currency. If “SPOT” is entered, no FX Rate will be keyed.
|
Char (20) |
Original Amount |
Only for cross currency Requests with the following exception – if the request is cross currency and Rate Ref. Is “SPOT” and Payment amount >0.
|
Decimal (15,3) |
Treatment of Charges |
Mandatory Valid Values: OUR, SHA, BEN |
Char (3) |
Debit Charges to |
Optional Must be different than the Debit to Account. If the Treatment of charges code word is “BEN” leave blank. |
Char (34) |
Beneficiary Name & Address |
Mandatory
|
4 X char (35) |
Beneficiary Account |
Optional |
Char (35) |
Beneficiary Bank Name & Address |
Mandatory |
4 X char (35) |
Information to Beneficiary |
Optional |
Char (140) |
Additional Information |
Optional |
Char (140) |
Instructions |
Optional Occurs up to 4 Will include 4 character code + instruction information if required (30 characters) |
Char (34) |
Regulatory Reporting |
Optional |
Char (105) |
Request for Transfer from Template Import |
Field name |
Description |
|
Type |
Mandatory To Indicate Request for Transfer from Template |
Char (2) value ‘RT’ |
Template ID |
Mandatory Template the Request for Transfer will be created from |
Char (20) |
Execution Date |
Optional If it is blank, will default to the current date |
Char (10) Mm/dd/yyyy |
Payment Amount |
Optional If the selected template has a specified payment amount, this field must be blank
For cross currency Requests for Transfer: If the Rate Reference = SPOT and the Original Amount is > 0 or the Original Amount specified in the template > 0, Payment Amount must be blank or 0. |
Decimal (15,3) |
Current FX Rate |
Same currency Requests for Transfer: FX Rate must be 0 or blank If the Request for Transfer is cross currency and the Rate Reference is NOT equal to SPOT, FX Rate must be > 0 If the Request for Transfer is cross currency and the Rate Reference = SPOT, FX Rate must be 0 or blank. |
Decimal (13,8) |
Rate Reference |
Mandatory if the Request for Transfer is cross currency. If SPOT is entered, no FX Rate will be entered. |
Char (20) |
Original Amount |
Only entered for cross currency Requests for Transfer. With the following exceptions: If the Request for Transfer is cross currency and the Rate Reference is SPOT and the Payment Amount > 0 or the Payment Amount in the selected template is > 0. |
Decimal (15,3) |
Treatment of Charges |
Optional If entered will override value in template If blank will default to value in template |
Char (3) |
Debit Charges to |
Optional If entered will override value in template If blank will default to value in template |
Char (35) |
Information to Beneficiary |
Optional |
Char (140) |
Additional Information |
Optional |
Char (140) |
Instructions |
Optional If entered will override value in template If blank will default to value in template |
Char (34) |
Regulatory Reporting |
Optional |
Char (105) |
Related Topics |
Request for Transfer Instruction Codes
Service
Information - Requests for Transfer
Bank
Search
Pending
Requests for Transfer
Modifying/Deleting
Pending Requests for Transfer
Approving
Requests for Transfer
Signing/Submitting
Requests for Transfer
Requests for Transfer - Group
Information – Service Privilege Details
Request
for Transfer History
Message Centre
Requests
for Transfer Import
Requests
for Transfer Import File Layouts