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

SELECT * FROM CM_GOODS WHERE GD_CODE ='GA.I.N.OE.0026'
SELECT * FROM CM_GOODS WHERE GD_CODE ='GA.I.N.OE.0032'

SELECT * FROM CM_BRANCH WHERE BRANCH_CODE ='054'

SELECT * FROM PL_MASTER WHERE BRANCH_ID ='BRN000000000827'

SELECT * FROM

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF='2500000' WHERE TRADE_ID='PLT000000074189'
UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF='2500000' WHERE TRADE_ID='PLT000000074192'

UPDATE dbo.PL_TRADEDETAIL SET AMT_TF='6000000' WHERE TRADE_ID='PLT000000077002'
UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF='6000000' WHERE TRADE_ID='PLT000000077007'

SELECT * FROM dbo.PL_MASTER WHERE PLAN_TYPE_ID='PLTYPE000000040'

SELECT PL_REQDT_ID FROM dbo.TR_REQUEST_DOC_DT

SELECT * FROM dbo.CM_GOODS WHERE GD_CODE='DG.I.N.OE.0003'

SELECT * FROM dbo.PL_TRADEDETAIL WHERE GOODS_ID='GOO000001062725'

SELECT * FROM dbo.PL_MASTER WHERE PLAN_ID='PLM000000016935'

SELECT * FROM dbo.CM_DVDM WHERE DVDM_ID='DM0000000000034'

SELECT * FROM dbo.TR_REQUEST_DOC WHERE REQ_CODE IN

(
'PUR/2019/00008989 ',
'PUR/2019/00008857 ',
'PUR/2019/00008939 ',
'PUR/2019/00008164 ',
'PUR/2019/00008610 ',
'PUR/2019/00009130 ',
'PUR/2019/00009239 ',
'PUR/2020/00009297 ',
'PUR/2020/00009356 ',
'PUR/2020/00009357 ',
'PUR/2020/00009358 ',
'PUR/2020/00009359 ',
'PUR/2020/00009360 ',
'PUR/2020/00009361 ',
'PUR/2020/00009362 ',
'PUR/2020/00009448 ',
'PUR/2020/00009341 ',
'PUR/2020/00009343 ',
'PUR/2020/00009649 ',
'PUR/2020/00009347 ',
'PUR/2020/00009350 ',
'PUR/2020/00009645 ',
'PUR/2020/00009647 ',
'PUR/2020/00009590 ',
'PUR/2020/00009589 ',
'PUR/2020/00009325 ',
'PUR/2020/00009426 ',
'PUR/2020/00009644 ',
'PUR/2020/00009736 ',
'PUR/2020/00009507 ',
'PUR/2020/00009720 ',
'PUR/2020/00009765 ',
'PUR/2020/00009705 ')

UPDATE dbo.CM_ALLCODE SET CDVAL = 'CT' WHERE CDNAME = 'PROJECT_STATUS' AND CONTENT = N'Đang chào thầu'

UPDATE dbo.TR_REQUEST_DOC_DT SET PRICE_ETM=(SELECT PRICE FROM dbo.PL_REQUEST_DOC_DT WHERE REQDT_ID=PL_REQDT_ID)
UPDATE dbo.TR_REQUEST_DOC_DT SET TOTAL_AMT_ETM=(SELECT TOTAL_AMT FROM dbo.PL_REQUEST_DOC_DT WHERE REQDT_ID=PL_REQDT_ID)

UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET PROCESS_ID=(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND PROCESS_ID='DMMS')
WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID IN ()

UPDATE dbo.TR_REQUEST_DOC_DT SET DESCRIPTION=(SELECT DESCRIPTION FROM dbo.PL_REQUEST_DOC_DT WHERE PL_REQUEST_DOC_DT.REQDT_ID=TR_REQUEST_DOC_DT.PL_REQDT_ID)

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQUEST_DOC', -- varchar(776)

@from = 'FROM TR_REQUEST_DOC'                 -- varchar(800)

SELECT * FROM dbo.TR_CONTRACT WHERE CONTRACT_CODE IN

