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.
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.

Added On:  04/03/20
SQL Column:  CODE_CPA
Java Field:  codeCPA
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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.
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.
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.
Added On:  06/07/15
SQL Column:  EFT1464_CANADA_PROFILE_CL
Java Field:  eft1464CanadaProfileCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Enumeration of possible EFT Canada profiles available in the system.
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.
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.
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.
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.
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.
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.
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.
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.
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.