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

Regex cho diễn giải hoạch toán: ^[!-%'-;=-~\s]{1,}$

INSERT INTO PL_ROLE_DATA_CONFIG VALUES ('TRADE_USER_ALL','ALL','DEP000000000004')

UPDATE TR_REQ_PAY_BUDGET SET GD_ID ='GOO000000254268', TRADE_ID ='PLT000000286038', AMT_APP =48235000, AMT_DO=0, AMT_EXE=48235000, AMT_REMAIN =0 WHERE REQ_PAY_ID
IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE='102022/000874')

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001776')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_PL_DT WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID

UPDATE TR_REQ_PAY_BUDGET SET GD_ID ='GOO000000254268', TRADE_ID ='PLT000000286038', AMT_APP =48235000, AMT_DO=0, AMT_EXE=48235000, AMT_REMAIN =48235000 WHERE REQ_PAY_ID
IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE='102022/000874')

EXEC sp_helptext N'[dbo].[CON_REQUEST_DOC_InsXml]'

INSERT INTO [BANK_OUTSIDE] ([BANK_OUTSIDE_ID],[BANK_OUTSIDE_CODE],[BANK_OUTSIDE_NAME],[BANKCODE],[BANKID],[CREATE_DT],[AUTH_STATUS],[BANKNAME],[BANKCODE_NAPAS],[BANKNAME_NAPAS],[SHORTNAME],[BIN_ID],[BANKFULLNAME])VALUES

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/001974')

UPDATE TR_REQ_PAYMENT SET AUTH_STATUS_KT ='' WHERE AUTH_STATUS <>'A' AND AUTH_STATUS_KT ='S'
UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS_KT ='' WHERE AUTH_STATUS <>'A' AND AUTH_STATUS_KT ='S'

UPDATE PL_REQUEST_DOC_DT SET PLAN_ID ='PLM000000260041', TRADE_ID ='PLT000000282290', GOODS_ID ='GOO000000253954' WHERE REQ_ID ='PLRD00000205563'

UPDATE CM_HANGHOA SET AUTH_STATUS ='A' WHERE AUTH_STATUS ='U'

http://172.29.5.43:8011//VCCB_ASSET/ProxyServices/AssetProxy?wsdl
http://osb.vietcapitalbank.com.vn/VCCB_ASSET/ProxyServices/AssetProxy?wsdl

UPDATE TR_REQUEST_DOC SET AUTH_STATUS ='A', PROCESS_ID ='', CHECKER_ID ='' WHERE REQ_CODE ='PUR/2022/002365'

UPDATE TR_REQUEST_DOC SET AUTH_STATUS ='E', PROCESS_ID ='', CHECKER_ID ='' WHERE REQ_CODE ='PUR/2022/002365'

EXEC dbo.sp_generate_inserts @table_name = 'TL_SYS_ROLE_MAPPING', -- varchar(776)
@from = "FROM TL_SYS_ROLE_MAPPING WHERE TLNAME='namdt'" -- varchar(800)