EFT GETI Retail Transaction UML


Added On:  01/23/14 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  EftGetiRetailTransaction 
GETI specific low-level representation of Retail Transaction produced by Forward Transformation Process within Settlement Process.

During Generation Process, GETI specific interchange message is generated from this object for settlement. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  06/10/16
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Bank account number of the client.
Added On:  01/23/14
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Contains the type of account. Valid values are Checking or Savings.
Added On:  01/23/14
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
The first line of the consumer’s address. The Address1 can be up to 200 alpha-numeric characters and can include the following: "#" , " - " , " : " , " ; ".
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:  01/23/14
SQL Column:  CHECK_AMOUNT
Java Field:  checkAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
The amount of the check.
Added On:  07/10/14
SQL Column:  CHECK_IMAGE_FK
Java Field:  checkImage
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Check Image
Attributes:
Reference to the entity that represents the image checking.
Added On:  01/23/14
SQL Column:  CHECK_NUMBER
Java Field:  checkNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The keyed in check number.
Added On:  01/23/14
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The city of the consumer’s address.
Added On:  01/23/14
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Contains the text message with the Authorization Number if the transaction was Approved or additional information if the transaction was not approved.
Added On:  02/18/14
SQL Column:  COMPANY_NAME
Java Field:  companyName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
The consumer company's name.
Added On:  01/23/14
SQL Column:  CUSTOM1
Java Field:  custom1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
This is the optional element that can contain up to 50 alpha numeric
characters.
Added On:  01/23/14
SQL Column:  CUSTOM2
Java Field:  custom2
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
This is the optional element that can contain up to 50 alpha numeric
characters.
Added On:  01/23/14
SQL Column:  CUSTOM3
Java Field:  custom3
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
This is the optional element that can contain up to 50 alpha numeric
characters.
Added On:  01/23/14
SQL Column:  CUSTOM4
Java Field:  custom4
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
This is the optional element that can contain up to 50 alpha numeric
characters.
Added On:  02/27/14
SQL Column:  DL_NUMBER
Java Field:  dlNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Contains the consumer’s driver’s license number.
Added On:  02/27/14
SQL Column:  DL_STATE
Java Field:  dlState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The consumer’s driver’s license state or province code.
Added On:  02/27/14
SQL Column:  DOB_YEAR
Java Field:  dobYear
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Contains the date of birth of the consumer. The date of birth must be 4 numeric characters begin with either 19 or 20.
Added On:  01/23/14
SQL Column:  EXCEPTION_MESSAGE
Java Field:  exceptionMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Contains text information about the exception.
Added On:  01/23/14
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
The first name of the consumer which can be up to 100 alpha characters.
Added On:  01/23/14
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:  01/23/14
SQL Column:  IDENTIFIER
Java Field:  identifier
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Contains a value that identifies the packet being sent as an Authorization, Void, Override or Payroll transaction. The identifier is a single alpha character.
(A=Authorize, V=Void, O=Override, P=Payroll, R=Recurring, F=Reversal)
Added On:  07/10/14
SQL Column:  IMAGE_BACK_SIZE
Java Field:  imageBackSize
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Contains the image data for the check back. Image data must be base64.
Added On:  07/10/14
SQL Column:  IMAGE_FRONT_SIZE
Java Field:  imageFrontSize
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Contains the image data for the check front. Image data must be base64.
Added On:  01/23/14
SQL Column:  IS_TEST_MODE
Java Field:  isTestMode
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates, whether test mode is enabled for this profile or not.
Added On:  01/23/14
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
The last name of the consumer which can be up to 100 alpha characters.
Added On:  01/23/14
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:  01/23/14
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Contains additional text information about the transaction.
Added On:  06/10/16
SQL Column:  
Java Field:  micrData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/10/16
SQL Column:  
Java Field:  password
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Password associating with the specified username.
Added On:  01/23/14
SQL Column:  PHONE_NUMBER
Java Field:  phoneNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The contact phone number of the consumer.
Required for PPD, CCD, TEL and WEB transactions, optional for POP and Check21 transactions.
Added On:  01/23/14
SQL Column:  REQUEST_ID
Java Field:  requestId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Contains a unique user defined ID to identify the authorization gateway request. The Request ID will be returned in the Authorization Gateway
response.
Added On:  01/23/14
SQL Column:  RESPONSE_TYPE
Java Field:  responseType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Contains an identifier to aid in determining the transaction result.
Added On:  01/23/14
SQL Column:  RESPONSE_TYPE_TEXT
Java Field:  responseTypeText
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The full text description of the response type identifier.
Added On:  01/23/14
SQL Column:  RESULT_CODE
Java Field:  resultCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Contains a numeric bit that indicates one or many result messages. Examples of result messages are Approved, Decline, or Unpaid Check Limit Exceeded.
Added On:  07/10/14
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  06/10/16
SQL Column:  
Java Field:  routingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Routing number of the bank account.
Added On:  02/27/14
SQL Column:  SSN4
Java Field:  ssn4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Contains the last four digits of the consumer’s social security number. The SSN4 must be 4 numeric characters.
Added On:  01/23/14
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The state or province of the consumer’s address.
Added On:  01/23/14
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Contains the ID for the Terminal. The Terminal ID will be numeric and be six digits.
Unique to each “virtual terminal” used. Provided by GETI at time of terminal approval.
Added On:  01/23/14
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
An optional element that contains a unique user defined ID to identify the transaction. The Transaction ID will be returned in the Authorization Gateway response.
Added On:  01/23/14
SQL Column:  TYPE_CODE
Java Field:  typeCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Contains a numeric bit that indicates one or many type messages. Examples of type messages are Personal Check, Business Check, or Voided Check
Added On:  06/10/16
SQL Column:  
Java Field:  userName
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Username to login the system.
Added On:  01/23/14
SQL Column:  VALIDATION_ERROR_MESSAGE
Java Field:  validationErrorMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The complete validation error message that include the element that
failed the validation and may contain the location the validation error occurred.
Added On:  01/23/14
SQL Column:  VALIDATION_MESSAGE_RESULT
Java Field:  validationMessageResult
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Contains additional text information about the validation and
Passed or Failed indicating if the validation was successful or not.
Added On:  01/23/14
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The ZIP code of the consumer’s address.