currency

curr_id	description
CHF	Swiss Franc
USD	United States Dollar
EUR	European Montetary Union EURO

(3 rows)

bank

bank_id	description
YSB	Your Swiss Bank

(1 row)

summary_fund_cv

Fund ID	Bank ID	curr_id	abbrev	name	wht	s_adj	derived	date	Total Number of Shares	Total Cost Basis	Average Cost Basis per Share	Total Market Value
1	YSB	EUR	Eur Eq	European Equity Fund	0.35	f		2002-03-01	50	1051.00	21.0200	1100.00
2	YSB	USD	Eur Eq	European Equity Fund	0.35	f	1	2002-03-01	50	1019.32	20.3864	951.50

(2 rows)

share_purchase_cjv

curr_id	abbrev	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share (fees?)
EUR	Eur Eq	1	2000-02-01	20	100	0.25
USD	Eur Eq	2	2000-02-01	19.46	100	0.2433

(2 rows)

share_redemption_cjv

curr_id	abbrev	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share (fees?)
EUR	Eur Eq	1	2002-03-01	22	50	0.4
USD	Eur Eq	2	2002-03-01	19.03	50	0.3461

(2 rows)

fund_income_cjv

curr_id	abbrev	Fund ID	Revenue Type	Distributed by Fund Manager?	Record Date	Income per Share	Pay Date
EUR	Eur Eq	1	DIV	f	2000-12-01	0.27
EUR	Eur Eq	1	DIV	f	2001-12-01	0.30
USD	Eur Eq	2	DIV	f	2000-12-01	0.24
USD	Eur Eq	2	DIV	f	2001-12-01	0.27

(4 rows)

reinvested_fund_income_cjv

curr_id	abbrev	Fund ID	date	price_ps	Number of Shares	Basis Adj. per Share (fees?)	Revenue Type	Distributed by Fund Manager?	Record Date	Income per Share	Pay Date

(0 rows)

summary_cjv

curr_id	abbrev	row_id	Fund ID	date	Price per Share	Number of Shares	Basis Adj. per Share	action	Sale Date	Other Basis Adj. per Share	Simple Cost Basis per Share	price	Simple Cost Basis	Total Number of Shares	Sale Price	Capital Gain, FIFO Method	Total Cost Basis	Average Cost Basis per Share	Average Basis of These Shares	Capital Gain, ACB Method	Long Term / Short Term
EUR	Eur Eq	1771618	1	2000-02-01	20	50	0.25	BUY	2002-03-01	0.57	21.22	1000.00	1061.00	50	1100.00	39.00	1061.00	21.2200	1051.00	49.00	LTCG
EUR	Eur Eq	1771619	1	2000-02-01	20	50	0.25	BUY		0.57	20.82	1000.00	1041.00	100			2102.00	21.0200
EUR	Eur Eq	1771620	1	2002-03-01	22	50	0.4	SELL						50	1100.00		1051.00	21.0200	1051.00	49.00
USD	Eur Eq	1771621	2	2000-02-01	19.46	50	0.2433	BUY	2002-03-01	0.51	20.5594	973.00	1027.97	50	951.50	-76.47	1027.97	20.5594	1019.32	-67.82	LTCG
USD	Eur Eq	1771622	2	2000-02-01	19.46	50	0.2433	BUY		0.51	20.2133	973.00	1010.67	100			2038.64	20.3864
USD	Eur Eq	1771623	2	2002-03-01	19.03	50	0.3461	SELL						50	951.50		1019.32	20.3864	1019.32	-67.82

(6 rows)

summary_cg_fifo_cjv

curr_id	abbrev	Fund ID	date	Number of Shares	Sale Date	Sale Price	Simple Cost Basis	Capital Gain, FIFO Method	Long Term / Short Term
EUR	Eur Eq	1	2000-02-01	50	2002-03-01	1100.00	1061.00	39.00	LTCG
USD	Eur Eq	2	2000-02-01	50	2002-03-01	951.50	1027.97	-76.47	LTCG

(2 rows)

summary_cg_acb_cjv

curr_id	abbrev	Fund ID	date	Number of Shares	Sale Date	Sale Price	Average Basis of These Shares	Capital Gain, ACB Method	Long Term / Short Term
EUR	Eur Eq	1	2000-02-01	50	2002-03-01	1100.00	1051.00	49.00	LTCG
USD	Eur Eq	2	2000-02-01	50	2002-03-01	951.50	1019.32	-67.82	LTCG

(2 rows)
DROP CREATE

summary_fund_income_pcjv

curr_id	year	abbrev	sum(Net Income)
EUR	2000	Eur Eq	27.00
EUR	2000		27.00
EUR	2001	Eur Eq	30.00
EUR	2001		30.00
EUR			57.00
USD	2000	Eur Eq	24.00
USD	2000		24.00
USD	2001	Eur Eq	27.00
USD	2001		27.00
USD			51.00

(10 rows)
DROP CREATE

summary_cg_fifo_pcjv

curr_id	year	abbrev	Sale Date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Simple Cost Basis)	sum(Capital Gain, FIFO Method)
EUR	2002	Eur Eq	2002-03-01	LTCG	50	1100.00	1061.00	39.00
EUR	2002	Eur Eq			50	1100.00	1061.00	39.00
EUR	2002				50	1100.00	1061.00	39.00
EUR					50	1100.00	1061.00	39.00
USD	2002	Eur Eq	2002-03-01	LTCG	50	951.50	1027.97	-76.47
USD	2002	Eur Eq			50	951.50	1027.97	-76.47
USD	2002				50	951.50	1027.97	-76.47
USD					50	951.50	1027.97	-76.47

(8 rows)
DROP CREATE

summary_cg_acb_pcjv

curr_id	year	abbrev	Sale Date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Average Basis of These Shar	sum(Capital Gain, ACB Method)
EUR	2002	Eur Eq	2002-03-01	LTCG	50	1100.00	1051.00	49.00
EUR	2002	Eur Eq			50	1100.00	1051.00	49.00
EUR	2002				50	1100.00	1051.00	49.00
EUR					50	1100.00	1051.00	49.00
USD	2002	Eur Eq	2002-03-01	LTCG	50	951.50	1019.32	-67.82
USD	2002	Eur Eq			50	951.50	1019.32	-67.82
USD	2002				50	951.50	1019.32	-67.82
USD					50	951.50	1019.32	-67.82

(8 rows)
DROP CREATE

detailed_summary_cg_acb_pcjv

curr_id	year	abbrev	Sale Date	date	Long Term / Short Term	sum(Number of Shares)	sum(Sale Price)	sum(Average Basis of These Shar	sum(Capital Gain, ACB Method)
EUR	2002	Eur Eq	2002-03-01	2000-02-01	LTCG	50	1100.00	1051.00	49.00
EUR	2002	Eur Eq	2002-03-01			50	1100.00	1051.00	49.00
EUR	2002	Eur Eq				50	1100.00	1051.00	49.00
EUR	2002					50	1100.00	1051.00	49.00
EUR						50	1100.00	1051.00	49.00
USD	2002	Eur Eq	2002-03-01	2000-02-01	LTCG	50	951.50	1019.32	-67.82
USD	2002	Eur Eq	2002-03-01			50	951.50	1019.32	-67.82
USD	2002	Eur Eq				50	951.50	1019.32	-67.82
USD	2002					50	951.50	1019.32	-67.82
USD						50	951.50	1019.32	-67.82

(10 rows)