EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC', -- varchar(776) @from = ' FROM PL_REQUEST_DOC WHERE REQ_ID =''PLRD00000200306'' ' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC_DT', -- varchar(776) @from = ' FROM PL_REQUEST_DOC_DT WHERE REQ_ID =''PLRD00000200306'' ' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_TRANSFER', -- varchar(776) @from = ' FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =''PLRD00000200306'' ' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_COSTCENTER', -- varchar(776) @from = ' FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =''PLRD00000200306'' ' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS', -- varchar(776) @from = ' FROM PL_REQUEST_PROCESS WHERE REQ_ID =''PLRD00000200306'' ' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD', -- varchar(776) @from = ' FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =''PLRD00000200306'' ' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS', -- varchar(776) @from = ' FROM PL_PROCESS WHERE REQ_ID =''PLRD00000200306'' ' -- varchar(800) Trạng thái: Select thành công Column1 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'PLRD00000200306',N'0001/2020/TTr-0340007',N'MUA DESKTOP THAY THẾ MÁY CŨ TRÊN 7 NĂM; MUA MỘT SỐ CCLD KHÁC PHỤC VỤ CÔNG VIỆC',N'Oct 7 2020 12:00AM',1,N'MUA DESKTOP THAY THẾ MÁY CŨ TRÊN 7 NĂM; MUA MỘT SỐ THIẾT BỊ NÂNG CẤP MÁY TÍNH CÓ CẤU HÌNH YẾU ẢNH HƯỞNG THỜI GIAN GIAO DỊCH; MUA MỘT SỐ CCDC KHÁC PHỤC VỤ CÔNG VIỆC.',N'MUA DESKTOP THAY THẾ MÁY CŨ TRÊN 7 NĂM; MUA MỘT SỐ THIẾT BỊ NÂNG CẤP MÁY TÍNH CÓ CẤU HÌNH YẾU ẢNH HƯỞNG THỜI GIAN GIAO DỊCH; MUA MỘT SỐ CCDC KHÁC PHỤC VỤ CÔNG VIỆC.',N'BRN000000000401',115130000,NULL,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'A',N'minhnl',N'Oct 20 2020 1:35PM',N'DVCM',NULL,NULL,N'BRN000000000401',NULL,NULL,N'',N'',N'BRN000000000401',N'',NULL,NULL,NULL,N'',0,N'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) Column1 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'PLRDD0000204050',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070596',N'GOO000001063087',N'',N'hp prodesk 400G6',N'I',N'',4,14850000.00,59400000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',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'PLRDD0000204051',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070597',N'GOO000001063535',N'',N'8GB/1600',N'I',N'',3,990000.00,2970000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000052',N'HH0000000112053',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'THANH/CAI/CHIEC') 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'PLRDD0000204052',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070597',N'GOO000001063535',N'',N'8GB/2400',N'I',N'',3,870000.00,2610000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000052',N'HH0000000112053',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'THANH/CAI/CHIEC') 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'PLRDD0000204053',N'PLRD00000200306',N'',N'',N'GOO000001063542',N'',N'SSD 250GB',N'O',N'',6,1590000.00,9540000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000052',N'HH0000000112045',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'CAI/CHIEC') 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'PLRDD0000204054',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071591',N'GOO000001062411',N'',N'Mắt đọc/mắt số rời',N'O',N'',4,1500000.00,6000000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000003',N'HH0000000112168',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000015',N'CAI/CHIEC') 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'PLRDD0000204055',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071593',N'GOO000001062145',N'',N'MÁY HUỶ GIẤY DINO - PLUS (HUỶ GIẤY, CARD, CD, KIM KẸP) 410X318X620MM',N'O',N'',1,6180000.00,6180000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000003',N'HH0000000112107',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000015',N'CAI/CHIEC') 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'PLRDD0000204056',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071590',N'GOO000001062151',N'',N'MÁY/CÂY MÁY NƯỚC NÓNG LẠNH',N'O',N'',1,3800000.00,3800000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000003',N'HH0000000112143',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000015',N'CAI/CHIEC') 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'PLRDD0000204057',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071589',N'GOO000001062199',N'',N'XE ĐẨY HÀNG',N'I',N'',1,3100000.00,3100000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000003',N'HH0000000112129',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000015',N'CAI/CHIEC') 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'PLRDD0000204058',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070598',N'GOO000001063075',N'',N'BỘ LƯU ĐIỆN/UBS 1000VA',N'I',N'',4,3000000.00,12000000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000052',N'HH0000000112067',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'CAI/CHIEC') 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'PLRDD0000204059',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070595',N'GOO000001063077',N'',N'BỘ LƯU ĐIỆN/UBS 2000VA',N'I',N'',1,6000000.00,6000000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000052',N'HH0000000112067',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000018',N'CAI/CHIEC') 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'PLRDD0000204060',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071592',N'GOO000001062127',N'',N'HANG LIEN DOANH TRUNG QUOC - NHAT BAN',N'O',N'',1,3530000.00,3530000.00,N'1',N'thuandd',N'Oct 7 2020 12:00AM',N'R',N'minhnl',N'Oct 20 2020 1:35PM',N'DM0000000000003',N'HH0000000112110',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000015',N'CAI/CHIEC') Column1 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'PLRT00000201017',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071588',N'GOO000001062195',N'BRN000000000401',N'BRN000000000401',N'PLM000000017091',N'PLT000000071591',N'GOO000001062411',0,2800000.00,N'Điều chuyển Ngân sách mua Tủ/kệ sắt trong kho tiền bổ sung mua Mắt đọc máy đếm tiền',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',N'DM0000000000003',N'',N'',N'DM0000000000015',N'DM0000000000003',N'DM0000000000015') 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'PLRT00000201018',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070598',N'GOO000001063075',N'BRN000000000401',N'BRN000000000401',N'PLM000000017091',N'PLT000000071593',N'GOO000001062145',0,1400000.00,N'Điều chuyển ngân sách mua bộ lưu điện 1000VA bổ sung NS mua máy huỷ giấy- huỷ thẻ',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',N'DM0000000000003',N'',N'',N'DM0000000000015',N'DM0000000000052',N'DM0000000000018') 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'PLRT00000201019',N'PLRD00000200306',N'PLM000000016833',N'PLT000000070595',N'GOO000001063077',N'BRN000000000401',N'BRN000000000401',N'PLM000000017091',N'PLT000000071593',N'GOO000001062145',0,1490000.00,N'Điều chuyển ngân sách mua bộ lưu điện 2000VA bổ sung NS mua máy huỷ giấy- huỷ thẻ',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',N'DM0000000000003',N'',N'',N'DM0000000000015',N'DM0000000000052',N'DM0000000000018') 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'PLRT00000201020',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071588',N'GOO000001062195',N'BRN000000000401',N'BRN000000000401',N'PLM000000017091',N'PLT000000071592',N'GOO000001062127',0,860000.00,N'Điều chuyển ngân sách mua Tủ/kệ sắt trong kho tiền sang NS mua Máy bó tiền',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',N'DM0000000000003',N'',N'',N'DM0000000000015',N'DM0000000000003',N'DM0000000000015') 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'PLRT00000201021',N'PLRD00000200306',N'PLM000000017091',N'PLT000000071588',N'GOO000001062195',N'BRN000000000401',N'BRN000000000401',N'PLM000000017091',N'PLT000000071590',N'GOO000001062151',0,1330000.00,N'Điều chuyển ngân sách mua Tủ/kệ sắt trong kho tiền sang NS mua Máy nước nóng lạnh',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',N'DM0000000000003',N'',N'',N'DM0000000000015',N'DM0000000000003',N'DM0000000000015') 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'PLRT00000201022',N'PLRD00000200306',N'PLM000000017065',N'PLT000000071400',N'GOO000001062201',N'BRN000000000401',N'BRN000000000401',N'',N'',N'GOO000001063542',0,28800000.00,N'Điều chuyển ngân sách mua ô tô vận chuyển tiền sang NS mua ổ cứng SSD (Không mua xe trong năm 2020)',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',N'DM0000000000052',N'',N'',N'DM0000000000018',N'DM0000000000003',N'DM0000000000015') Column1 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'PLRC00000202118',N'DM0000000000052',N'PLRD00000200306',N'Xác nhận xuất kho 4PC, Ram và SSD cho PC đơn vị tự mua.',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',NULL,NULL) 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'PLRC00000202119',N'DM0000000000003',N'PLRD00000200306',N'',N'R',N'thuandd',N'Oct 7 2020 12:00AM',N'minhnl',N'Oct 8 2020 12:00AM',NULL,NULL) Column1 INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4503,N'PLRD00000200306',N'APPNEW',N'P',N'GDDV',N'BRN000000000401',N'minhnl',N'Oct 20 2020 1:35PM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'') INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4504,N'PLRD00000200306',N'KT',N'P',N'KSV',N'',N'chaudtm',N'Oct 21 2020 1:39PM',N'APPNEW',N'N',N'',N'DM0000000000006',N'Phòng kế toán đã phê duyệt',1,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4505,N'PLRD00000200306',N'DVCM',N'C',N'GDDV',N'',N'',NULL,N'KT',N'N',N'',N'DM0000000000052',N'Chờ đơn vị chuyên môn xác nhận',1,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4506,N'PLRD00000200306',N'DVCM',N'C',N'GDDV',N'',N'',NULL,N'KT',N'N',N'',N'DM0000000000003',N'Chờ đơn vị chuyên môn xác nhận',1,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4507,N'PLRD00000200306',N'TC',N'U',N'TC',N'',N'',NULL,N'DVCM',N'N',N'',N'',N'Chờ đơn vị Tài chính xác nhận',1,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4508,N'PLRD00000200306',N'TGD_DC',N'U',N'TGD',N'',N'',NULL,N'TC',N'',N'',N'',N'Chờ tổng giám đốc phê duyệt',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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(4509,N'PLRD00000200306',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD_DC',N'Y',NULL,NULL,N'Hoàn tất',NULL,NULL) Column1 INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([ID],[REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(7757,N'PLRD00000200306',N'3624',N'chaudtm',N'TP',1,N'C',N'1',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([ID],[REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(7758,N'PLRD00000200306',N'3624',N'trinhctm',N'XL',2,N'P',N'1',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([ID],[REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(9213,N'PLRD00000200306',N'4504',N'chaudtm',N'TP',1,N'P',N'1',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([ID],[REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(9214,N'PLRD00000200306',N'4504',N'trinhctm',N'XL',2,N'P',N'1',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([ID],[REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(9445,N'PLRD00000200306',N'4505',N'tuanva',N'TP',1,N'C',N'1',NULL,NULL) INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([ID],[REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(9446,N'PLRD00000200306',N'4505',N'baotq',N'XL',2,N'P',N'1',NULL,NULL) Column1 INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(21574,N'PLRD00000200306',N'SEND',N'thuandd',N'Oct 8 2020 4:57PM',N'Người tạo tờ trình gửi phê duyệt thành công',N'Nhân viên gửi phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(21580,N'PLRD00000200306',N'APPNEW',N'minhnl',N'Oct 8 2020 5:00PM',N'Phê duyệt',N'Trưởng đơn vị phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(21693,N'PLRD00000200306',N'KT',N'chaudtm',N'Oct 9 2020 8:54AM',N'Nhân viên tiếp nhận Chế Thị Minh Trinh',N'Điều phối Xử lý phiếu') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(22222,N'PLRD00000200306',N'SEND',N'trinhctm',N'Oct 12 2020 8:31AM',N'Nhân viên xử lý phiếu gửi phê duyệt thành công',N'Nhân viên xử lý gửi phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(22349,N'PLRD00000200306',N'REJECT',N'chaudtm',N'Oct 12 2020 9:54AM',N'- Ổ cứng, Ram loại hạng mục CP Opex - CP trong KH là 95.110.000đ, ngoài KH là 13.390.000đ - Thống nhất lại tên hàng hóa ổ cứng mà hạng mục nhận điều chuyển SSD - Máy nước nóng lạnh vượt Ngân sách - Ghi rõ đơn vị tính: cái hay chiếc hay thanh ? - Lưu ý: ngày tạo tờ trình phải trước ngày thực hiện',N'Trả về người tạo') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(25730,N'PLRD00000200306',N'SEND',N'thuandd',N'Oct 20 2020 9:14AM',N'Người tạo tờ trình gửi phê duyệt thành công',N'Nhân viên gửi phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(25860,N'PLRD00000200306',N'APPNEW',N'minhnl',N'Oct 20 2020 1:35PM',N'Phê duyệt',N'Trưởng đơn vị phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(26102,N'PLRD00000200306',N'KT',N'chaudtm',N'Oct 20 2020 5:13PM',N'Nhân viên tiếp nhận Chế Thị Minh Trinh',N'Điều phối Xử lý phiếu') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(26223,N'PLRD00000200306',N'SEND',N'trinhctm',N'Oct 21 2020 8:53AM',N'Nhân viên xử lý phiếu gửi phê duyệt thành công',N'Nhân viên xử lý gửi phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(26549,N'PLRD00000200306',N'KT',N'chaudtm',N'Oct 21 2020 1:39PM',N'Phê duyệt',N'Trưởng đơn vị đã phê duyệt') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(26576,N'PLRD00000200306',N'DVCM',N'tuanva',N'Oct 21 2020 2:12PM',N'Nhân viên tiếp nhận Trương Quang Bảo',N'Điều phối Xử lý phiếu') INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(26579,N'PLRD00000200306',N'SEND',N'baotq',N'Oct 21 2020 2:13PM',N'Nhân viên xử lý phiếu gửi phê duyệt thành công',N'Nhân viên xử lý gửi phê duyệt') Result ErrorDesc SUCCESSFULL