Wire Payments Import File Layout

 

The Wire Payments Import function enables users to import information to create One Time Wire Payments or Wire Payments from Templates. 

 

All mandatory information must be available to create a wire payment.  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.       

 

Wire Payments Import

Field name

Description

Definition

Type

Mandatory

To Indicate One Time Wire Payment

Char (2)

Value ‘WO’

Debit Account

Mandatory

Must be a valid account for the customer and must be associated to the Wire Payment Service

Char (35)

Ordering Customer Name

Optional

Overwrites Ordering Customer Name associated with the debit account.

Char (35)

Ordering Customer Address

Optional

Overwrites Ordering Customer Address associated with the debit account.

See address format in table below.

Value Date

Optional

If it is blank, will default to the current date

Char (10)

Format mm/dd/yyyy

Amount

Mandatory

Must be > 0

Decimal (15,3)

 

Payment

Currency

Mandatory

Must be valid currency

Char (3)

FX Rate

Mandatory if cross currency and over bulletin and the customer books his own rate.  Optional otherwise.

Decimal (13, 8)

Rate Reference

If cross currency and under bulletin, Optional.

If cross currency and over bulletin and customer books his own rate, Mandatory

Char (20)

Beneficiary Name

Mandatory

 

Char (35)

Beneficiary Address

Mandatory

See address format below.

Beneficiary Account

Mandatory for One Time wire payments; optional otherwise

Char (35)

Beneficiary Bank Name

Mandatory

Char (35)

Beneficiary Bank Address

Mandatory

See address format below.

Information to Beneficiary

Optional

Char (140)

Internal Memo

Optional

Char (140)

Bank to Bank

Optional

Char (210)

 

 

Address Format

Field name

Description

Definition

Address line 1

Mandatory

Char (35)

Address line 2

Optional

Char (35)

City

Mandatory

Char (20)

Country

Mandatory

Country Code – ISO e.g. CA for Canada and US for USA

Char (2)

Postal Code

Optional

Char (10)

 

Wire Payments from Templates Import

 

Field name

Description

Definition

Type

Mandatory

To Indicate Wire Payment from Template

Char (2)

Value ‘WT’

Template ID

Mandatory

Template ID that will be used to create the payment.

Char (20)

Value Date

Optional

If it is blank, will default to the current date

Char (10)

Format mm/dd/yyyy

Amount

Must be 0 if payment amount is specified in the template.

Mandatory otherwise.

Decimal (15,3)

 

FX Rate

Mandatory if cross currency and over bulletin and the customer books his own rate.  Optional otherwise.

Decimal (13, 8)

Rate Reference

If cross currency and under bulletin, Optional.

If cross currency and over bulletin and customer books his own rate, Mandatory

Char (20)

Information to Beneficiary

Optional

Char (140)

Internal Memo

Optional

Char (140)

Bank to Bank

Optional

Char (140)

 

Related Topics

Help Index

Getting Additional Help

One Time Wire Payments

Wire Payments from Templates

Wire Payments Import