dealstagesteps.txt

国外的一套开源CRM

delete deal_stage_steps;
insert into deal_stage_steps values(1, 1, 1, 'mail intro letter', '', 5, 'sfa', '1970-12-31 00:00:00.0',   'sfa',  '1970-12-31 00:00:00.0',    1);
insert into deal_stage_steps values(2, 1, 0, 'mail product literature', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(3, 1, 1, 'identify key contacts', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(4, 2, 1, 'identify key decision makers', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(5, 2, 1, 'set-up face-toface meeting', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(6, 3, 1, 'had face-to-face meeting', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(7, 4, 1, 'prepare value proposition', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(8, 5, 1, 'prepare pain-point survey', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(9, 5, 1, 'set-up product demonstration', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(10, 6, 1, 'final product decision', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(11, 7, 1, 'had face-to-face meeting with key-decision maker', '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(12, 8, 1, 'prepare proposal',  '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(13, 9, 1, 'negotiate deal',  '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(14, 10, 1, 'final negotiations',  '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(15, 11, 1, 'deliver contracts',  '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(16, 12, 1, 'signed contracts',  '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);
insert into deal_stage_steps values(17, 13, 1, 'cash collected',  '', 5,  'sfa', '1970-12-31 00:00:00.0', 'sfa', '1970-12-31 00:00:00.0', 1);