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

UPDATE TR_REQUEST_DOC_DT SET TRAN_TYPE_ID ='TRN0000000003' WHERE REQ_DOC_ID ='TRRD00000251513'

UPDATE TR_REQUEST_DOC SET BRANCH_DVMS = BRANCH_CREATE, DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000742')) WHERE REQ_CODE ='PUR/2020/000742'

UPDATE  PL_TRADEDETAIL SET AMT_ETM = AMT_ETM -15000000 WHERE TRADE_ID ='PLT000001062955'

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-10-28' WHERE REQ_ID ='TRRD00000251341'

UPDATE PL_PROCESS SET APPROVE_DT ='2020-10-28' WHERE REQ_ID ='TRRD00000251341'

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251320'

UPDATE PL_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251320'

UPDATE TR_REQUEST_DOC SET REQ_DT ='2020-10-09' WHERE REQ_CODE ='PUR/2020/000320'

UPDATE PL_REQUEST_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251597'

UPDATE PL_PROCESS SET APPROVE_DT ='2020-10-09' WHERE REQ_ID ='TRRD00000251597'

UPDATE TR_REQUEST_DOC SET REQ_DT ='2020-10-09' WHERE REQ_CODE ='PUR/2020/000597'