('260.2020/HÐKT/BK6',
'06/SRV/VCCB-MICROTEC/010420',
'06042020/HÐKT/VCCB-MKG',
'UNIT/BVB-20200608.1',
'UNIT/BVB-20200601.1',
'2020.250/HÐKT/BK6',
'2020.259/HÐKT/BK6',
'20/CSG/FSI/07/0044',
'000516/2020/HO/FSI3',
'010720A.GCP/HDKT',
'2019.524/HDKT/BK6',
'#CL-13/09/19-VIETCAPITAL-UX.UI',
'01/BVB-MCS/Napas/112019',
'05/SRV/VCCB-MICROTEC/010319',
'11102019/HÐKT/CLICK-NHBV',
'432020/HDKT/SV-VCCB',
'20/CSG/FSI/05/0038',
'20/CSG/FSI/05/0032',
'20/CSG/FSI/05/004',
'20/CSG/FSI/05/0029',
'2020.135/HÐKT/BK6',
'20/CSG/FSI/05/0006',
'20/CSG/FSI/05/0007',
'178.2020/HÐKT/BK6',
'GMC20060B0',
'2020.115/HÐKT/BK6')

062020/089373

UPDATE dbo.TR_REQ_PAY_SCHEDULE SET AMT_PAY='179520000.00',AMT_PAY_DO='179520000.00',AMT_ADVANCE=0,AMT_REMAIN=0,PAY_ID='TRCPI0001127112',PAY_PHASE=2 WHERE SCHEDULE_ID='TRPSCI001105566'

UPDATE dbo.TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS_KT='A',CHECKER_ID_KT='admin',MAKER_ID_KT='admin',APPROVE_DT_KT=CREATE_DT,CREATE_DT_KT=CREATE_DT WHERE REQ_PAY_ID='TADYI0001119527'

UPDATE dbo.TR_REQUEST_DOC_DT SET TRAN_TYPE_ID='TRN0000000004' WHERE REQ_DOC_ID IN (SELECT REQ_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_CODE IN
('PUR/2019/00008989',
'PUR/2019/00008857',
'PUR/2020/00009297',
'PUR/2020/00009356',
'PUR/2020/00009357',
'PUR/2020/00009358',
'PUR/2020/00009359',
'PUR/2020/00009360',
'PUR/2020/00009361',
'PUR/2020/00009362',
'PUR/2020/00009325',
'PUR/2020/00009507',
'PUR/2020/00009785')
)

SELECT * FROM dbo.TR_CONTRACT WHERE CONTRACT_CODE IN ('003/HĐQC-CAO',
'43/HĐHT/2020',
'43/HĐHT/2020',
'021_0320/VST_PR',
'021_0320/VST_PR',
'2019.429/HĐKT/BK6',
'2019.429/HĐKT/BK6',
'2019.429/HĐKT/BK6',
'2019.429/HĐKT/BK6',
'163.2020/HĐKT/BK6',
'163.2020/HĐKT/BK6',
'163.2020/HĐKT/BK6',
'163.2020/HĐKT/BK6',
'41/2020',
'41/2020',
'41/2020',
'12/20/HD-1076/22-TKT',
'30776/20/HD-1131/22-TKT',
'39-19/HĐKT-GSOFT-VCCB',
'39-19/HĐKT-GSOFT-VCCB',
'39-19/HĐKT-GSOFT-VCCB')

NULL
2204/2019/NHBV-NP
NULL
21-10/2019/BVB-ASIA
1811/2019/BVB-HÐ
1210/2019/VCCB-H?i Âu
1605/2019/NHBV-TBC
1002/2020/BVB-ALPEC
1004/2020/BVB-TL
1003/2020/NHBV-TL
1210-1/2019/VCCB-Hoàng Phi
2005/2020/BVB-ASIA
1603/2020/BVB-HÐ
1603/2020/BVB-HÐ
1004/2020/BVB-TL
1206/2020/BVB-ASIA
1206/2020/BVB-NP
0207/2020/BVB-HÐ
0307/2020/BVB-PS
0607/2020/BVB-PS
0801/2018/NHBV-KHANGGIA
1003/2018/NHBV-KHANGGIA
0606/2018/NHBV-KHANGGIA
2206/2018/NHBV-ASIA
1207/2018/NHBV-HÐ
2008/2018/NHBV-VT
1709-2/2018/NHBV-TD
2510/2018/NHBV-HÐ
2311/2018/NHBV-ASIA
0701/2019/NHBV-ASIA
0607/2018/NHBV-VT và PL 0607-1/2018/NHBV-VT
0512/2018/NHBV-ASIA
2102/2019/NHBV-ASIA
2102-1/2019/NHBV-ASIA
1502/NHBV/HÐTK-XD
0504/HÐTK/NHBV-XD
NULL

