DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

UPDATE dbo.TR_REQUEST_DOC SET DMMS_ID='DM0000000000015' WHERE REQ_ID='TRRD00000251769'

UPDATE dbo.TR_REQUEST_DOC SET APPROVE_DT='2020-10-22 00:00:00.000' WHERE REQ_ID='TRRD00000251142'

UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='APPROVE',CHECKER_ID='phuongtln1',APPROVE_DT='2020-08-25' WHERE REQ_ID='TRRDI0001056104'

UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET STATUS_JOB='P' WHERE REQ_ID='TRRDI0001056104'

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='P',CHECKER_ID='phuongtln1',APPROVE_DT='2020-08-25' WHERE ID=751

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'TRRDI0001056104',N'APPROVE',N'C',N'',N'',N'',NULL,N'DMMS',N'N',N'',N'',N'Hoàn tất',NULL,NULL) 

UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='APPROVE',EFFEC_DT='2020-12-15 09:35:00.000' WHERE REQ_ID='PLRD00000200859'

UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C',PARENT_PROCESS_ID='KT' WHERE ID=9994

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=9991

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=9992

DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID=9993

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF=AMT_TF+2250000 WHERE TRADE_ID='PLT000000073585'

UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF=AMT_RECEIVE_TF+2250000,AMT_ETM=AMT_ETM+ 2250000 WHERE TRADE_ID='PLT000000073585'