EFT1464 Canada Batch UML

Parent: File Batch

Added On: 03/14/13

SQL Table: EFT1464_CANADA_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: Eft1464CanadaBatch

Represents a batch of transactions as it is defined in EFT1464 Canada batch processing specification.

Available Fields:

Account Number
Contact Name
Contact Phone Number
CPA Code
Destination Data Center Code
Due Date
File Creation Date

File Creation Number
File Reject Message
File Reject Reason Code
Institution ID
Originator ID Number
Originator Long Name
Originator Short Name

Originator Sundry Information
Report Date
Settlement Date
Total Credit Amount
Total Credit Number
Total Debit Amount
Total Debit Number

Account Number

Added On: 06/10/16

SQL Column:

Java Field: accountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Contains the credit card account number which identifies the customer. The account number is left justified with trailing spaces.

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.

CPA Code

Added On: 06/07/15

SQL Column: CPA_CODE

Java Field: cpaCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

The Canadian Payment Association payment code from the original transaction.

Destination Data Center Code

Added On: 06/07/15

SQL Column: DESTINATION_DATA_CENTER_CODE

Java Field: destinationDataCenterCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Denotes the TD location.

Due Date

Added On: 03/14/13

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

The date that was reflected on the transaction that rejected.
Format is 0YYDDD.

File Creation Date

Added On: 03/14/13

SQL Column: FILE_CREATION_DATE

Java Field: fileCreationDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

The Julian Date when TD created the file.
Format: yyyddd

File Creation Number

Added On: 03/14/13

SQL Column: FILE_CREATION_NUMBER

Java Field: fileCreationNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

File Creation Number used to initiate the EFT transactions.

File Reject Message

Added On: 05/29/13

SQL Column: FILE_REJECT_MESSAGE

Java Field: fileRejectMessage

Status: Active

SQL Type: varchar(75)

Java Type: String

Attributes:

Text message that describes why the file was rejected. Matches message output on APEX Summary Edit Report.

File Reject Reason Code

Added On: 05/29/13

SQL Column: FILE_REJECT_REASON_CODE

Java Field: fileRejectReasonCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Codes are left justified followed by a space.

Institution ID

Added On: 06/10/16

SQL Column:

Java Field: institutionId

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Originator ID Number

Added On: 03/14/13

SQL Column: ORIGINATOR_ID_NUMBER

Java Field: originatorIdNumber

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

The Originator ID and File Creation Number from the original input file.

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.

Originator Sundry Information

Added On: 06/11/15

SQL Column: ORIGINATOR_SUNDRY_INFORMATION

Java Field: originatorSundryInformation

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Filled only if you have provided sundry information on the original transaction, otherwise spaces.

Report Date

Added On: 03/15/13

SQL Column: REPORT_DATE

Java Field: reportDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Date when the report was created.

Settlement Date

Added On: 03/15/13

SQL Column: SETTLEMENT_DATE

Java Field: settlementDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Date when the transaction was settled.

Total Credit Amount

Added On: 03/14/13

SQL Column: TOTAL_CREDIT_AMOUNT

Java Field: totalCreditAmount

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Total amount of all credit transactions.

Total Credit Number

Added On: 03/14/13

SQL Column: TOTAL_CREDIT_NUMBER

Java Field: totalCreditNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

The accumulated number (record count) of all credit transaction records in the file.

Total Debit Amount

Added On: 03/14/13

SQL Column: TOTAL_DEBIT_AMOUNT

Java Field: totalDebitAmount

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Total amount of the debit transactions.

Total Debit Number

Added On: 03/14/13

SQL Column: TOTAL_DEBIT_NUMBER

Java Field: totalDebitNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

The accumulated number (record count) of all debit transaction records in the file.