('PUR/2018/00006191',
'PUR/2018/00006368',
'PUR/2018/00006685',
'PUR/2018/00006781',
'PUR/2018/00006947',
'PUR/2018/00007151',
'PUR/2018/00007434',
'PUR/2018/00007494',
'PUR/2018/00007721',
'PUR/2018/00007761',
'PUR/2018/00007781',
'PUR/2018/00007788',
'PUR/2019/00008127',
'PUR/2019/00008134',
'PUR/2019/00008274',
'PUR/2019/00008448',
'PUR/2019/00008526',
'PUR/2019/00008532',
'PUR/2019/00008746',
'PUR/2019/00009061',
'PUR/2019/00009135',
'PUR/2019/00009610',
'PUR/2019/00009231',
'PUR/2019/00009232',
'PUR/2019/00009233',
'PUR/2020/00009035',
'PUR/2020/00009301',
'PUR/2020/00009515',
'PUR/2020/00009516',
'PUR/2020/00009632',
'PUR/2020/00009481',
'PUR/2020/00009386',
'PUR/2020/00009499',
'PUR/2020/00009514',
'PUR/2020/00009664',
'PUR/2020/00009688',
'PUR/2020/00009660',
'PUR/2020/00009687',
'PUR/2020/00009691',
'PUR/2020/00009734',
'PUR/2020/00009733',
'PUR/2020/00009775',
'PUR/2020/00009776',
'PUR/2020/00009414')

('2204/2019/NHBV-NP',
'21-10/2019/BVB-ASIA',
'1811/2019/BVB-HÐ',
'1210/2019/VCCB-H?i Âu',
'1605/2019/NHBV-TBC',
'1002/2020/BVB-ALPEC',
'1004/2020/BVB-TL',
'1003/2020/NHBV-TL',
'1210-1/2019/VCCB-Hoàng Phi',
'2005/2020/BVB-ASIA',
'1603/2020/BVB-HÐ',
'1603/2020/BVB-HÐ',
'1004/2020/BVB-TL',
'1206/2020/BVB-ASIA',
'1206/2020/BVB-NP',
'0207/2020/BVB-HÐ',
'0307/2020/BVB-PS',
'0607/2020/BVB-PS',
'0801/2018/NHBV-KHANGGIA',
'1003/2018/NHBV-KHANGGIA',
'0606/2018/NHBV-KHANGGIA',
'2206/2018/NHBV-ASIA',
'1207/2018/NHBV-HÐ',
'2008/2018/NHBV-VT',
'1709-2/2018/NHBV-TD',
'2510/2018/NHBV-HÐ',
'2311/2018/NHBV-ASIA',
'0701/2019/NHBV-ASIA',
'0607/2018/NHBV-VT và PL 0607-1/2018/NHBV-VT',
'0512/2018/NHBV-ASIA',
'2102/2019/NHBV-ASIA',
'2102-1/2019/NHBV-ASIA',
'1502/NHBV/HÐTK-XD',
'0504/HÐTK/NHBV-XD')

('169/2017/TTr-P.HC',
'12/2018/TTr-P.HC',
'03/2018/TTr-PTML',
'624C/2018/TTr-PTML',
'40C/2018/TTr-PTML',
'40D/2018/TTr-PTML',
'68B/2018/TT-P.HC-XDCB',
'72A/2018/TT-P.HC-XDCB',
'1147A/2018/TT-P.HC-XDCB',
'80/2018/TT-P.HC.BP.XDCB',
'68/2018/TTr-P.HC',
'1620B/2018/TT-P.HC.BP.XDCB',
'07A/2019/TT-P.HC.XDCB',
'07A/2019/TT-P.HC.XDCB',
'1491D/2018/TTR-P.HC.XDCB',
'13/2019/TT-P.HC.XDCB',
'05A/2019/TT-P.HC.XDCB',
'21A/2019/TTr-P.HC.XDCB',
'12BA/2019/TT-P.HC.XDCB',
'54B/2019/TT-P.HC.XDCB',
'56A/2019/TTr-P.HC.XDCB',
'56A/2019/TTr-P.HC.XDCB',
'60AB/2019/TTr-P.HC.XDCB',
'59AA/2019/TTr-P.HC.XDCB',
'60AA/2019/TTr-P.HC.XDCB',
'"2319A/2019/TT-P.HC.XDCB',
' và 84/19/QĐ-HĐQT"',
'54B/2019/TT-P.HC.XDCB',
'01A/2020/TT-P.HC.XDCB',
'01A/2020/TT-P.HC.XDCB',
'12/2020/TT-P.HC.XDCB',
'"2319A/2019/TT-P.HC.XDCB',
'và 84/19/QĐ-HĐQT"',
'55B/2019/TT-P.HC.XDCB',
'"2319A/2019/TT-P.HC.XDCB',
'và 84/19/QĐ-HĐQT"',
'07A/2020/TTr-P.HC.XDCB',
'000007/2020TTR-069504',
'16B/2020/TT-P.HC.XDCB',
'12A/2020/TT-P.HC.XDCB',
'18B/2020/TTr-P.HC.XDCB',
'16B/2020/TTr-P.HC.XDCB',
'18AA/2020/TTr-P.HC.XDCB',
'18AA/2020/TTr-P.HC.XDCB',
'18AB/2020/TTr-P.HC.XDCB',
'18AB/2020/TTr-P.HC.XDCB',
'06/2020/TTr-P.HC')

