Validation Rules for Incoming SWIFT Electronic Funds Transfer Reports (EFTSI)

Date - November 21, 2015

The purpose of this document is to provide reporting entities with the validation specifications of Incoming SWIFT Electronic Funds Transfer Reports (EFTSI) submitted to the Financial Transactions and Reports Analysis Centre of Canada (FINTRAC).

MS Excel version (45 kb)

FINTRAC header

EFTSI.0.1: Report sequence number

Rule:
92001
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92002
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that is not between 0 and 99999.

Message:
Invalid format. (362)
Constraint:
IntegerBounds

EFTSI.0.2: Reporting entity's report reference number

Rule:
92003
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92004
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that did not contain only alpha character, numbers, dashes or underscores up to 20 characters.

Message:
Invalid format. (362)
Constraint:
ReportEntityReportReferenceNumberFormat
Rule:
92976
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the report has been segregated.

Message:
Report previously segregated (976)
Constraint:
PreviousReportSegregated
Rule:
92991
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the previous version of this report (should it exist) is more than 7 years old.

Message:
A request for change cannot be made to a report submitted more than 7 years ago. (977)
Constraint:
PreviousReportAge

EFTSI.0.3: Action type

Rule:
92005
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory

EFTSI.0.4: Reporting entity's identifier number

Rule:
92007
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92008
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that is not between 0 and 9999999.

Message:
Invalid format. (362)
Constraint:
IntegerBounds

EFTSI.0.5: Reporting entity's location number

Rule:
92009
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92283
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92284
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 15 characters, containing only alpha and numeric characters.

Message:
Invalid format. (362)
Constraint:
AlphaNumericFormat
Rule:
92282
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a branch location that is invalid for the reporting entity given the constraint ' None '.

  • None: check to make sure this is a valid branch.
  • CAOnly: check to make sure this branch is in Canada.
  • ValidCA: check to make sure this branch is valid and is in Canada.
  • PortCode: check to make sure this branch is valid or a valid port code.
Message:
FINTRAC does not have this location on file for the reporting entity. (320)
Constraint:
BranchLocation

EFTSI.0.6: 24-hour rule indicator

Rule:
92011
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92012
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 1.

Message:
Invalid format. (362)
Constraint:
IntegerFormat

Basic header

EFTSI.1.1: Application identifier

Rule:
92016
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92017
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 1 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat
Rule:
92018
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that does not equal F.

Message:
The value entered does not correspond to any of the possible values for this field. (9)
Constraint:
Equals

EFTSI.1.2: Service identifier

Rule:
92019
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92020
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 1 and 1.

Message:
Invalid format. (362)
Constraint:
IntegerFormat
Rule:
92021
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that does not equal 01.

Message:
The value entered does not correspond to any of the possible values for this field. (9)
Constraint:
Equals

EFTSI.1.3: Canadian SWIFT LT

Rule:
92022
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory

EFTSI.1.4: Session number

Rule:
92025
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92026
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 9999.

Message:
Invalid format. (362)
Constraint:
IntegerFormat

EFTSI.1.5: Sequence number

Rule:
92027
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92028
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 999999.

Message:
Invalid format. (362)
Constraint:
IntegerFormat

Application header (Output from SWIFT)

EFTSI.2.1: SWIFT I/O code

Rule:
92029
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92030
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 1 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat
Rule:
92031
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that does not equal O.

Message:
The value entered does not correspond to any of the possible values for this field. (9)
Constraint:
Equals

EFTSI.2.2: Message type code

Rule:
92032
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92033
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 999.

Message:
Invalid format. (362)
Constraint:
IntegerFormat
Rule:
92034
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that does not equal 103.

Message:
The value entered does not correspond to any of the possible values for this field. (9)
Constraint:
Equals

EFTSI.2.3: Input time

Rule:
92035
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92036
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 2359.

Message:
Invalid format. (362)
Constraint:
IntegerFormat

EFTSI.2.4: Input date

Rule:
92037
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92038
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not in the format 'yyMMdd' that is a valid calendar date.

Message:
Invalid format. (362)
Constraint:
ShortDateFormat

EFTSI.2.5: Sender SWIFT LT

Rule:
92039
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory

EFTSI.2.6: Input session number

Rule:
92042
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92043
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 9999.

Message:
Invalid format. (362)
Constraint:
IntegerFormat

EFTSI.2.7: Input sequence number

Rule:
92195
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92196
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a whole number between 0 and 999999.

Message:
Invalid format. (362)
Constraint:
IntegerFormat

EFTSI.2.8: Receiver output date

Rule:
92197
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92198
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not in the format 'yyMMdd' that is a valid calendar date.

Message:
Invalid format. (362)
Constraint:
ShortDateFormat

EFTSI.2.10: Message priority

Rule:
92199
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory

Tag 13C - Time indication

EFTSI.13C.1: Time indication code

Rule:
92047
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 8 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat

EFTSI.13C.2: Time indication time

Rule:
92048
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not one of the following formats:

  • HH:mm
  • HHmm
Message:
Invalid format. (362)
Constraint:
TimeFormat

EFTSI.13C.3: Time indication offset sign

Rule:
92274
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value that does not equal ["+","-"].

Message:
The value entered does not correspond to any of the possible values for this field. (9)
Constraint:
Equals

EFTSI.13C.4: Time indication offset time

Rule:
92275
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not one of the following formats:

  • HH:mm
  • HHmm
Message:
Invalid format. (362)
Constraint:
TimeFormat

Tag 20 - Transaction reference number

EFTSI.20: Transaction reference number

Rule:
92045
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory

Tag 23B - Bank operation code

EFTSI.23B: Bank operation code

Rule:
92049
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory

Tag 23E - Instruction code

EFTSI.23E.1: Instruction code

Rule:
92051
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 4 characters, containing only alpha and numeric characters.

Message:
Invalid format. (362)
Constraint:
AlphaNumericFormat

Tag 26T - Transaction type code

EFTSI.26T: Transaction type code

Rule:
92054
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 3 characters, containing only alpha and numeric characters.

Message:
Invalid format. (362)
Constraint:
AlphaNumericFormat

Tag 32A - Value date/Currency/Interbank settlement amount

EFTSI.32A.1: Value date

Rule:
92055
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92056
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not in the format 'yyMMdd' that is a valid calendar date.

Message:
Invalid format. (362)
Constraint:
ShortDateFormat
Rule:
92281
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a date that is not after or equal to 2002-06-12.

Message:
The date in the field is too far in the past. (308)
Constraint:
DateValidation

EFTSI.32A.2: Currency

Rule:
92058
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92059
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 3 and 3 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat
Rule:
92060
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value not in the list:

  • All ISO Currencies
Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
AlphaCodeTable

EFTSI.32A.3: Interbank settlement amount

Rule:
92061
Rule Type:
Presence
Action:
Reject
Description:

Reject this report if the user did not provide a value into this field.

Message:
Field is mandatory. (329)
Constraint:
Mandatory
Rule:
92062
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a valid swift dollar amount. A comma as the decimal separator, allow up to 2 digits after the comma, and the comma optional.

Message:
Invalid format. (362)
Constraint:
SwiftAmountFormat
Rule:
92276
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the 24-hour rule indicator is off , EFTSI.32A.2 is CAD , and the transaction amount is below $ 10000 CAD on the date of one of EFTSI.32A.1.

Message:
The transaction amount is under the reporting threshold (there is no indication that the 24-hour rule applies). (999)
Constraint:
TwentyFourHourRuleIndicator
Rule:
92277
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the 24-hour rule indicator is off , EFTSI.32A.2 is not CAD , and the transaction amount is below $ 9700 CAD on the date of one of EFTSI.32A.1.

Message:
The amount in foreign currency appears under the reporting threshold (there is no indication of 24-hour rule applying). (998)
Constraint:
TwentyFourHourRuleIndicator
Rule:
92278
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the 24-hour rule indicator is on , EFTSI.32A.2 is CAD , and the transaction amount is above $ 10000 CAD on the date of one of EFTSI.32A.1.

