ar_disbursements_inv_purchases

where rpt_id = 247985

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value cash_paid rpt_id
591   100 SHS ISHARES TRUST LEHMAN TIPS BOND FUND 10440 10440 10440 247985 247985
592   100 SHS ISHARES LEHMAN 20+ YEAR TREAS BOND FUND 8879 8879 8879 247985 247985
593   400 SHS BELLSOUTH CORP 10788 10788 10788 247985 247985
594   100 SHS PEPSICO INC 4833 4833 4833 247985 247985
595   200 SHS PEPSICO 10066 10066 10066 247985 247985
596   200 SHS 3M COMPANY 15998 15998 15998 247985 247985
597   250 SHS ISHARES TRUST LEHMAN TIPS BOND FUND 26120 26120 26120 247985 247985
598   300 SHS ISHARES LEHMAN 20+ YEAR TREAS BOND FUND 26373 26373 26373 247985 247985
599   100 SHS EBAY INC 8149 8149 8149 247985 247985
600   SB MONEY FUNDS 242433 242433 242433 247985 247985
601   2004 Buick Century Limited 17176 17176 17176 247985 247985
602   Printer & Cable-Galesburg 216 216 216 247985 247985
603   Luster Software-Web signing 2000 2000 2000 247985 247985
604   2005 Ford Escape 19805 19805 19805 247985 247985
605   Screen Monitor 155 155 155 247985 247985
606   2005 Ford 500 21507 21507 21507 247985 247985
607   Dell Computer 922 922 922 247985 247985
608   2 Electric Water Heaters 504 504 504 247985 247985
609   902.205 SHS VANGUARD BALANCED INDEX FUND ADMIRAL 17170 17170 17170 247985 247985
610   358.032 SHS DODGE & COX BALANCED FUND 28087 28087 28087 247985 247985
611   100 SHS CENTRAL ILLINOIS ENERGY, LLC PREFERRED 100000 100000 100000 247985 247985 
CREATE TABLE ar_disbursements_inv_purchases (
oid INTEGER NOT NULL PRIMARY KEY, inv_type INTEGER NULL, description TEXT NULL, cost INTEGER NULL, book_value INTEGER NULL, cash_paid INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id)
);