Reseller Statement Extended Breakdown                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  07/09/24 
        
        
        
            Module:  UniCore 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  ResellerStatementExtendedBreakdown 
                    
        
        
     
    
        
        
                    
                        
                Added On:  07/09/24
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Amount (in cents) of the record.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  DESCRIPTION
                Java Field:  description
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Any additional details associated with the record.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Unique record ID generated by the system.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Reference to a merchant that the record is associated with.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  MERCHANT_STATEMENT_FK
                Java Field:  merchantStatement
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to a merchant statement that the record is associated with.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  REMITTANCE_DATE
                Java Field:  remittanceDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        
Date when the amount was remitted.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  RESELLER_CODE
                Java Field:  resellerCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Reference to a reseller that the record is associated with.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  RESELLER_STATEMENT_EXTENDED_FK
                Java Field:  resellerStatementExtended
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to a reseller statement that the record is associated with.                        
                     
                 
             
                    
                        
                Added On:  07/09/24
                SQL Column:  RESELLER_STATEMENT_RECORD_CL
                Java Field:  resellerStatementRecordCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String