Project

General

Profile

Download (1.08 KB)

TCTC 0016.txt

Truong Nguyen Vu, 11/24/2020 01:34 PM

 
1 

    		
  

  

    
      2
    
    
      
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000200701'


    		
  

  

    
      3
    
    
      
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='U',PARENT_PROCESS_ID='TGD_TT' WHERE REQ_ID='PLRD00000200701' AND PROCESS_ID='APPROVE'


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200701',N'GDK_TT',N'C',N'GDK',N'',N'',NULL,N'TC',N'N',NULL,N'DM0000000000015',N'Chờ giám đốc khối xác nhận',NULL,NULL)


    		
  

  

    
      7
    
    
      
INSERT INTO [PL_REQUEST_PROCESS] ([REQ_ID],[PROCESS_ID],[STATUS],[ROLE_USER],[BRANCH_ID],[CHECKER_ID],[APPROVE_DT],[PARENT_PROCESS_ID],[IS_LEAF],[COST_ID],[DVDM_ID],[NOTES],[IS_HAS_CHILD],[DEP_ID])VALUES(N'PLRD00000200701',N'TGD_TT',N'U',N'TGD',N'',N'',NULL,N'GDK_TT',N'N',NULL,N'',N'Chờ Tổng giám xác nhận',NULL,NULL)


    		
  

  

    
      8
    
    
      

    		
  

  

    
      9
    
    
      
 UPDATE PL_TRADEDETAIL SET AMT_ETM=AMT_ETM-42000000,AMT_RECEIVE_TF=AMT_RECEIVE_TF-42000000 WHERE TRADE_ID='PLT000000251020'


    		
  

  

    
      10
    
    
      
 UPDATE dbo.PL_TRADEDETAIL SET AMT_TF=AMT_TF-42000000 WHERE TRADE_ID='PLT000000075713'