Merchant Account Payment Statistics                                            
        
     
    
    
    
    
        
            Added On:  03/16/12 
        
        
        
            Module:  UniCore 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  MerchantAccountPaymentStatistics 
                    
        
        
     
    
        
            
                
                    Represents merchant account payment statistics.                
             
         
     
        
        
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_CHARGEBACK_AMOUNT
                Java Field:  amexChargebackAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_CHARGEBACK_COUNT
                Java Field:  amexChargebackCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_DECLINE_AMOUNT
                Java Field:  amexDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_DECLINE_COUNT
                Java Field:  amexDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_PAYMENT_AMOUNT
                Java Field:  amexPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_PAYMENT_COUNT
                Java Field:  amexPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_REFUND_AMOUNT
                Java Field:  amexRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Refund amount of the transaction made by American Express credit card.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_REFUND_COUNT
                Java Field:  amexRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Refund count of the transaction made by American Express credit card.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_REVERSAL_AMOUNT
                Java Field:  amexReversalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  AMEX_REVERSAL_COUNT
                Java Field:  amexReversalCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  CREATE_DATE
                Java Field:  createDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the record was created                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_CHARGEBACK_AMOUNT
                Java Field:  dinnersChargebackAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_CHARGEBACK_COUNT
                Java Field:  dinnersChargebackCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_DECLINE_AMOUNT
                Java Field:  dinnersDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_DECLINE_COUNT
                Java Field:  dinnersDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_PAYMENT_AMOUNT
                Java Field:  dinnersPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_PAYMENT_COUNT
                Java Field:  dinnersPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_REFUND_AMOUNT
                Java Field:  dinnersRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_REFUND_COUNT
                Java Field:  dinnersRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_REVERSAL_AMOUNT
                Java Field:  dinnersReversalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DINNERS_REVERSAL_COUNT
                Java Field:  dinnersReversalCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_CHARGEBACK_AMOUNT
                Java Field:  discoverChargebackAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_CHARGEBACK_COUNT
                Java Field:  discoverChargebackCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_DECLINE_AMOUNT
                Java Field:  discoverDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_DECLINE_COUNT
                Java Field:  discoverDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_PAYMENT_AMOUNT
                Java Field:  discoverPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_PAYMENT_COUNT
                Java Field:  discoverPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_REFUND_AMOUNT
                Java Field:  discoverRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_REFUND_COUNT
                Java Field:  discoverRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_REVERSAL_AMOUNT
                Java Field:  discoverReversalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  DISCOVER_REVERSAL_COUNT
                Java Field:  discoverReversalCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFFECTIVE_DATE
                Java Field:  effectiveDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_DECLINE_AMOUNT
                Java Field:  eftDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_DECLINE_COUNT
                Java Field:  eftDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_PAYMENT_AMOUNT
                Java Field:  eftPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_PAYMENT_COUNT
                Java Field:  eftPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_REFUND_AMOUNT
                Java Field:  eftRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_REFUND_COUNT
                Java Field:  eftRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_REVERSAL_AMOUNT
                Java Field:  eftReversalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  EFT_REVERSAL_COUNT
                Java Field:  eftReversalCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_CHARGEBACK_AMOUNT
                Java Field:  masterCardChargebackAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_CHARGEBACK_COUNT
                Java Field:  masterCardChargebackCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_DECLINE_AMOUNT
                Java Field:  masterCardDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_DECLINE_COUNT
                Java Field:  masterCardDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_PAYMENT_AMOUNT
                Java Field:  masterCardPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_PAYMENT_COUNT
                Java Field:  masterCardPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_REFUND_AMOUNT
                Java Field:  masterCardRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_REFUND_COUNT
                Java Field:  masterCardRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_REVERSAL_AMOUNT
                Java Field:  masterCardReversalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  MASTER_CARD_REVERSAL_COUNT
                Java Field:  masterCardReversalCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                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/16/12
                SQL Column:  OTHER_PAYMENT_AMOUNT
                Java Field:  otherPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  OTHER_PAYMENT_COUNT
                Java Field:  otherPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  OTHER_REFUND_AMOUNT
                Java Field:  otherRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  OTHER_REFUND_COUNT
                Java Field:  otherRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  REBILL_DECLINE_AMOUNT
                Java Field:  rebillDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  REBILL_DECLINE_COUNT
                Java Field:  rebillDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  REBILL_PAYMENT_AMOUNT
                Java Field:  rebillPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  REBILL_PAYMENT_COUNT
                Java Field:  rebillPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  REBILL_REFUND_AMOUNT
                Java Field:  rebillRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  REBILL_REFUND_COUNT
                Java Field:  rebillRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  RECLEAR_COUNT
                Java Field:  reclearCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  TRANSACTION_SOURCE_CL
                Java Field:  transactionSourceCl
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents current (or selected) type of transaction source.                        
                     
                 
             
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_CHARGEBACK_AMOUNT
                Java Field:  visaChargebackAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_CHARGEBACK_COUNT
                Java Field:  visaChargebackCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_DECLINE_AMOUNT
                Java Field:  visaDeclineAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_DECLINE_COUNT
                Java Field:  visaDeclineCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_PAYMENT_AMOUNT
                Java Field:  visaPaymentAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_PAYMENT_COUNT
                Java Field:  visaPaymentCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_REFUND_AMOUNT
                Java Field:  visaRefundAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_REFUND_COUNT
                Java Field:  visaRefundCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_REVERSAL_AMOUNT
                Java Field:  visaReversalAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VISA_REVERSAL_COUNT
                Java Field:  visaReversalCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VOID_AMOUNT
                Java Field:  voidAmount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  03/16/12
                SQL Column:  VOID_COUNT
                Java Field:  voidCount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer