EFT1464 Canada Batch Transaction UML


Added On:  03/14/13 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  Eft1464CanadaBatchTransaction 
Represents a batch transaction as it is defined in EFT1464 Canada batch processing specification.
Added On:  03/14/13
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
Added On:  06/10/16
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  03/14/13
SQL Column:  EFT1464_CANADA_BATCH_FK
Java Field:  eft1464CanadaBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents EFT Canada batch file.
Added On:  03/14/13
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  06/10/16
SQL Column:  
Java Field:  institutionId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  05/29/13
SQL Column:  INVALID_FIELD_IDENTIFICATION
Java Field:  invalidFieldIdentification
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Indicates up to 5 invalid fields (2 digits) from client’s original payment.
Invalid field corresponds to field in this format i.e.: if field 07 is indicated in this field then the original payment contained an invalid Financial Institution number.
Added On:  03/14/13
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  03/18/13
SQL Column:  NEW_INSTITUTION_ID
Java Field:  newInstitutionId
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
The payment routing number of the Payor/Payee’s financial institution from the original transaction. The first digit is a constant zero, the next 3 digits are the institution number, and the last 5 digits are the branch transit number.
Added On:  03/18/13
SQL Column:  NEW_PAYOR_ACCOUNT_NUMBER
Java Field:  newPayorAccountNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Account number from the original transaction.
Added On:  03/14/13
SQL Column:  ORIGINATOR_REFERENCE_NUMBER
Java Field:  originatorReferenceNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
The internal reference number that enables the company to identify the transaction to internal records.
Added On:  06/10/16
SQL Column:  ORIGINATOR_SUNDRY_INFORMATION
Java Field:  originatorSundryInformation
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  06/10/16
SQL Column:  
Java Field:  payorAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  03/14/13
SQL Column:  PAYOR_NAME
Java Field:  payorName
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Obtained from the payor/payee’s voided cheque.ƒ Must be left justified followed by spaces.
Added On:  03/14/13
SQL Column:  RECORD_TYPE
Java Field:  recordType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Type of the record.

Note: Must be uppercase.
Added On:  06/07/15
SQL Column:  RESERVED_FIELD1
Java Field:  reservedField1
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Always zeroes (zero filled).
Added On:  06/07/15
SQL Column:  RESERVED_FIELD2
Java Field:  reservedField2
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Always zeroes (zero filled).
Added On:  03/18/13
SQL Column:  RETURN_REASON_CODE
Java Field:  returnReasonCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The reason code that indicates why the original transaction was returned.
Added On:  03/18/13
SQL Column:  VERIFIED_INDICATOR
Java Field:  verifiedIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether the file is verified.
If the field is blank the item is verified. Unverified payments are indicated with a “U” in this field.