SELECT * FROM dbo.PL_MASTER WHERE PLAN_TYPE_ID='PLTYPE000000050' AND DEPT_ID='DEP000000000001'

EXEC dbo.sp_generate_inserts @table_name = 'PL_TRADEDETAIL', -- varchar(776)

@from = 'FROM PL_TRADEDETAIL WHERE  TRADE_ID <=''PLT000000074842'''                  -- varchar(800)

UPDATE dbo.PL_TRADEDETAIL SET AMT_EXE=0 WHERE TRADE_ID='PLT000000070411'

SELECT * FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE IN

('77/2018/TTr-P.TH&QHCC',
'84/2019/TTr-P.TH&QHCC',
'35/2019/TTr-P.TH&QHCC',
'07/2020/TTr-P.TH&QHCC',
'06/2020/TTr-P.TH&QHCC',
'10/2020/TTr-P.TH&QHCC',
'35/2020/TTr-P.SP&MKT',
'16/2020/TTr-P.TH&QHCC',
'15/2020/TTr-P.TH&QHCC',
'15/2020/TTr-TTT',
'000002/2020TTR-0692302',
'86/2020/TTr-P.TH&QHCC',
'05/2020/TTr-NHDT',
'53/2020/TTr-TT QL&THN',
'65A/2020/TTr-P.SP&MKT',
'21/2020/TTr-P.TH&QHCC',
'101/2020/TTr-P.SP&MKT',
'025/2020/TTr-TTT',
'23/2020/TTr-P.TH&QHCC',
'139/2020/TTr-P.SP&MKT',
'62/2020/TTr-KHDN',
'113/2020/TTr-P.SP&MKT',
'26/2020/TTr-P.TH&QHCC',
'123/2019/TTr-TTT',
'12/2020/TTr-P.TH&QHCC',
'025/2020/TTr-TTT 102/2020/TTr-P.SP&MKT 046A/2020/TTr-TTT ',
'31/2019/TTr-KHDN',
'09/2020/TTr-NHĐT',
'18AA/2020/TTr-P.HC.XDCB',
'23A/2020/TTr-P.HC',
'36/2020/TTr-P.TH&QHCC',
'19/2020/TTr-QLDVKH',
'96/2020/TTr-TTT 94/2020/TTr-TTT')

SELECT * FROM dbo.TR_REQUEST_DOC WHERE REQ_CODE IN

('PUR/2018/00007375',
'PUR/2019/00009104',
'PUR/2019/00008573',
'PUR/2020/00009352',
'PUR/2020/00009376',
'PUR/2020/00009393',
'PUR/2020/00009437',
'PUR/2020/00009467',
'PUR/2020/00009468',
'PUR/2020/00009489',
'PUR/2020/00009550',
'PUR/2020/00009562',
'PUR/2020/00009569',
'PUR/2020/00009577',
'PUR/2020/00009591',
'PUR/2020/00009594',
'PUR/2020/00009611',
'PUR/2020/00009623',
'PUR/2020/00009674',
'PUR/2020/00009696',
'PUR/2020/00009698',
'PUR/2020/00009575',
'PUR/2020/00009694',
'PUR/2020/00009693',
'PUR/2020/00009662',
'PUR/2020/00009586',
'PUR/2020/00009588',
'PUR/2020/00009621',
'PUR/2020/00009700',
'PUR/2020/00009702',
'PUR/2020/00009703',
'PUR/2020/00009746',
'PUR/2020/00009704',
'PUR/2020/00009718',
'PUR/2020/00009732',
'PUR/2020/00009755',
'PUR/2020/00009759',
'PUR/2020/00009787',
'PUR/2020/00009801',
'PUR/2020/00009805',
'PUR/2020/00009810',
'PUR/2020/00009809')

