Elavon EISOP Auth Retail Transaction UML
Added On: 03/25/15
Module: UniCharge
Type: Entity
Status: Active
Java Class: ElavonEisopAuthRetailTransaction
Added On: 05/23/22
SQL Column: BIT53
Java Field: bit53
Status: Active
SQL Type: varchar(16)
Java Type: String
Added On: 12/06/19
SQL Column: BIT63_AAV_COLLECTION_INDICATOR
Java Field: bit63AavCollectionIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
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
Added On: 03/25/15
SQL Column: BIT11
Java Field: bit11
Status: Active
SQL Type: varchar(6)
Java Type: String
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
Transaction date and time.
Added On: 03/25/15
SQL Column: BIT14
Java Field: bit14
Status: Active
SQL Type: varchar
Java Type: String
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
PAN (Primary Account Number).
Added On: 03/25/15
SQL Column: BIT22
Java Field: bit22
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 03/25/15
SQL Column: BIT24
Java Field: bit24
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 03/25/15
SQL Column: BIT25
Java Field: bit25
Status: Active
SQL Type: varchar(4)
Java Type: String
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
Added On: 03/25/15
SQL Column: BIT29
Java Field: bit29
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 03/25/15
SQL Column: BIT3
Java Field: bit3
Status: Active
SQL Type: varchar(6)
Java Type: String
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
Acquiring institution IC code.
Added On: 03/25/15
SQL Column: BIT35
Java Field: bit35
Status: Active
SQL Type: varchar
Java Type: String
Added On: 03/25/15
SQL Column: BIT37
Java Field: bit37
Status: Active
SQL Type: varchar(12)
Java Type: String
Retrieval reference number.
Added On: 03/25/15
SQL Column: BIT38
Java Field: bit38
Status: Active
SQL Type: varchar(6)
Java Type: String
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
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
Added On: 03/25/15
SQL Column: BIT4
Java Field: bit4
Status: Active
SQL Type: varchar(12)
Java Type: String
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
Added On: 03/25/15
SQL Column: BIT41
Java Field: bit41
Status: Active
SQL Type: varchar(8)
Java Type: String
Card acceptor terminal identification.
Added On: 03/25/15
SQL Column: BIT42
Java Field: bit42
Status: Active
SQL Type: varchar(15)
Java Type: String
Card acceptor merchant ID.
Added On: 03/25/15
SQL Column: BIT43
Java Field: bit43
Status: Active
SQL Type: varchar(90)
Java Type: String
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
Added On: 08/03/15
SQL Column: BIT48_ELAVON_DATE_TIME
Java Field: bit48ElavonDateTime
Status: Active
SQL Type: varchar(12)
Java Type: String
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
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
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
Added On: 03/25/15
SQL Column: BIT49
Java Field: bit49
Status: Active
SQL Type: varchar(3)
Java Type: String
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
Added On: 03/25/15
SQL Column: BIT54
Java Field: bit54
Status: Active
SQL Type: varchar(15)
Java Type: String
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
Added On: 03/25/15
SQL Column: BIT55_RESPONSE
Java Field: bit55Response
Status: Active
SQL Type: varchar(999)
Java Type: String
Added On: 03/25/15
SQL Column: BIT60
Java Field: bit60
Status: Active
SQL Type: varchar(22)
Java Type: String
Added On: 03/25/15
SQL Column: BIT63
Java Field: bit63
Status: Active
SQL Type: varchar
Java Type: String
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Added On: 03/25/15
SQL Column: RETAIL_TRANSACTION_CYCLE_FK
Java Field: retailTransactionCycle
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents a group of real-time transactions which must be settled together.