Project

General

Profile

UPDATE_DATA_CONTRACT.txt

Truong Nguyen Vu, 08/20/2020 02:19 PM

 
1
UPDATE dbo.TR_CONTRACT SET SIGN_DT='2020-05-07',START_DT='2020-05-07'  WHERE CONTRACT_ID='TRCI00001127261'
2
UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT]=26.29,PAY_AMOUNT='3050000000',PAY_STATUS='DTT' WHERE PAY_ID='TRCPI0001127091'
3
UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT]=12.16,PAY_STATUS='CTT' WHERE PAY_ID='TRCPI0001127092'
4
UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT]=61.55,PAY_STATUS='CTT' WHERE PAY_ID='TRCPI0001127093'
5
UPDATE dbo.PL_REQUEST_DOC SET REQ_NAME=N'Bảo trì hệ thống CNTT năm 2020' WHERE REQ_ID='PLRDI0000100083'