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

INSERT INTO [PL_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[REQ_REASON],[BRANCH_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PROCESS_ID],[DVDM_APP_ID],[REQ_PARENT_ID],[BRANCH_FEE],[EFFEC_DT],[IS_BACKDAY],[DEP_ID],[DEP_FEE],[BRANCH_CREATE],[DEP_CREATE],[REQ_LINE],[TC_NOTES],[SIGN_USER],[KT_NOTES],[IS_CHECKALL],[BASED_CONTENT],[IS_SETTLMENT],[PL_BASED_ID])VALUES(N'PLRDI001055410',N'000006/2020TTR-0690903',N'Cung cấp cho các đơn vị khi có nhu cầu',N'Apr  9 2020 12:00AM',NULL,N'Cung cấp cho các đơn vị khi có nhu cầu',N'Cung cấp cho các đơn vị khi có nhu cầu',N'DV0001',103950000,NULL,N'1',N'baotq',N'Apr  9 2020 12:00AM',N'A',NULL,N'Apr 13 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',N'Apr 13 2020 12:00AM',NULL,NULL,NULL,N'DV0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)

INSERT INTO [PL_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[REQ_REASON],[BRANCH_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PROCESS_ID],[DVDM_APP_ID],[REQ_PARENT_ID],[BRANCH_FEE],[EFFEC_DT],[IS_BACKDAY],[DEP_ID],[DEP_FEE],[BRANCH_CREATE],[DEP_CREATE],[REQ_LINE],[TC_NOTES],[SIGN_USER],[KT_NOTES],[IS_CHECKALL],[BASED_CONTENT],[IS_SETTLMENT],[PL_BASED_ID])VALUES(N'PLRDI001055411',NULL,N'Cung cấp cho các đơn vị khi có nhu cầu',N'Mar 11 2020 12:00AM',NULL,N'Cung cấp cho các đơn vị khi có nhu cầu',N'Cung cấp cho các đơn vị khi có nhu cầu',N'DV0001',148500000,NULL,N'1',N'baotq',N'Mar 11 2020 12:00AM',N'A',NULL,N'Apr 13 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',N'Apr 13 2020 12:00AM',NULL,NULL,NULL,N'DV0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)

INSERT INTO [PL_REQUEST_DOC_DT] ([REQDT_ID],[REQ_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[NAME],[DESCRIPTION],[REQDT_TYPE],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DVDM_ID],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[SUP_ID],[TRADE_TYPE],[KHOI_ID],[UNIT_NAME])VALUES(N'PLRDDI01055716',N'PLRDI001055410',NULL,NULL,NULL,NULL,N'Máy tính bàn HP Prodesk 400 G6 SFF +  Màn hình HP ProDisplay P174',N'I',N'CMU000000000046',7,14850000.00,103950000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000052',N'HH0000000112028',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'bộ')

INSERT INTO [PL_REQUEST_DOC_DT] ([REQDT_ID],[REQ_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[NAME],[DESCRIPTION],[REQDT_TYPE],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DVDM_ID],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[SUP_ID],[TRADE_TYPE],[KHOI_ID],[UNIT_NAME])VALUES(N'PLRDDI01055717',N'PLRDI001055411',NULL,NULL,NULL,NULL,N'Máy tính bàn HP Prodesk 400 G6 SFF +  Màn hình HP ProDisplay P174',N'I',N'CMU000000000046',10,14850000.00,148500000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000052',N'HH0000000112028',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'bộ')

INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_REASON],[REQ_CONTENT],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[PROCESS_ID],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI001055338',N'PUR/2020/00009553',NULL,N'Apr  9 2020 12:00AM',NULL,N'Cung cấp cho các đơn vị khi có nhu cầu',N'',N'PLRDI001055410',102756500,N'',N'1',N'baotq',N'Apr  9 2020 12:00AM',N'A',N'phuongtln1',N'Apr 13 2020 12:00AM',N'',N'APPROVE',N'',N'baotq',N'DV0001',N'tuyenlt',N'DMMS00000000001',N'',N'',N'')

INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_REASON],[REQ_CONTENT],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[PROCESS_ID],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDI001055339',N'PUR/2020/00009457',NULL,N'Mar 11 2020 12:00AM',NULL,N'Cung cấp cho các đơn vị khi có nhu cầu',N'',N'PLRDI001055411',146795000,N'',N'1',N'baotq',N'Mar 11 2020 12:00AM',N'A',N'phuongtln1',N'Apr 13 2020 12:00AM',N'',N'APPROVE',N'',N'baotq',N'DV0001',N'tuyenlt',N'DMMS00000000001',N'',N'',N'')

INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[TRAN_TYPE_ID],[DESCRIPTION],[QUANTITY],[PRICE],[PRICE_ETM],[TOTAL_AMT],[TOTAL_AMT_ETM],[AMOUNT_PAID],[INVOICENO],[REQ_DT],[AMORT_MONTH],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDI01055566',N'TRRDI001055338',N'PLRDDI01055716',NULL,N'CMS000001126240',NULL,N'Máy tính bàn HP Prodesk 400 G6 SFF +  Màn hình HP ProDisplay P174',7,14679500.00,14850000.00,102756500.00,103950000.00,NULL,N'',N'Apr  9 2020 12:00AM',NULL,N'',N'1',N'baotq',N'Apr  9 2020 12:00AM',N'A',N'phuongtln1',N'Apr 13 2020 12:00AM',N'HH0000000112028',N'VND',1.00,0.00,N'DM0000000000052',N'',NULL,N'',NULL,NULL)

INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[TRAN_TYPE_ID],[DESCRIPTION],[QUANTITY],[PRICE],[PRICE_ETM],[TOTAL_AMT],[TOTAL_AMT_ETM],[AMOUNT_PAID],[INVOICENO],[REQ_DT],[AMORT_MONTH],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDI01055567',N'TRRDI001055339',N'PLRDDI01055717',NULL,N'CMS000001126240',NULL,N'Máy tính bàn HP Prodesk 400 G6 SFF +  Màn hình HP ProDisplay P174',10,14679500.00,14850000.00,146795000.00,148500000.00,NULL,N'',N'Mar 11 2020 12:00AM',NULL,N'',N'1',N'baotq',N'Mar 11 2020 12:00AM',N'A',N'phuongtln1',N'Apr 13 2020 12:00AM',N'HH0000000112028',N'VND',1.00,0.00,N'DM0000000000052',N'',NULL,N'',NULL,NULL)

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'TRRDI001055338',N'DMMS',N'P',N'GDDV',N'',N'phuongtln1',N'Apr 13 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'TRRDI001055338',N'APPROVE',N'C',N'',N'',N'',N'Sep  9 2020  9:35AM',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'TRRDI001055339',N'DMMS',N'P',N'GDDV',N'',N'phuongtln1',N'Apr 13 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'TRRDI001055339',N'APPROVE',N'C',N'',N'',N'',N'Sep  9 2020  9:35AM',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'TRRDI001055338',N'1360',N'phuongtln1',N'TP',1,N'P',N'1',N'',N'Sep  9 2020  9:35AM')

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'TRRDI001055338',N'1360',N'tuyenlt',N'XL',2,N'P',N'1',N'',N'Sep  9 2020  9:35AM')

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'TRRDI001055339',N'1362',N'phuongtln1',N'TP',1,N'P',N'1',N'',N'Sep  9 2020  9:35AM')

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'TRRDI001055339',N'1362',N'tuyenlt',N'XL',2,N'P',N'1',N'',N'Sep  9 2020  9:35AM')

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 ('TRRDI001055338','TRRDI001055339')