Chargeback Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  02/13/12 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  ChargebackTransaction 
                    
        
        
     
    
        
            
                
                    Represents CC chargebacks, chargeback reversals and ACH returns.
                
             
         
     
        
        
                    
                        
                Added On:  11/13/13
                SQL Column:  AGGREGATE_TRANSACTION_FK
                Java Field:  aggregateTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents aggregate transaction information.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  ASSESSMENTS_FEE_AMOUNT
                Java Field:  assessmentsFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The total of assessment fees charged by an association for processing/settlement of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  BANK_DATE
                Java Field:  bankDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when ACH return/CC chargeback was received by a bank.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CALLBACK_DATE
                Java Field:  callbackDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when transaction was posted back to merchant's front-end system through a callback mechanism.
                        
                     
                 
             
                    
                        
                Added On:  09/20/18
                SQL Column:  CASE_NUMBER
                Java Field:  caseNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/10/16
                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:  02/13/12
                SQL Column:  CHARGEBACK_CL
                Java Field:  chargebackCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of chargeback.
                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  CUSTOM_FIELD
                Java Field:  customField
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Implementation specific field to pass some custom information to the merchants.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  DEPOSIT_DATE
                Java Field:  depositDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when this ACH return/CC chargeback got incorporated into a Merchant Statement.
                        
                     
                 
             
                    
                        
                Added On:  05/22/24
                SQL Column:  FEE_AMOUNT
                Java Field:  feeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/14/19
                SQL Column:  FILE_STORE_CODE
                Java Field:  fileStoreCode
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  01/31/13
                SQL Column:  FLAT_FEE_AMOUNT
                Java Field:  flatFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Flat fee charged on the transaction by the third party processor (gateway owner) for processing of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  INTERCHANGE_FEE_AMOUNT
                Java Field:  interchangeFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The total amount of Interchange Percentage Fee and Interchange Flat Fee.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  INTERCHANGE_FLAT_FEE
                Java Field:  interchangeFlatFee
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Flat fee charged on a transaction by an association for processing of the card.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  INTERCHANGE_PERCENTAGE_FEE
                Java Field:  interchangePercentageFee
             
            
                Status:  Active
                SQL Type:  int(11)(60)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Percentage fee, charged of a total transaction amount by an association for processing of the card.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  INTERCHANGE_RATE_NAME
                Java Field:  interchangeRateName
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The name of the interchange rate that this transaction is qualified.
                        
                     
                 
             
                    
                        
                Added On:  11/22/13
                SQL Column:  IS_AGGREGATE_TRANSACTION
                Java Field:  isAggregateTransaction
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the type of transaction is aggregation.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                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:  04/04/14
                SQL Column:  ORIGINAL_CHARGEBACK_TRANSACTION_FK
                Java Field:  originalChargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents original chargeback transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  PROCESSING_FEE_AMOUNT
                Java Field:  processingFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Surcharge that is charged as a percentage of the transaction total by the third party processor (gateway owner) for processing of the transaction.
                        
                     
                 
             
                    
                        
                Added On:  01/31/13
                SQL Column:  PROCESSOR_FEE_AMOUNT
                Java Field:  processorFeeAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Flat fee charged by the processor for processing of a transaction.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PROVIDER_DATE
                Java Field:  providerDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when ACH return/CC chargeback was received by an underlined processor.
                        
                     
                 
             
                    
                        
                Added On:  02/18/21
                SQL Column:  PROVIDER_REFERENCE_NUMBER
                Java Field:  providerReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/14/13
                SQL Column:  PROVIDER_RESPONSE_CODE
                Java Field:  providerResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Original response code generated by the provider.
                        
                     
                 
             
                    
                        
                Added On:  07/25/18
                SQL Column:  PROVIDER_RESPONSE_MESSAGE
                Java Field:  providerResponseMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/18/21
                SQL Column:  PROVIDER_TRANSACTION_ID
                Java Field:  providerTransactionId
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  11/14/13
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated response code. 
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  RESPONSE_DATE
                Java Field:  responseDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when ACH return/CC chargeback was received.
                        
                     
                 
             
                    
                        
                Added On:  11/14/13
                SQL Column:  RESPONSE_MESSAGE
                Java Field:  responseMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated response message. 
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SEQUENCE_NUMBER
                Java Field:  sequenceNumber
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Sequence number of a chargeback.
                        
                     
                 
             
                    
                        
                Added On:  04/04/14
                SQL Column:  SUBMISSION_FK
                Java Field:  submission
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents submission information.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TRANSACTION_CL
                Java Field:  transactionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of selected transaction processing mode.
                        
                     
                 
             
                    
                        
                Added On:  06/06/18
                SQL Column:  TRANSACTION_TYPE
                Java Field:  transactionType
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
                
                    Attributes:
                    ReadOnly, Calculated                
                             
            
                
                    
                        
                        Type of the transaction. 
The value is based on the chargebackCl field value.