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

 

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

                             @from = ' FROM PL_REQUEST_DOC WHERE REQ_CODE =''0026/2020/TTr-0690605'' '                 -- varchar(800)

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

                             @from = ' FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0026/2020/TTr-0690605'') '                 -- varchar(800)

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

                             @from = ' FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0026/2020/TTr-0690605'') '                 -- varchar(800)

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

                             @from = ' FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0026/2020/TTr-0690605'') '                 -- varchar(800)

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

                             @from = ' FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0026/2020/TTr-0690605'') '                 -- varchar(800)

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

                             @from = ' FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0026/2020/TTr-0690605'') '                 -- varchar(800)

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

                             @from = ' FROM PL_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0026/2020/TTr-0690605'') '                 -- 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'PLRD00000200412',N'0026/2020/TTr-0690605',N'Kế hoạch triển khai các hoạt động và truyền thông nhân dịp sinh nhật 28 năm',N'Oct 15 2020 12:00AM',1,N'Kế hoạch triển khai các hoạt động và truyền thông nhân dịp sinh nhật 28 năm',N'Kế hoạch triển khai các hoạt động và truyền thông nhân dịp sinh nhật 28 năm',N'DV0001',1118000000,NULL,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'U',NULL,NULL,N'APPNEW',NULL,NULL,N'DV0001',NULL,1,N'DEP000000000015',N'DEP000000000015',N'DV0001',N'DEP000000000015',NULL,NULL,NULL,NULL,1,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'PLRDD0000204212',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo email mua hàng',N'O',N'',5000,30000.00,150000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112289',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Cái') 

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'PLRDD0000204213',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo email mua hàng',N'O',N'',500,100000.00,50000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112289',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Cái') 

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'PLRDD0000204214',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo email mua hàng',N'O',N'',1800,120000.00,216000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112289',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Áo') 

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'PLRDD0000204215',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo từng đơn vị',N'O',N'',120,1000000.00,120000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112284',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Event') 

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'PLRDD0000204216',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Tổ chức tại HO',N'O',N'',1,30000000.00,30000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112284',N'VND',1.00,0.00,N'CMS000000251259',N'CDT',N'DM0000000000017',N'Event') 

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'PLRDD0000204217',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo email mua hàng',N'O',N'',1800,100000.00,180000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112289',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Cái') 

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'PLRDD0000204218',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Qùa tặng',N'O',N'',1,82000000.00,82000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112268',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Gói') 

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'PLRDD0000204219',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Landing page',N'O',N'',1,80000000.00,80000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112268',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Gói') 

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'PLRDD0000204220',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo email mua hàng',N'O',N'',1,80000000.00,80000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000003515',N'VND',1.00,0.00,N'CMS000001126251',N'CDT',N'DM0000000000017',N'Gói') 

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'PLRDD0000204221',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Theo email mua hàng',N'O',N'',1,100000000.00,100000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112275',N'VND',1.00,0.00,N'CMS000001126233',N'CDT',N'DM0000000000017',N'Gói') 

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'PLRDD0000204222',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Ngân sách dự phòng',N'O',N'',1,20000000.00,20000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112278',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Gói') 

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'PLRDD0000204223',N'PLRD00000200412',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',N'',N'Minigame',N'I',N'',1,10000000.00,10000000.00,N'1',N'tuyentt',N'Oct 20 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000004',N'HH0000000112278',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000017',N'Gói') 

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'PLRT00000201052',N'PLRD00000200412',N'PLM000000016940',N'PLT000000071163',N'GOO000001064301',N'DV0001',N'DV0001',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',0,50000000.00,N'',N'E',N'tuyentt',N'Oct 20 2020 12:00AM',NULL,NULL,N'DM0000000000004',N'DEP000000000015',N'DEP000000000015',N'DM0000000000017',N'DM0000000000004',N'DM0000000000017') 

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'PLRT00000201053',N'PLRD00000200412',N'PLM000000016939',N'PLT000000071154',N'GOO000001064395',N'DV0001',N'DV0001',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',0,50000000.00,N'',N'E',N'tuyentt',N'Oct 20 2020 12:00AM',NULL,NULL,N'DM0000000000004',N'DEP000000000015',N'DEP000000000015',N'DM0000000000017',N'DM0000000000004',N'DM0000000000017') 

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'PLRT00000201054',N'PLRD00000200412',N'PLM000000016939',N'PLT000000071146',N'GOO000001064387',N'DV0001',N'DV0001',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',0,180000000.00,N'',N'E',N'tuyentt',N'Oct 20 2020 12:00AM',NULL,NULL,N'DM0000000000004',N'DEP000000000015',N'DEP000000000015',N'DM0000000000017',N'DM0000000000004',N'DM0000000000017') 

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'PLRT00000201055',N'PLRD00000200412',N'PLM000000016941',N'PLT000000071164',N'GOO000001064399',N'DV0001',N'DV0001',N'PLM000000016943',N'PLT000000071169',N'GOO000001064381',0,500000000.00,N'',N'E',N'tuyentt',N'Oct 20 2020 12:00AM',NULL,NULL,N'DM0000000000004',N'DEP000000000015',N'DEP000000000015',N'DM0000000000017',N'DM0000000000004',N'DM0000000000017') 

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'PLRC00000202190',N'DM0000000000004',N'PLRD00000200412',N'',N'E',N'tuyentt',N'Oct 20 2020 12:00AM',NULL,NULL,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(4759,N'PLRD00000200412',N'APPNEW',N'C',N'GDDV',N'DV0001',N'',NULL,N'',N'N',N'',N'',N'Chờ trưởng đơn vị phê duyệt',NULL,N'DEP000000000015') 

Column1 

INSERT INTO [PL_PROCESS] ([ID],[REQ_ID],[PROCESS_ID],[CHECKER_ID],[APPROVE_DT],[PROCESS_DESC],[NOTES])VALUES(26945,N'PLRD00000200412',N'SEND',N'tuyentt',N'Oct 22 2020 8:52AM',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') 

Result ErrorDesc 

SUCCESSFULL