DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

0069/2023/TTr-0690405
0007/2023/TTDC-0960005

SELECT * FROM PL_REQUEST_DOC_DT WHERE TRADE_ID ='PLT000000309253'
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC_DT WHERE TRADE_ID ='PLT000000309253') ---29052023_secretkey

SELECT * FROM PL_REQUEST_TRANSFER WHERE FR_TRADE_ID ='PLT000000309253'
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_DOC_ID FROM PL_REQUEST_TRANSFER WHERE FR_TRADE_ID ='PLT000000309253') ---29052023_secretkey

UPDATE PL_REQUEST_TRANSFER SET FR_AMT_TF =0,FR_AMT_FINAL =1500000 WHERE REQ_TRANSFER_ID='PLRT00000218840' ---29052023_secretkey

urlrequest: https://gatecom.vietcapitalbank.com.vn/ms-gateway-gsoft/bill/list-transaction

{"customerNo":"00000069","billCode":"PD12000056572","prvCode":"PRV013","sevCode":"SEV007","fromDate":"5/22/2023 11:06:34 AM"}