Message:
The transaction amount is over the threshold for the 24-hour rule to apply. (994)
Constraint:
TwentyFourHourRuleIndicator
Rule:
92279
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the 24-hour rule indicator is on , EFTSI.32A.2 is not CAD , and the transaction amount is above $ 10300 CAD on the date of one of EFTSI.32A.1.

Message:
The amount in foreign currency appears to be over the threshold for the 24-hour rule to apply. (996)
Constraint:
TwentyFourHourRuleIndicator

Tag 33B - Currency code, instructed amount

EFTSI.33B.1: Currency

Rule:
92063
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 3 and 3 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat
Rule:
92064
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value not in the list:

  • All ISO Currencies
Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
AlphaCodeTable

EFTSI.33B.2: Instruction amount

Rule:
92065
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a valid swift dollar amount. A comma as the decimal separator, allow up to 2 digits after the comma, and the comma optional.

Message:
Invalid format. (362)
Constraint:
SwiftAmountFormat

Tag 36 - Exchange rate

EFTSI.36: Exchange rate

Rule:
92066
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a number with decimal places. The decimal delimiter can either be a '.' or ','.

Message:
Invalid format. (362)
Constraint:
ExchangeRateFormat

Tag 50 - Ordering customer

EFTSI.50.option: Option

Rule:
92201
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals A.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 50K - Ordering customer (Option K)

EFTSI.50K.1: Account number

Rule:
92252
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the value starts with 'XXXX/' and contains extra characters after the slash. 'XXXX/' indicates that there was a code word present in the original 50K line.

Message:
The value entered does not correspond to any of the possible values for this field. (9)
Constraint:
Swift50KAccount

Tag 53 - Sender's correspondent

EFTSI.53.option: Option

Rule:
92202
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals B.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 54 - Receiver's correspondent

EFTSI.54.option: Option

Rule:
92203
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals B.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 55 - Third reimbursement institution

EFTSI.55.option: Option

Rule:
92204
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals B.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 56 - Intermediary

EFTSI.56.option: Option

Rule:
92205
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals C.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 57 - Account with institution

EFTSI.57.option: Option

Rule:
92206
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals B.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals
Rule:
92207
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals C.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 59 - Beneficiary customer

EFTSI.59.option: Option

Rule:
92208
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value that equals A.

Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
NotEquals

Tag 59F - Beneficiary customer (Option F)

EFTSI.59F.2-5: Name and address

Rule:
92217
Rule Type:
Content
Action:
Warning
Description:

Send a warning if the user provided a value for the first line 3 that is not in the list:

  • All ISO Countries
Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
Swift59fCountry

Tag 71A - Details of charges

EFTSI.71A.1: Charge code

Rule:
92177
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 1 and 3 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat

Tag 71F - Sender's charges

EFTSI.71F.1: Sender's charge currency

Rule:
92179
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 3 and 3 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat
Rule:
92180
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value not in the list:

  • All ISO Currencies
Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
AlphaCodeTable

EFTSI.71F.2: Sender's charge amount

Rule:
92181
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a valid swift dollar amount. A comma as the decimal separator, allow up to 2 digits after the comma, and the comma optional.

Message:
Invalid format. (362)
Constraint:
SwiftAmountFormat

Tag 71G - Receiver's charges

EFTSI.71G.1: Receiver's charge currency

Rule:
92182
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided text that is not between 3 and 3 characters, containing only alpha characters.

Message:
Invalid format. (362)
Constraint:
AlphaFormat
Rule:
92183
Rule Type:
Content
Action:
Reject
Description:

Reject this report if the user provided a value not in the list:

  • All ISO Currencies
Message:
The value entered is not in FINTRAC's list of values for the field. (300)
Constraint:
AlphaCodeTable

EFTSI.71G.2: Receiver's charge amount

Rule:
92184
Rule Type:
Format
Action:
Reject
Description:

Reject this report if the user provided a value that is not a valid swift dollar amount. A comma as the decimal separator, allow up to 2 digits after the comma, and the comma optional.

Message:
Invalid format. (362)
Constraint:
SwiftAmountFormat
Date Modified: