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
One Time Requests for Transfer
Request for Transfer Template Maintenance
Requests for Transfer from Templates
Adding New Request for Transfer Templates

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