Project

General

Profile

Download (489 Bytes)

FILE 3 UPDATE DC.txt

Luc Tran Van, 10/28/2020 04:30 PM

 
1 
UPDATE dbo.PL_TRADEDETAIL SET AMT_TF = AMT_TF + 900000 WHERE TRADE_ID='PLT000000073643'
2 
UPDATE dbo.PL_TRADEDETAIL SET AMT_TF = AMT_TF + 1700000 WHERE TRADE_ID='PLT000000073645'
3 
UPDATE dbo.PL_TRADEDETAIL SET AMT_TF = AMT_TF + 2000000 WHERE TRADE_ID='PLT000000073649'
4 

    		
  

  

    
      5
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF= AMT_RECEIVE_TF+ 4600000, AMT_ETM=AMT_ETM+ 3600000 WHERE TRADE_ID='PLT000000073639'


    		
  

  

    
      6
    
    
      
UPDATE dbo.PL_TRADEDETAIL SET  AMT_ETM=AMT_ETM+ 1000000 WHERE TRADE_ID='PLT000000073640'