Project

General

Profile

Download (681 Bytes)

Script_UPD_MW_081222.txt

Luc Tran Van, 12/08/2022 01:51 PM

 
1 
update MW_MAST_BAL set QTY_BALANCE = 0, TOTAL_AMT = 0 where MAST_BAL_ID = 'MWMASTBAL001572'
2 
insert into MW_MAST_BAL_STMT values('MWBALSTMT068176', '', 'MWMASTBAL001572', GETDATE(), NULL, 'O', 'D', 51, '', 2486250.00, 48750)
3 

    		
  

  

    
      4
    
    
      
update MW_MAST_BAL set QTY_BALANCE = 0, TOTAL_AMT = 0 where MAST_BAL_ID = 'MWMASTBAL001631'


    		
  

  

    
      5
    
    
      
insert into MW_MAST_BAL_STMT values('MWBALSTMT068177', '', 'MWMASTBAL001631', GETDATE(), NULL, 'O', 'D', 3, '', 585000.00, 195000)


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
update MW_MAST_BAL set QTY_BALANCE = 0, TOTAL_AMT = 0 where MAST_BAL_ID = 'MWMASTBAL001690'


    		
  

  

    
      8
    
    
      
insert into MW_MAST_BAL_STMT values('MWBALSTMT068178', '', 'MWMASTBAL001690', GETDATE(), NULL, 'O', 'D', 36, '', 3510000.00, 97500)