Project

General

Profile

Download (742 Bytes)

1.8 UPDATE NS CHI PHI PDN THANH TOAN 082021 000300.txt

Luc Tran Van, 08/16/2021 08:28 PM

 
1 
DECLARE @REQ_ID VARCHAR(15), @REASON NVARCHAR(1000)
2 

    		
  

  

    
      3
    
    
      
SET @REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000300')


    		
  

  

    
      4
    
    
      
SET @REASON =(SELECT top 1 REQ_REASON  FROM TR_REQ_PAYMENT WHERE  REQ_PAY_ID =@REQ_ID)


    		
  

  

    
      5
    
    
      
UPDATE TR_REQ_PAY_BUDGET SET AMT_APP =251910071, AMT_DO =0, AMT_REMAIN =251910071 WHERE BUDG_ID ='TRBG00000281803'


    		
  

  

    
      6
    
    
      
INSERT INTO TR_REQ_PAY_BUDGET(BUDG_ID, GD_ID, REQ_PAY_ID, TRADE_ID, AMT_APP, AMT_DO, AMT_EXE, AMT_REMAIN, MAKER_ID, CREATE_DT, CURRENCY, RATE, REASON, NOTES, TYPE_COST, FR_LEVEL, TO_LEVEL)


    		
  

  

    
      7
    
    
      
VALUES


    		
  

  

    
      8
    
    
      
('BUDGID000000002','GOO000000251701',@REQ_ID,'PLT000000260527',68087250,0,0,68087250,'phuongvn',GETDATE(),'VND',1,@REASON,'',NULL,0,0)


    		
  

  

    
      9
    
    
      
SELECT *  FROM TR_REQ_PAY_BUDGET WHERE  REQ_PAY_ID =@REQ_ID