UniPay Chargeback Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  09/21/16 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  UniPayChargebackTransaction 
                    
        
        
     
    
        
            
                
                    Entity that represents chargeback transaction within UniPay.                
             
         
     
        
        
                    
                        
                Added On:  09/21/16
                SQL Column:  ACCOUNT_ACCESSORY
                Java Field:  accountAccessory
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        When transaction is associated with a credit card, the field contains card's expiration date. When transaction is associated with a bank account, the field contains account's routing number.
                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  
                Java Field:  accountAccessoryUpdated
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        New account accessory for the record.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  ACCOUNT_NUMBER_MASKED
                Java Field:  accountNumberMasked
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Account number encrypted for security purposes.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  
                Java Field:  accountNumberUpdated
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        New account number for the record.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  ACCOUNT_TYPE
                Java Field:  accountType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the account within the system.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  ACCOUNT_TYPE_UPDATED
                Java Field:  accountTypeUpdated
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        New account type for the record.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  AGGREGATE_REFERENCE_NUMBER
                Java Field:  aggregateReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Aggregated secondary identifier that is used to cross-reference records between UniPay and integrated systems. 
                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  AGGREGATE_TRANSACTION_CODE
                Java Field:  aggregateTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Aggregated transaction code used within the system.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  AGGREGATE_TRANSACTION_INTERNAL_CODE
                Java Field:  aggregateTransactionInternalCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Aggregated code of the transaction used in internal source.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount included in the transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  APPROVAL_CODE
                Java Field:  approvalCode
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Approval code within the system.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  AVS_RESPONSE_CODE
                Java Field:  avsResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        AVS response code generated by the system.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents a base object for transactions of Sale type.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  EXPECTED_EFFECTIVE_DATE
                Java Field:  expectedEffectiveDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Planned date of the transaction processing.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  HOLDER_NAME
                Java Field:  holderName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the holder associated with the transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  HOLDER_NAME_UPDATED
                Java Field:  holderNameUpdated
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        New holder's name for the record.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                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:  09/21/16
                SQL Column:  IS_REBILL_ENABLED
                Java Field:  isRebillEnabled
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicated whether the rebill function is active within the system.                        
                     
                 
             
                    
                        
                Added On:  09/22/16
                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:  09/21/16
                SQL Column:  ORIGINAL_REFERENCE_NUMBER
                Java Field:  originalReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Secondary identifier which can be used to cross-reference records between UniPay and integrated systems, that was originally generated.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  ORIGINAL_TRANSACTION_CODE
                Java Field:  originalTransactionCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Original code of the processed transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  ORIGINAL_TRANSACTION_DATE
                Java Field:  originalTransactionDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Original date of the transaction processing.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  PROCESSED_AMOUNT
                Java Field:  processedAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount included in the processed transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  PROVIDER_AVS_RESPONSE_CODE
                Java Field:  providerAvsResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        AVS response code assigned by a provider.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  PROVIDER_MERCHANT_ACCOUNT_CODE
                Java Field:  providerMerchantAccountCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of Merchant Account assigned by a provider. 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:  09/21/16
                SQL Column:  PROVIDER_RESPONSE_CODE
                Java Field:  providerResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response code assigned by a provider.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  PROVIDER_RESPONSE_MESSAGE
                Java Field:  providerResponseMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response message assigned by a provider.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  REFERENCE_NUMBER
                Java Field:  referenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Secondary identifier which can be used to cross-reference records between UniPay and integrated systems.                         
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response code generated by the system.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  RESPONSE_MESSAGE
                Java Field:  responseMessage
             
            
                Status:  Active
                SQL Type:  varchar(250)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response message within the system.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  RETRY_FEE_AMOUNT
                Java Field:  retryFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount of the fee in case of retry operation.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  SEQUENCE_NUMBER
                Java Field:  sequenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Sequence number of the transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  SUBMISSION_CODE
                Java Field:  submissionCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/16
                SQL Column:  TOKEN
                Java Field:  token
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token used for transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  TOKEN_UPDATED
                Java Field:  tokenUpdated
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        New token for the record.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  TRANSACTION_CODE
                Java Field:  transactionCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the processed transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  TRANSACTION_DATE
                Java Field:  transactionDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date of the transaction processing.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  TRANSACTION_INTERNAL_CODE
                Java Field:  transactionInternalCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the transaction used for identification in internal source.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  TRANSACTION_TYPE
                Java Field:  transactionType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the processed transaction.                        
                     
                 
             
                    
                        
                Added On:  09/21/16
                SQL Column:  WARNING_CODE
                Java Field:  warningCode
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Warning code generated by the system.