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

DECLARE @AMORT_ID VARCHAR(15)

SET @AMORT_ID =(SELECT TOP 1 AMORT_ID FROM ASS_AMORT WHERE AMORT_TERM ='12/2020')

SELECT COUNT(*) AS SO_LUONG_TS, SUM(AMT) AS GT_KHAU_HAO FROM ASS_ENTRIES_POST WHERE TRN_ID =@AMORT_ID

SELECT * FROM ASS_AMORT WHERE AMORT_ID =@AMORT_ID

SELECT COUNT(*) AS SO_LUONG_TS, SUM(AMORT_AMT) AS GT_HACH_TOAN FROM ASS_AMORT_DT WHERE AMORT_ID =@AMORT_ID

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E' WHERE REQ_CODE ='PUR/2020/000463'

UPDATE TR_REQUEST_DOC SET PROCESS_ID ='', AUTH_STATUS ='E' WHERE REQ_CODE ='PUR/2020/000572'

DECLARE @REQ_ID VARCHAR(15), @BRANCH_CREATE VARCHAR(15)

SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000630')

SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000630')

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

-- CAP NHAT HOAN TAT CHU TRUONG

UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE', AUTH_STATUS ='A', REQ_CODE ='911/2020/TTr-P.TT&TH', REQ_DT ='2020-11-13', EFFEC_DT = '2020-11-13' WHERE REQ_CODE ='0055/2020/TTr-0690405'

SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000984')

SET @BRANCH_CREATE =(SELECT TOP 1 BRANCH_CREATE FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000984')

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