create table PDCL 
( 
Date date,
Customer number,
Deal number,
Currency varchar2(3),
Sum number
);


insert into PDCL (to_date('12.12.2009','dd.mm.yyyy'),	111110,	111111,	'RUR',	12000);
insert into PDCL (to_date('25.12.2009','dd.mm.yyyy'),	111110,	111111,	'RUR',	5000);
insert into PDCL (to_date('12.12.2009','dd.mm.yyyy'),	111110,	122222,	'RUR',	10000);
insert into PDCL (to_date('12.01.2010','dd.mm.yyyy'),	111110,	111111,	'RUR',	-10100);
insert into PDCL (to_date('20.11.2009','dd.mm.yyyy'),	220000,	222221,	'RUR',	25000);
insert into PDCL (to_date('20.12.2009','dd.mm.yyyy'),	220000,	222221,	'RUR',	20000);
insert into PDCL (to_date('31.12.2009','dd.mm.yyyy'),	220001,	222221,	'RUR',	-10000);
insert into PDCL (to_date('29.12.2009','dd.mm.yyyy'),	111110,	122222,	'RUR',	-10000);
insert into PDCL (to_date('27.11.2009','dd.mm.yyyy'),	220001,	222221,	'RUR',	-30000);

commit;