dealstage.txt

国外的一套开源CRM

delete from deal_stage;
insert into deal_stage values ( 1, 'target', '', 1, .025, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 2, 'telephoned prospect', '', 2, .05, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 3, 'initial meeting', '', 3, .1, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 4, 'qualified', '', 4, .15, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 5, 'demonstration', '', 5, .2, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 6, 'product review', '', 6, .3, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 7, 'product final decision', '', 7, .35, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 8, 'key decision maker meeting', '', 8, .55, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 9, 'proposal', '', 9, .5, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 10, 'negotiation', '', 10, .6, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 11, 'final negotiation', '', 11, .8, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 12, 'contracts delivered', '', 12, .9, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 13, 'contracts signed', '', 13, 1, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);
insert into deal_stage values ( 14, 'cash collected', '', 14, 1, 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00', 1);