1.0. UPDATE DATA PYCMS PHUONGVN.txt - DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3 - Redmine

Download (379 Bytes)

1.0. UPDATE DATA PYCMS PHUONGVN.txt

Luc Tran Van, 02/20/2023 10:29 PM

1

UPDATE  TR_REQUEST_DOC_DT SET PRICE =28588389, TOTAL_AMT=28588389 WHERE REQ_DOC_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE='PUR/2023/000116') AND PRICE =28588388

2

UPDATE TR_REQUEST_DOC SET TOTAL_AMT= TOTAL_AMT +1 WHERE REQ_CODE='PUR/2023/000116'

3

UPDATE TR_REQUEST_DOC SET PROCESS_ID='', AUTH_STATUS='E', APPROVE_DT=NULL, CHECKER_ID='' WHERE REQ_CODE='PUR/2023/000176'