EFT1464 Canada Profile

Parent: EFT Profile

Added On: 03/14/13

SQL Table: EFT1464_CANADA_PROFILE

Module: UniCharge

Type: Entity Status: Active

Java Class: Eft1464CanadaProfile

Configuration settings for processing of ACH transactions through EFT1464 Canada.

Available Fields:

Account Number
Code CPA
Contact Name
Contact Phone Number
Destination Data Centre Code

EFT1464 Canada Profile CL
Institution ID
Is Test Mode
Last File Creation Number Credit
Last File Creation Number Sale

Originator ID Number Credit
Originator ID Number Sale
Originator Long Name
Originator Short Name
Sundry Information

Account Number

Added On: 03/14/13

SQL Column: ACCOUNT_NUMBER

Java Field: accountNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

TD Commercial account number where unposted or dishonoured transactions will be returned.

Code CPA

Added On: 04/03/20

SQL Column: CODE_CPA

Java Field: codeCPA

Status: Active

SQL Type: varchar(3)

Java Type: String

References Cpa Code Classifier

Attributes:

Contact Name

Added On: 03/15/13

SQL Column: CONTACT_NAME

Java Field: contactName

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Name of the person to contact to.

Contact Phone Number

Added On: 03/15/13

SQL Column: CONTACT_PHONE_NUMBER

Java Field: contactPhoneNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone number of the person to contact to.

Destination Data Centre Code

Added On: 07/10/15

SQL Column: DESTINATION_DATA_CENTRE_CODE

Java Field: destinationDataCentreCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Denotes the TD location.

EFT1464 Canada Profile CL

Added On: 06/07/15

SQL Column: EFT1464_CANADA_PROFILE_CL

Java Field: eft1464CanadaProfileCl

Status: Active

SQL Type: varchar(3)

Java Type: String

References EFT1464 Canada Profile Classifier

Attributes:

Enumeration of possible EFT Canada profiles available in the system.

Institution ID

Added On: 03/14/13

SQL Column: INSTITUTION_ID

Java Field: institutionId

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Contains the Institution ID assigned by TD Bank Canada. Always “0004” for TD followed by the 5 digit branch transit number.

Is Test Mode

Added On: 11/12/15

SQL Column: IS_TEST_MODE

Java Field: isTestMode

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the test mode is currently active.

Last File Creation Number Credit

Added On: 04/04/13

SQL Column: LAST_FILE_CREATION_NUMBER_CREDIT

Java Field: lastFileCreationNumberCredit

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The number of the last credit file creation.

Last File Creation Number Sale

Added On: 04/04/13

SQL Column: LAST_FILE_CREATION_NUMBER_SALE

Java Field: lastFileCreationNumberSale

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The number of the last sale file creation.

Originator ID Number Credit

Added On: 04/04/13

SQL Column: ORIGINATOR_ID_NUMBER_CREDIT

Java Field: originatorIdNumberCredit

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Contains the ID number credit of the originator.

Originator ID Number Sale

Added On: 03/14/13

SQL Column: ORIGINATOR_ID_NUMBER_SALE

Java Field: originatorIdNumberSale

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Provides a unique value to identify sales by originator.

Originator Long Name

Added On: 03/14/13

SQL Column: ORIGINATOR_LONG_NAME

Java Field: originatorLongName

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

The company name as received on the original input file or, the name appearing on the company profile.
If the company is a Service Bureau or a Processing Agent, the name of the transaction’s originator (the client’s name) must be entered. This name is passed to the other financial institutions and may appear on the payor/payee’s account statement.

Originator Short Name

Added On: 03/14/13

SQL Column: ORIGINATOR_SHORT_NAME

Java Field: originatorShortName

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

The company short name contained on the original input file.
If the company is a Service Bureau or a Processing Agent, the name of the transaction’s originator (the client’s name) must be entered here. This name is passed to the other financial institutions and may appear on the payee/payor account statement. The receiver of the transaction must be able to clearly identify who has originated the transaction.

Sundry Information

Added On: 03/14/13

SQL Column: SUNDRY_INFORMATION

Java Field: sundryInformation

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Filled only if the company has provided sundry information on the original transaction, otherwise filled with spaces.