The import function enables you to import information to easily include when you create One Time Requests for Transfer or Requests for Transfer from Templates.
Requests for Transfer
Requests for Transfer Import
How to import a request for transfer
Navigate to Payments and select Requests for Transfer in the sub-menu, then choose the Import Requests tab.
- Enter the name of your File, or click on “Browse” to search for the location of your file.
- With the drop down menu, select either fixed length text or comma separated value.
- Click the red “Import” button. Your file will be uploaded to the ScotiaConnect system.
What your import file needs to include
All mandatory information must be in the file you import so that it is accurately available for you to create a Request for Transfer.
If you plan to use a template: Information from your template will be combined with information from your import file to create the payment. Information and layout details below.
If for a one-time payment: All mandatory information must be available in the import file. Information and layout details below.
One time file layout
Note: For fixed length files all fields must be included with exact length and format indicated in the definition column.
| 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 a valid 3-character currency abbreviation. |
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) |
From templates file layout
Note: For fixed length files all fields must be included with exact length and format indicated in the definition column.
| Field name | Description | Length |
|---|---|---|
| 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. Exception: 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) |