EFT T Tech Batch Transaction UML


Added On:  02/13/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  EftTtechBatchTransaction 
Represents EFT T Tech batch transaction.
Added On:  02/13/12
SQL Column:  ACCEPT_DATE
Java Field:  acceptDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Transaction Date (Time stamp not included)
Added On:  06/10/16
SQL Column:  
Java Field:  account
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/13/12
SQL Column:  ACH_DATE
Java Field:  achDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  ACTION
Java Field:  action
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
We use value AUTH
Added On:  02/13/12
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Address information
Added On:  02/13/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Total amount of the transactions including discount and tax.
Added On:  02/13/12
SQL Column:  APPLICATION
Java Field:  application
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
We use such values for this field:
DDA (when AccountClassifier is CHECKING),
Savings (when AccountClassifier is SAVING)
Added On:  02/13/12
SQL Column:  BATCH_NUMBER
Java Field:  batchNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The number of each batch
Added On:  02/13/12
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:  02/13/12
SQL Column:  CHECK_NUMBER
Java Field:  checkNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Number of the customer's check.
Added On:  02/13/12
SQL Column:  CHECK_TYPE
Java Field:  checkType
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
We use such values for this field:
BUSINESS, PERSONAL
Added On:  02/13/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Customer's city
Added On:  02/13/12
SQL Column:  CLASS_CODE
Java Field:  classCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
We use such values for this field:
PPD - for personal
CCD - for company
Added On:  02/13/12
SQL Column:  COLLECTION_LEVEL
Java Field:  collectionLevel
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Collection service such as guarantee, charge back to merchant, NOC’s, etc
Added On:  02/13/12
SQL Column:  COMPANY
Java Field:  company
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Company name
Added On:  02/13/12
SQL Column:  CUSTOMER_NAME
Java Field:  customerName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Customer's name
Added On:  02/13/12
SQL Column:  EFT_TTECH_BATCH_FK
Java Field:  eftTtechBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References EFT T Tech Batch
Attributes:
Reference to the entity that represents EFT T-Tech batch information.
Added On:  02/13/12
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Customer's email
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Customer's last name
Added On:  02/13/12
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:  02/13/12
SQL Column:  NOC_DATA1
Java Field:  nocData1
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Populated with NOC changes
Added On:  02/13/12
SQL Column:  NOC_DATA2
Java Field:  nocData2
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Populated with NOC changes
Added On:  02/13/12
SQL Column:  NOC_DATA3
Java Field:  nocData3
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
Populated with NOC changes
Added On:  02/13/12
SQL Column:  PAYMENT_TYPE
Java Field:  paymentType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
We use value S for this field
Added On:  02/13/12
SQL Column:  PHONE1
Java Field:  phone1
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Customer's phone number
Added On:  02/13/12
SQL Column:  RETURN_DATE
Java Field:  returnDate
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date, when the return was received
Added On:  02/13/12
SQL Column:  RETURN_DISPOSITION
Java Field:  returnDisposition
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  RETURN_REASON
Java Field:  returnReason
Status:  Active
SQL Type:  varchar(75)
Java Type:  String
Attributes:
This field will contain the description of the return based on the value Return Reason Code
Added On:  02/13/12
SQL Column:  RETURN_REASON_CODE
Java Field:  returnReasonCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
This field will contain one of the standard codes used to describe the reason for returning the entry
Added On:  02/13/12
SQL Column:  RETURN_TYPE_CODE
Java Field:  returnTypeCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type code of return. We use R (return) or C (notification) values
Added On:  06/10/16
SQL Column:  
Java Field:  routingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  02/13/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Customer's state
Added On:  02/13/12
SQL Column:  TRAN_DATE
Java Field:  tranDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Transaction Date - date, when the transaction was created
Added On:  02/13/12
SQL Column:  TRAN_ID
Java Field:  tranId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Transaction Id. The number can rollover naturally but should not be reset to a starting value for each transmission
Added On:  02/13/12
SQL Column:  TRAN_REFERENCE
Java Field:  tranReference
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Transaction Code
Added On:  02/13/12
SQL Column:  TRAN_TYPE
Java Field:  tranType
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This field identifies the transaction type. We use values:
Credit, Debit
Added On:  02/13/12
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP or postal code of the mailing address.