currency
curr_id description
USD United States Dollar
(1 row)
bank
bank_id description
YB Your 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
2 YB USD Ex. 1 Fund, 2001 IRS Pub 564, Ex. 1, p.7 0.00 f   2001-05-16 150 2400.00 16.0000 4500.00
3 YB USD Ex. 2 Fund, 2001 IRS Pub 564, Example 2, p.8 0.00 f 2 2001-12-15 100 1600.00 16.0000 2800.00
4 YB USD Ex. 3 Fund, 2001 IRS Pub 564, Example 3, p.8 0.00 f 2 2001-12-15 250 3750.00 15.0000 7000.00
5 YB USD Fund S Fund S, 2001 IRS Pub 564, Comp Ex., p.11 0.00 f   2001-10-06 0 0.00 9.9800 0.00
1 YB USD Table 3 Fund, 2001 IRS Pub 564, Table 3, p.7 0.00 f   2001-09-29 200 4439.02 22.1951 6400.00
(5 rows)
share_purchase_cjv
curr_id abbrev Fund ID date Price per Share Number of Shares Basis Adj. per Share (fees?)
USD Ex. 1 2 1998-01-01 10 100 0
USD Ex. 1 2 1999-01-01 12 100 0
USD Ex. 1 2 2000-01-01 26 100 0
USD Ex. 2 3 1998-01-01 10 100 0
USD Ex. 2 3 1999-01-01 12 100 0
USD Ex. 2 3 2000-01-01 26 100 0
USD Ex. 3 4 1998-01-01 10 100 0
USD Ex. 3 4 1999-01-01 12 100 0
USD Ex. 3 4 2000-01-01 26 100 0
USD Ex. 3 4 2001-09-19 14 150 0
USD Fund S 5 1987-07-10 10 200 0
USD Table 3 1 2000-02-04 25 160 0
USD Table 3 1 2000-08-05 20 240 0
USD Table 3 1 2000-12-16 30 10 0
(14 rows)
share_redemption_cjv
curr_id abbrev Fund ID date Price per Share Number of Shares Basis Adj. per Share (fees?)
USD Ex. 1 2 2001-05-16 30 150 0
USD Ex. 2 3 2001-05-16 30 150 0
USD Ex. 2 3 2001-12-15 28 50 0
USD Ex. 3 4 2001-05-16 30 150 0
USD Ex. 3 4 2001-12-15 28 50 0
USD Fund S 5 2001-10-06 16 200 0
USD Table 3 1 2001-09-29 32 210 0
(7 rows)
fund_income_cjv
curr_id abbrev Fund ID Revenue Type Distributed by Fund Manager? Record Date Income per Share Pay Date
USD Fund S 5 ROC t 1989-01-01 0.05  
USD Fund S 5 ROC t 1990-01-01 0.02  
USD Fund S 5 ROC t 1998-01-01 0.04  
USD Fund S 5 CG f 1999-01-01 0.03  
USD Fund S 5 CG f 2000-01-01 0.06  
USD Table 3 1 DIV t      
(6 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
USD Table 3 1 2000-12-16 30 10 0 DIV t      
(1 row)
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
USD Ex. 1 1771325 2 1998-01-01 10 100 0 BUY 2001-05-16 0 10 1000.00 1000.00 100 3000.00 2000.00 1000.00 10.0000 1600.00 1400.00 LTCG
USD Ex. 1 1771326 2 1999-01-01 12 50 0 BUY 2001-05-16 0 12 600.00 600.00 150 1500.00 900.00 1600.00 10.6667 800.00 700.00 LTCG
USD Ex. 1 1771327 2 1999-01-01 12 50 0 BUY   0 12 600.00 600.00 200     2200.00 11.0000      
USD Ex. 1 1771328 2 2000-01-01 26 100 0 BUY   0 26 2600.00 2600.00 300     4800.00 16.0000      
USD Ex. 1 1771329 2 2001-05-16 30 150 0 SELL           150 4500.00   2400.00 16.0000 2400.00 2100.00  
USD Ex. 2 1771330 3 1998-01-01 10 100 0 BUY 2001-05-16 0 10 1000.00 1000.00 100 3000.00 2000.00 1000.00 10.0000 1600.00 1400.00 LTCG
USD Ex. 2 1771331 3 1999-01-01 12 50 0 BUY 2001-05-16 0 12 600.00 600.00 150 1500.00 900.00 1600.00 10.6667 800.00 700.00 LTCG
USD Ex. 2 1771332 3 1999-01-01 12 50 0 BUY 2001-12-15 0 12 600.00 600.00 200 1400.00 800.00 2200.00 11.0000 800.00 600.00 LTCG
USD Ex. 2 1771333 3 2000-01-01 26 100 0 BUY   0 26 2600.00 2600.00 300     4800.00 16.0000      
USD Ex. 2 1771334 3 2001-05-16 30 150 0 SELL           150 4500.00   2400.00 16.0000 2400.00 2100.00  
USD Ex. 2 1771335 3 2001-12-15 28 50 0 SELL           100 1400.00   1600.00 16.0000 800.00 600.00  
USD Ex. 3 1771336 4 1998-01-01 10 100 0 BUY 2001-05-16 0 10 1000.00 1000.00 100 3000.00 2000.00 1000.00 10.0000 1600.00 1400.00 LTCG
USD Ex. 3 1771337 4 1999-01-01 12 50 0 BUY 2001-05-16 0 12 600.00 600.00 150 1500.00 900.00 1600.00 10.6667 800.00 700.00 LTCG
USD Ex. 3 1771338 4 1999-01-01 12 50 0 BUY 2001-12-15 0 12 600.00 600.00 200 1400.00 800.00 2200.00 11.0000 750.00 650.00 LTCG
USD Ex. 3 1771339 4 2000-01-01 26 100 0 BUY   0 26 2600.00 2600.00 300     4800.00 16.0000      
USD Ex. 3 1771340 4 2001-05-16 30 150 0 SELL           150 4500.00   2400.00 16.0000 2400.00 2100.00  
USD Ex. 3 1771341 4 2001-09-19 14 150 0 BUY   0 14 2100.00 2100.00 300     4500.00 15.0000      
USD Ex. 3 1771342 4 2001-12-15 28 50 0 SELL           250 1400.00   3750.00 15.0000 750.00 650.00  
USD Fund S 1771343 5 1987-07-10 10 200 0 BUY 2001-10-06 -0.02 9.98 2000.00 1996.00 200 3200.00 1204.00 1996.00 9.9800 1996.00 1204.00 5YCG
USD Fund S 1771344 5 2001-10-06 16 200 0 SELL           0 3200.00   0.00 9.9800 1996.00 1204.00  
USD Table 3 1771320 1 2000-02-04 25 160 0 BUY 2001-09-29 0 25 4000.00 4000.00 160 5120.00 1120.00 4000.00 25.0000 3551.22 1568.78 LTCG
USD Table 3 1771321 1 2000-08-05 20 50 0 BUY 2001-09-29 0 20 1000.00 1000.00 210 1600.00 600.00 5000.00 23.8095 1109.76 490.24 LTCG
USD Table 3 1771322 1 2000-08-05 20 190 0 BUY   0 20 3800.00 3800.00 400     8800.00 22.0000      
USD Table 3 1771323 1 2000-12-16 30 10 0 BUY   0 30 300.00 300.00 410     9100.00 22.1951      
USD Table 3 1771324 1 2001-09-29 32 210 0 SELL           200 6720.00   4439.02 22.1951 4660.97 2059.03  
(25 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
USD Table 3 1 2000-02-04 160 2001-09-29 5120.00 4000.00 1120.00 LTCG
USD Table 3 1 2000-08-05 50 2001-09-29 1600.00 1000.00 600.00 LTCG
USD Ex. 1 2 1998-01-01 100 2001-05-16 3000.00 1000.00 2000.00 LTCG
USD Ex. 1 2 1999-01-01 50 2001-05-16 1500.00 600.00 900.00 LTCG
USD Ex. 2 3 1998-01-01 100 2001-05-16 3000.00 1000.00 2000.00 LTCG
USD Ex. 2 3 1999-01-01 50 2001-05-16 1500.00 600.00 900.00 LTCG
USD Ex. 2 3 1999-01-01 50 2001-12-15 1400.00 600.00 800.00 LTCG
USD Ex. 3 4 1998-01-01 100 2001-05-16 3000.00 1000.00 2000.00 LTCG
USD Ex. 3 4 1999-01-01 50 2001-05-16 1500.00 600.00 900.00 LTCG
USD Ex. 3 4 1999-01-01 50 2001-12-15 1400.00 600.00 800.00 LTCG
USD Fund S 5 1987-07-10 200 2001-10-06 3200.00 1996.00 1204.00 5YCG
(11 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
USD Table 3 1 2000-02-04 160 2001-09-29 5120.00 3551.22 1568.78 LTCG
USD Table 3 1 2000-08-05 50 2001-09-29 1600.00 1109.76 490.24 LTCG
USD Ex. 1 2 1998-01-01 100 2001-05-16 3000.00 1600.00 1400.00 LTCG
USD Ex. 1 2 1999-01-01 50 2001-05-16 1500.00 800.00 700.00 LTCG
USD Ex. 2 3 1998-01-01 100 2001-05-16 3000.00 1600.00 1400.00 LTCG
USD Ex. 2 3 1999-01-01 50 2001-05-16 1500.00 800.00 700.00 LTCG
USD Ex. 2 3 1999-01-01 50 2001-12-15 1400.00 800.00 600.00 LTCG
USD Ex. 3 4 1998-01-01 100 2001-05-16 3000.00 1600.00 1400.00 LTCG
USD Ex. 3 4 1999-01-01 50 2001-05-16 1500.00 800.00 700.00 LTCG
USD Ex. 3 4 1999-01-01 50 2001-12-15 1400.00 750.00 650.00 LTCG
USD Fund S 5 1987-07-10 200 2001-10-06 3200.00 1996.00 1204.00 5YCG
(11 rows)
DROP CREATE
summary_fund_income_pcjv
curr_id year abbrev sum(Net Income)
USD 1989 Fund S 10.00
USD 1989   10.00
USD 1990 Fund S 4.00
USD 1990   4.00
USD 1998 Fund S 8.00
USD 1998   8.00
USD 1999 Fund S 6.00
USD 1999   6.00
USD 2000 Fund S 12.00
USD 2000   12.00
USD   Table 3  
USD     40.00
USD      
(13 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)
USD 2001 Ex. 1 2001-05-16 LTCG 150 4500.00 1600.00 2900.00
USD 2001 Ex. 1     150 4500.00 1600.00 2900.00
USD 2001 Ex. 2 2001-05-16 LTCG 150 4500.00 1600.00 2900.00
USD 2001 Ex. 2 2001-12-15 LTCG 50 1400.00 600.00 800.00
USD 2001 Ex. 2     200 5900.00 2200.00 3700.00
USD 2001 Ex. 3 2001-05-16 LTCG 150 4500.00 1600.00 2900.00
USD 2001 Ex. 3 2001-12-15 LTCG 50 1400.00 600.00 800.00
USD 2001 Ex. 3     200 5900.00 2200.00 3700.00
USD 2001 Fund S 2001-10-06 5YCG 200 3200.00 1996.00 1204.00
USD 2001 Fund S     200 3200.00 1996.00 1204.00
USD 2001 Table 3 2001-09-29 LTCG 210 6720.00 5000.00 1720.00
USD 2001 Table 3     210 6720.00 5000.00 1720.00
USD 2001       960 26220.00 12996.00 13224.00
USD         960 26220.00 12996.00 13224.00
(14 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)
USD 2001 Ex. 1 2001-05-16 LTCG 150 4500.00 2400.00 2100.00
USD 2001 Ex. 1     150 4500.00 2400.00 2100.00
USD 2001 Ex. 2 2001-05-16 LTCG 150 4500.00 2400.00 2100.00
USD 2001 Ex. 2 2001-12-15 LTCG 50 1400.00 800.00 600.00
USD 2001 Ex. 2     200 5900.00 3200.00 2700.00
USD 2001 Ex. 3 2001-05-16 LTCG 150 4500.00 2400.00 2100.00
USD 2001 Ex. 3 2001-12-15 LTCG 50 1400.00 750.00 650.00
USD 2001 Ex. 3     200 5900.00 3150.00 2750.00
USD 2001 Fund S 2001-10-06 5YCG 200 3200.00 1996.00 1204.00
USD 2001 Fund S     200 3200.00 1996.00 1204.00
USD 2001 Table 3 2001-09-29 LTCG 210 6720.00 4660.98 2059.02
USD 2001 Table 3     210 6720.00 4660.98 2059.02
USD 2001       960 26220.00 15406.98 10813.02
USD         960 26220.00 15406.98 10813.02
(14 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)
USD 2001 Ex. 1 2001-05-16 1998-01-01 LTCG 100 3000.00 1600.00 1400.00
USD 2001 Ex. 1 2001-05-16 1999-01-01 LTCG 50 1500.00 800.00 700.00
USD 2001 Ex. 1 2001-05-16     150 4500.00 2400.00 2100.00
USD 2001 Ex. 1       150 4500.00 2400.00 2100.00
USD 2001 Ex. 2 2001-05-16 1998-01-01 LTCG 100 3000.00 1600.00 1400.00
USD 2001 Ex. 2 2001-05-16 1999-01-01 LTCG 50 1500.00 800.00 700.00
USD 2001 Ex. 2 2001-05-16     150 4500.00 2400.00 2100.00
USD 2001 Ex. 2 2001-12-15 1999-01-01 LTCG 50 1400.00 800.00 600.00
USD 2001 Ex. 2 2001-12-15     50 1400.00 800.00 600.00
USD 2001 Ex. 2       200 5900.00 3200.00 2700.00
USD 2001 Ex. 3 2001-05-16 1998-01-01 LTCG 100 3000.00 1600.00 1400.00
USD 2001 Ex. 3 2001-05-16 1999-01-01 LTCG 50 1500.00 800.00 700.00
USD 2001 Ex. 3 2001-05-16     150 4500.00 2400.00 2100.00
USD 2001 Ex. 3 2001-12-15 1999-01-01 LTCG 50 1400.00 750.00 650.00
USD 2001 Ex. 3 2001-12-15     50 1400.00 750.00 650.00
USD 2001 Ex. 3       200 5900.00 3150.00 2750.00
USD 2001 Fund S 2001-10-06 1987-07-10 5YCG 200 3200.00 1996.00 1204.00
USD 2001 Fund S 2001-10-06     200 3200.00 1996.00 1204.00
USD 2001 Fund S       200 3200.00 1996.00 1204.00
USD 2001 Table 3 2001-09-29 2000-02-04 LTCG 160 5120.00 3551.22 1568.78
USD 2001 Table 3 2001-09-29 2000-08-05 LTCG 50 1600.00 1109.76 490.24
USD 2001 Table 3 2001-09-29     210 6720.00 4660.98 2059.02
USD 2001 Table 3       210 6720.00 4660.98 2059.02
USD 2001         960 26220.00 15406.98 10813.02
USD           960 26220.00 15406.98 10813.02
(25 rows)