Paymentech Stratus Chargeback Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  01/05/18 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  PaymentechStratusChargebackTransaction 
                    
        
        
     
    
        
        
                    
                        
                Added On:  01/05/18
                SQL Column:  ACCOUNT_NUMBER_MASKED
                Java Field:  accountNumberMasked
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  ACTIVITY_DATE
                Java Field:  activityDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  AUTHORIZATION_DATE
                Java Field:  authorizationDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  CATEGORY
                Java Field:  category
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  CHARGEBACK_DUE_DATE
                Java Field:  chargebackDueDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  CHARGEBACK_INITIATED_DATE
                Java Field:  chargebackInitiatedDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  CURRENT_ACTION_PRESENTMENT_CURRENCY_CHARGEBACK_AMOUNT
                Java Field:  currentActionPresentmentCurrencyChargebackAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  CURRENT_ACTION_SETTLEMENT_CURRENCY_AMOUNT
                Java Field:  currentActionSettlementCurrencyAmount
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  ENTITY_NUMBER
                Java Field:  entityNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  FEE_AMOUNT
                Java Field:  feeAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  ISSUER_CHARGEBACK_PRESENTMENT_CURRENCY_AMOUNT
                Java Field:  issuerChargebackPresentmentCurrencyAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  ISSUER_CHARGEBACK_SETTLEMENT_CURRENCY_AMOUNT
                Java Field:  issuerChargebackSettlementCurrencyAmount
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  MERCHANT_ORDER_NUMBER
                Java Field:  merchantOrderNumber
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  MOP_CODE
                Java Field:  mopCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  PAYMENTECH_STRATUS_CHARGEBACK_BATCH_FK
                Java Field:  paymentechStratusChargebackBatch
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  POTENTIAL_BUNDLED_CHARGEBACKS
                Java Field:  potentialBundledChargebacks
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  PRESENTMENT_CURRENCY
                Java Field:  presentmentCurrency
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  PREVIOUS_PARTIAL_REPRESENTMENT
                Java Field:  previousPartialRepresentment
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  REASON_CODE
                Java Field:  reasonCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  RECORD_CONTENT
                Java Field:  recordContent
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  SEQUENCE_NUMBER
                Java Field:  sequenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  SETTLEMENT_CURRENCY
                Java Field:  settlementCurrency
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  STATUS_FLAG
                Java Field:  statusFlag
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  TICKET_NUMBER
                Java Field:  ticketNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  TOKEN_INDICATOR
                Java Field:  tokenIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  TRANSACTION_DATE
                Java Field:  transactionDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  01/05/18
                SQL Column:  USAGE_CODE
                Java Field:  usageCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String