Elavon EISOP Auth Retail Transaction UML


Added On:  03/25/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ElavonEisopAuthRetailTransaction 
Elavon specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Elavon specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  05/23/22
SQL Column:  BIT53
Java Field:  bit53
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  12/06/19
SQL Column:  BIT63_AAV_COLLECTION_INDICATOR
Java Field:  bit63AavCollectionIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  12/06/19
SQL Column:  BIT63_UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER
Java Field:  bit63UniqueTransactionResponseReferenceNumber
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Added On:  03/25/15
SQL Column:  BIT11
Java Field:  bit11
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
System Trace Audit Number (STAN).
Added On:  03/25/15
SQL Column:  BIT12
Java Field:  bit12
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Transaction date and time.
Added On:  03/25/15
SQL Column:  BIT14
Java Field:  bit14
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Expiration date of the credit card or bank account number.
Added On:  03/25/15
SQL Column:  BIT2
Java Field:  bit2
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
PAN (Primary Account Number).
Added On:  03/25/15
SQL Column:  BIT22
Java Field:  bit22
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
POS data code.
Added On:  03/25/15
SQL Column:  BIT24
Java Field:  bit24
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Function code.
Added On:  03/25/15
SQL Column:  BIT25
Java Field:  bit25
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Reason code.
The reason code identifying the decline.
Added On:  03/25/15
SQL Column:  BIT28
Java Field:  bit28
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Reconciliation date.
Added On:  03/25/15
SQL Column:  BIT29
Java Field:  bit29
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Reconciliation number.
Added On:  03/25/15
SQL Column:  BIT3
Java Field:  bit3
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Processing code.
Submitted on all Canadian debit transactions to indicate the transaction type.
Added On:  03/25/15
SQL Column:  BIT32
Java Field:  bit32
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Acquiring institution IC code.
Added On:  03/25/15
SQL Column:  BIT35
Java Field:  bit35
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Track 2.
Added On:  03/25/15
SQL Column:  BIT37
Java Field:  bit37
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Retrieval reference number.
Added On:  03/25/15
SQL Column:  BIT38
Java Field:  bit38
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Contains approval code for an approved transaction.

Note: If response code of the authorization is not equal to "AA" or “AP”, the content of this field is ignored.
Added On:  03/25/15
SQL Column:  BIT38_RESPONSE
Java Field:  bit38Response
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Contains approval code for an approved transaction.

Note: If response code of the authorization is not equal to "AA" or “AP”, the content of this field is ignored.
Added On:  03/25/15
SQL Column:  BIT39_RESPONSE
Java Field:  bit39Response
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Action code.
Added On:  03/25/15
SQL Column:  BIT4
Java Field:  bit4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Total amount of the transaction.
Added On:  03/25/15
SQL Column:  BIT4_RESPONSE
Java Field:  bit4Response
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Transaction amount.
Added On:  03/25/15
SQL Column:  BIT41
Java Field:  bit41
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Card acceptor terminal identification.
Added On:  03/25/15
SQL Column:  BIT42
Java Field:  bit42
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Card acceptor merchant ID.
Added On:  03/25/15
SQL Column:  BIT43
Java Field:  bit43
Status:  Active
SQL Type:  varchar(90)
Java Type:  String
Attributes:
Card acceptor location name and address.
Added On:  03/25/15
SQL Column:  BIT48
Java Field:  bit48
Status:  Active
SQL Type:  varchar(65)
Java Type:  String
Attributes:
Additional private data.
Added On:  08/03/15
SQL Column:  BIT48_ELAVON_DATE_TIME
Java Field:  bit48ElavonDateTime
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The Elavon Date and Time will be returned to the POS or partner host system in the event of an approval of a sale transaction. This data must be provided to the Elavon host in the event of a reversal of the aforementioned sale transaction. This sub-field must be populated irrespective of whether single or dual message processing is used.
Added On:  08/03/15
SQL Column:  BIT48_ELAVON_RETRIEVAL_REF_NUMBER
Java Field:  bit48ElavonRetrievalRefNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
The Elavon RRN field will be returned to the POS or partner host system in the event of an approval of a sale transaction. This data must be provided to the Elavon host in the event of a reversal of the aforementioned sale transaction. This sub-field must be populated irrespective of whether single or dual message processing is used.
Added On:  08/03/15
SQL Column:  BIT48_ELAVON_STAN
Java Field:  bit48ElavonStan
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The Elavon STAN will be returned to the POS or partner host system in the event of an approval of a sale transaction. This data must be provided to the Elavon host in the event of a reversal of the aforementioned sale transaction. This sub-field must be populated irrespective of whether single or dual message processing is used.
Added On:  03/25/15
SQL Column:  BIT48_RESPONSE
Java Field:  bit48Response
Status:  Active
SQL Type:  varchar(65)
Java Type:  String
Attributes:
Additional private data.
Added On:  03/25/15
SQL Column:  BIT49
Java Field:  bit49
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Transaction currency code.
Represents transaction ISO currency code used in the foreign exchange rate message.
Added On:  03/25/15
SQL Column:  BIT52
Java Field:  bit52
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
PIN data.
Added On:  03/25/15
SQL Column:  BIT54
Java Field:  bit54
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Used to indicate a secondary “cashback” amount associated with the transaction.
Added On:  03/25/15
SQL Column:  BIT55
Java Field:  bit55
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
ICC data.
Added On:  03/25/15
SQL Column:  BIT55_RESPONSE
Java Field:  bit55Response
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
ICC data.
Added On:  03/25/15
SQL Column:  BIT60
Java Field:  bit60
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Reserved private data.
Added On:  03/25/15
SQL Column:  BIT63
Java Field:  bit63
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Reserved private data III.
Added On:  04/02/15
SQL Column:  BIT63_ACI
Java Field:  bit63Aci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reserved private data III.
Authorization characteristic indicator.
Added On:  04/02/15
SQL Column:  BIT63_AVS_RESULT_CODE
Java Field:  bit63AvsResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reserved private data III AVS result code.
Added On:  04/02/15
SQL Column:  BIT63_BANK_NET_DATE
Java Field:  bit63BankNetDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Reserved private data III.
Added On:  04/02/15
SQL Column:  BIT63_CVV_RESULT_CODE
Java Field:  bit63CvvResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reserved private data III CVV result code.
Added On:  04/02/15
SQL Column:  BIT63_PRODUCT_ID
Java Field:  bit63ProductId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Reserved private data III.
Identification number of the purchased product.
Added On:  03/25/15
SQL Column:  BIT63_RESPONSE
Java Field:  bit63Response
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Reserved private data III.
Added On:  08/03/15
SQL Column:  BIT63_STAN
Java Field:  bit63Stan
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
System Trace Audit Number (STAN)
Unique number of transaction. This value should be unique on the partner’s host system within a 24 hour period.
Added On:  04/02/15
SQL Column:  BIT63_TRACK_DATA_CONDITION_CODE
Java Field:  bit63TrackDataConditionCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Reserved private data III.
Track data condition code.
Added On:  04/02/15
SQL Column:  BIT63_TRAN_ID
Java Field:  bit63TranId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Reserved private data III.
The code of the initial transaction. Provided by the processor.
Added On:  04/02/15
SQL Column:  BIT63_UP_DATE_TIME
Java Field:  bit63UpDateTime
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Reserved private data III.
Added On:  04/02/15
SQL Column:  BIT63_UP_SETTLEMENT_DATE
Java Field:  bit63UpSettlementDate
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Reserved private data III.
Added On:  04/02/15
SQL Column:  BIT63_VALIDATION_CODE
Java Field:  bit63ValidationCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Reserved private data III.
The CPS validation code returned on the original authorization response.
Added On:  03/25/15
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/25/15
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:  03/25/15
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/25/15
SQL Column:  MESSAGE_TYPE
Java Field:  messageType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
ISO message type.
Added On:  03/25/15
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.