Project

General

Profile

Download (1.81 KB)

2.0 CAP NHAT THONG TIN PHIEU THANH TOAN.txt

Luc Tran Van, 04/08/2022 02:14 PM

 
1 
DECLARE @REQ_ID VARCHAR(15)
2 
SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='042022/000397')
3 
UPDATE TR_REQ_PAYMENT SET REQ_REASON =N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )'
4 
WHERE REQ_PAY_ID=@REQ_ID
5 
--UPDATE TR_REQ_ADVANCE_DT SET  WHERE REQ_PAY_ID=@REQ_ID
6 
UPDATE TR_REQ_PAY_SCHEDULE SET CURRENCY ='USD', RATE=22720, AMT_PAY_REAL =192.30, REQ_PAY_DESC=N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )',
7 
REQ_PAY_ENTRIES=N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )'
8 
WHERE REQ_PAY_ID=@REQ_ID
9 

    		
  

  

    
      10
    
    
      
UPDATE TR_REQ_PAY_METHOD SET TOTAL_AMT =192.30, CURRENCY ='USD', RATE=22720, REQ_PAY_DESC =N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )',


    		
  

  

    
      11
    
    
      
REQ_PAY_ENTRIES=N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )',


    		
  

  

    
      12
    
    
      
REQ_PAY_REASON =N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )'


    		
  

  

    
      13
    
    
      
WHERE REQ_PAY_ID=@REQ_ID


    		
  

  

    
      14
    
    
      

    		
  

  

    
      15
    
    
      
UPDATE TR_REQ_PAY_BUDGET SET AMT_DO = 192.30, CURRENCY ='USD', RATE=22720, 


    		
  

  

    
      16
    
    
      
REASON =N'TT Phí tham gia Giải thưởng FinanceAsia Country Awards - Most innovative use of technology - International- Viet nam (HKD = 1500 tương đương USD = 192.30 )'


    		
  

  

    
      17
    
    
      
WHERE REQ_PAY_ID=@REQ_ID


    		
  

  

    
      18
    
    
      

    		
  

  

    
      19
    
    
      

    		
  

  

    
      20
    
    
      
---202248