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'PLRDI0001055402',N'12A/2020/TTr-KCNTT-Hatang',N'Đầu tư nâng cấp CPU hệ thống máy chủ hệ thống CoreBank',N'Aug 12 2020 12:00AM',1,N'Đầu tư nâng cấp CPU hệ thống máy chủ hệ thống CoreBank',N'Đầu tư nâng cấp CPU hệ thống máy chủ hệ thống CoreBank',N'DV0001',1880000000,NULL,N'1',N'loctq',N'Aug 12 2020 12:00AM',N'A',N'trungnq1',N'Aug 18 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',N'Aug 18 2020 12:00AM',NULL,N'DEP000000000025',N'DEP000000000025',N'DV0001',N'DEP000000000025',NULL,NULL,NULL,N'Đồng ý',0,N'Căn cứ Quyết định 149/2020/QĐ-HC ngày 21/5/2020 về việc Ban hành Quy định mua sắm hàng hóa dịch vụ; Căn cứ nhu cầu mua sắm thực tế',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'PLRDDI001055677',N'PLRDI0001055402',N'PLM000000016817',N'PLT000000070368',N'GOO000001063771',N'',N'Active 6 cores for IBM Power System E850 - Serial 686992X',N'O',N'CMU000000000047',1,940000000.00,940000000.00,N'1',N'loctq',N'Aug 23 2020 12:00AM',N'U',N'khoapa',N'Aug 23 2020 11:16PM',N'DM0000000000049',N'HH0000000112072',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'PLRDDI001055678',N'PLRDI0001055402',N'PLM000000016817',N'PLT000000070368',N'GOO000001063771',N'',N'Active 6 cores for IBM Power System E850 - Serial 686994X',N'O',N'CMU000000000047',1,940000000.00,940000000.00,N'1',N'loctq',N'Aug 23 2020 12:00AM',N'U',N'khoapa',N'Aug 23 2020 11:16PM',N'DM0000000000049',N'HH0000000112072',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'Bộ')

INSERT INTO [PL_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[DVMD_ID],[TOTAL_AMT_GD])VALUES(N'PLRCI0001055620',N'DM0000000000049',N'PLRDI0001055402',N'Đồng ý',N'A',N'loctq',N'Aug 23 2020 12:00AM',NULL,NULL,NULL,NULL)

INSERT INTO [PL_REQUEST_TRANSFER] ([REQ_TRANSFER_ID],[REQ_DOC_ID],[FR_PLAN_ID],[FR_TRADE_ID],[FR_GOOD_ID],[FR_BRN_ID],[TO_BRN_ID],[TO_PLAN_ID],[TO_TRADE_ID],[TO_GOOD_ID],[QTY],[TOTAL_AMT],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[TO_DVDM_ID],[FR_DEP_ID],[TO_DEP_ID],[TO_KHOI_ID],[FR_DVDM_ID],[FR_KHOI_ID])VALUES(N'PLRTI0001055294',N'PLRDI0001055402',N'PLM000000016817',N'PLT000000070444',N'GOO000001063663',N'DV0001',N'DV0001',N'PLM000000016817',N'PLT000000070368',N'GOO000001063771',0,1880000000.00,N'',N'U',N'loctq',N'Aug 23 2020 12:00AM',NULL,NULL,N'DM0000000000049',N'DEP000000000024',N'DEP000000000025',N'DM0000000000018',N'DM0000000000049',N'DM0000000000018')

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'PLRDI0001055402',N'APPNEW',N'P',N'GDDV',N'DV0001',N'khoapa',N'Aug 23 2020 11:16PM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000025')

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'PLRDI0001055402',N'KT',N'P',N'KSV',N'',N'huongvt',N'Aug 23 2020 11:17PM',N'APPNEW',N'N',N'',N'DM0000000000006',N'Phòng kế toán đã phê duyệt',1,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'PLRDI0001055402',N'DVDC',N'P',N'GDDV',N'DV0001',N'',NULL,N'KT',N'N',N'',N'',N'Chờ đơn vị điều chuyển xác nhận',1,N'DEP000000000024')

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'PLRDI0001055402',N'TC',N'P',N'TC',N'',N'',NULL,N'DVDC',N'N',N'',N'',N'Tài chính đã xác nhận',1,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'PLRDI0001055402',N'APPROVE',N'C',N'',N'',N'',NULL,N'TC',N'Y',NULL,NULL,N'Hoàn tất',NULL,NULL)

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