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

INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI001055367',N'PUR/2020/00009771',NULL,N'Aug  4 2020 12:00AM',NULL,N'',N'APPROVE',NULL,1438708,N'',N'1',N'hoangha',N'Aug  4 2020 12:00AM',N'A',N'chittn',N'Aug  5 2020 12:00AM',N'',N'Bảo dưỡng 31.000km xe ô tô 43A-371.52',N'',N'hoangha',N'DV0001',N'linhttt1',N'DMMS00000000001',N'',N'',N'')

INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI001055368',N'PUR/2020/00009769',NULL,N'Aug  4 2020 12:00AM',NULL,N'',N'APPROVE',NULL,4946480,N'',N'1',N'hoangha',N'Aug  4 2020 12:00AM',N'A',N'chittn',N'Aug  5 2020 12:00AM',N'',N'Bảo dưỡng 15.000km xe ô tô Volkswagens 51G-712.56',N'',N'hoangha',N'DV0001',N'linhttt1',N'DMMS00000000001',N'',N'',N'')

INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI001055369',N'PUR/2020/00009751',NULL,N'Jul 23 2020 12:00AM',NULL,N'',N'APPROVE',NULL,2209900,N'',N'1',N'hoangha',N'Jul 23 2020 12:00AM',N'A',N'chittn',N'Jul 27 2020 12:00AM',N'',N'Bảo dưỡng 10.000km xe ô tô 51H-133.53',N'',N'hoangha',N'DV0001',N'linhttt1',N'DMMS00000000001',N'',N'',N'')

INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI001055370',N'PUR/2020/00009749',NULL,N'Jul 23 2020 12:00AM',NULL,N'',N'APPROVE',NULL,7859115,N'',N'1',N'hoangha',N'Jul 23 2020 12:00AM',N'A',N'chittn',N'Jul 28 2020 12:00AM',N'',N'Bảo dưỡng 173.127km xe ô tô 51A-969.12',N'',N'hoangha',N'DV0001',N'linhttt1',N'DMMS00000000001',N'',N'',N'')

INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDI01055625',N'TRRDI001055367',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,N'',N'',N'1',N'hoangha',N'Aug  4 2020 12:00AM',N'A',N'chittn',N'Aug  5 2020 12:00AM',1438708.00,1438708.00,N'Aug  4 2020 12:00AM',NULL,NULL,NULL,1.00,0.00,NULL,N'',NULL,N'',NULL,NULL)

INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDI01055626',N'TRRDI001055368',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,N'',N'',N'1',N'hoangha',N'Aug  4 2020 12:00AM',N'A',N'chittn',N'Aug  5 2020 12:00AM',4946480.00,4946480.00,N'Aug  4 2020 12:00AM',NULL,NULL,NULL,1.00,0.00,NULL,N'',NULL,N'',NULL,NULL)

INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDI01055627',N'TRRDI001055369',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,N'',N'',N'1',N'hoangha',N'Jul 23 2020 12:00AM',N'A',N'chittn',N'Jul 27 2020 12:00AM',2209900.00,2209900.00,N'Jul 23 2020 12:00AM',NULL,NULL,NULL,1.00,0.00,NULL,N'',NULL,N'',NULL,NULL)

INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDI01055628',N'TRRDI001055370',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,N'',N'',N'1',N'hoangha',N'Jul 23 2020 12:00AM',N'A',N'chittn',N'Jul 28 2020 12:00AM',7859115.00,7859115.00,N'Jul 23 2020 12:00AM',NULL,NULL,NULL,1.00,0.00,NULL,N'',NULL,N'',NULL,NULL)

INSERT INTO [TR_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'TRCCI001055631',NULL,N'TRRDI001055367',NULL,N'A',N'hoangha',N'Aug  4 2020 12:00AM',N'chittn',N'Aug  5 2020 12:00AM')

INSERT INTO [TR_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'TRCCI001055632',NULL,N'TRRDI001055368',NULL,N'A',N'hoangha',N'Aug  4 2020 12:00AM',N'chittn',N'Aug  5 2020 12:00AM')

INSERT INTO [TR_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'TRCCI001055633',NULL,N'TRRDI001055369',NULL,N'A',N'hoangha',N'Jul 23 2020 12:00AM',N'chittn',N'Jul 27 2020 12:00AM')

INSERT INTO [TR_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT])VALUES(N'TRCCI001055634',NULL,N'TRRDI001055370',NULL,N'A',N'hoangha',N'Jul 23 2020 12:00AM',N'chittn',N'Jul 28 2020 12:00AM')

INSERT INTO [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(N'TRRDI001055367',N'DMMS',N'P',N'GDDV',N'',N'chittn',N'Aug  5 2020 12:00AM',N'',N'',N'',N'',N'',1,N'')

INSERT INTO [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(N'TRRDI001055367',N'APPROVE',N'C',N'',N'',N'',N'Oct  6 2020  8:25AM',N'DMMS',N'',N'',N'',N'',NULL,N'')

INSERT INTO [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(N'TRRDI001055368',N'DMMS',N'P',N'GDDV',N'',N'chittn',N'Aug  5 2020 12:00AM',N'',N'',N'',N'',N'',1,N'')

INSERT INTO [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(N'TRRDI001055368',N'APPROVE',N'C',N'',N'',N'',N'Oct  6 2020  8:25AM',N'DMMS',N'',N'',N'',N'',NULL,N'')

INSERT INTO [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(N'TRRDI001055369',N'DMMS',N'P',N'GDDV',N'',N'chittn',N'Jul 27 2020 12:00AM',N'',N'',N'',N'',N'',1,N'')

INSERT INTO [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(N'TRRDI001055369',N'APPROVE',N'C',N'',N'',N'',N'Oct  6 2020  8:25AM',N'DMMS',N'',N'',N'',N'',NULL,N'')

INSERT INTO [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(N'TRRDI001055370',N'DMMS',N'P',N'GDDV',N'',N'chittn',N'Jul 28 2020 12:00AM',N'',N'',N'',N'',N'',1,N'')

INSERT INTO [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(N'TRRDI001055370',N'APPROVE',N'C',N'',N'',N'',N'Oct  6 2020  8:25AM',N'DMMS',N'',N'',N'',N'',NULL,N'')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055367',N'2875',N'chittn',N'TP',1,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055367',N'2875',N'linhttt1',N'XL',2,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055368',N'2877',N'chittn',N'TP',1,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055368',N'2877',N'linhttt1',N'XL',2,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055369',N'2879',N'chittn',N'TP',1,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055369',N'2879',N'linhttt1',N'XL',2,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055370',N'2881',N'chittn',N'TP',1,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI001055370',N'2881',N'linhttt1',N'XL',2,N'P',N'1',N'',N'Oct  6 2020  8:25AM')

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 (

'TRRDI001055367',

'TRRDI001055367',

'TRRDI001055368',

'TRRDI001055368',

'TRRDI001055369',

'TRRDI001055369',

'TRRDI001055370',

'TRRDI001055370'

)