SELECT * FROM dbo.TR_CONTRACT WHERE CONTRACT_CODE IN
('44/HDDV-SVICC-BanViet ',
'23/2018/HD/IB.VCSC ',
'14/2018/HD-IB.VCSC',
'17/HÐQC-2019',
'05/HÐQC-VBF-VIETCAPITALBANK',
'02122019/VCCB-NICHE/PR',
' 02/VIETCAPITAL-SN/02/2020',
'026/HÐQC/ME-BANVIET',
'15052020/HDMB/BV-ACE',
'28022020/HDHT/UREKA - BAN VIET',
'27022019/HDHT/UREKA - BAN VIET',
'B2B/2019/ DAYONE - BVB',
'120/HÐDV-DoanhNghiep-BanViet',
'42/HDKT/2020',
'15-2019/HÐNT-LIENSON-VCCB',
'68/2020/SSV-BV/HÐHT')

UPDATE dbo.TR_REQUEST_DOC SET TOTAL_AMT=(SELECT SUM FROM dbo.TR_REQUEST_DOC_DT WHERE REQ_DOC_ID=REQ_ID) WHERE REQ_ID IN

('TRRDI0001056100',
'TRRDI0001056101',
'TRRDI0001056102',
'TRRDI0001056103',
'TRRDI0001056104',
'TRRDI0001056105',
'TRRDI0001056106',
'TRRDI0001056107',
'TRRDI0001056108',
'TRRDI0001056109')

UPDATE dbo.TR_REQUEST_DOC_DT SET TOTAL_AMT_ETM=PRICE*QUANTITY WHERE REQ_DOC_ID IN ('TRRDI0001056100',
'TRRDI0001056101',
'TRRDI0001056102',
'TRRDI0001056103',
'TRRDI0001056104',
'TRRDI0001056105',
'TRRDI0001056106',
'TRRDI0001056107',
'TRRDI0001056108',
'TRRDI0001056109')

UPDATE dbo.PL_REQUEST_DOC_DT SET SUP_ID='' WHERE REQ_ID IN
('PLRDI0001056012',
'PLRDI0001056013',
'PLRDI0001056014',
'PLRDI0001056015',
'PLRDI0001056016',
'PLRDI0001056017',
'PLRDI0001056018',
'PLRDI0001056017',
'PLRDI0001056019',
'PLRDI0001056019')

EXEC dbo.FN_CHECK_LIMIT_PL_REQ @REQ_ID = '', -- varchar(20)
@p_role = '' -- varchar(20)

INSERT INTO dbo.PL_ROLE_DATA_CONFIG
(
ROLE_TYPE,
BRANCH_ID,
DEP_ID
)
VALUES
( 'HANHCHINH', -- ROLE_TYPE - varchar(100)
'DV0001', -- BRANCH_ID - varchar(100)
'DEP000000000033' -- DEP_ID - varchar(100)
)

INSERT INTO dbo.PL_REQUEST_PROCESS
(
REQ_ID,
PROCESS_ID,
STATUS,
ROLE_USER,
BRANCH_ID,
CHECKER_ID,
APPROVE_DT,
PARENT_PROCESS_ID,
IS_LEAF,
COST_ID,
DVDM_ID,
NOTES,
IS_HAS_CHILD,
DEP_ID
)
VALUES
( '', -- REQ_ID - varchar(15)
'GDK_TT', -- PROCESS_ID - varchar(10)
'C', -- STATUS - varchar(5)
'GDK', -- ROLE_USER - varchar(50)
'', -- BRANCH_ID - varchar(15)
'', -- CHECKER_ID - varchar(15)
NULL, -- APPROVE_DT - datetime
'KT', -- PARENT_PROCESS_ID - varchar(10)
'', -- IS_LEAF - varchar(1)
'', -- COST_ID - varchar(15)
'DM0000000000015', -- DVDM_ID - varchar(15)
N'', -- NOTES - nvarchar(500)
NULL, -- IS_HAS_CHILD - bit
'' -- DEP_ID - varchar(20)
)

SELECT * FROM dbo.CM_DVDM WHERE IS_KHOI=1

PLT000000072280

SELECT * FROM dbo.TR_CONTRACT
WHERE CONTRACT_CODE IN (

'44/HDDV-SVICC-BanViet',
'23/2018/HD/IB.VCSC',
'14/2018/HD-IB.VCSC',
'17/HĐQC-2019',
'05/HĐQC-VBF-VIETCAPITALBANK',
'02122019/VCCB-NICHE/PR',
' 02/VIETCAPITAL-SN/02/2020',
'026/HĐQC/ME-BANVIET',
'15052020/HDMB/BV-ACE',
'28022020/HDHT/UREKA - BAN VIET',
'27022019/HDHT/UREKA - BAN VIET',
'B2B/2019/ DAYONE - BVB',
'120/HĐDV-DoanhNghiep-BanViet',
'42/HDKT/2020',
'15-2019/HĐNT-LIENSON-VCCB',
'68/2020/SSV-BV/HĐHT')