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.