ar_disbursements_inv_purchases

where rpt_id = 463438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value cash_paid rpt_id
112152   200 SH DTE ENERGY 8469 8469 8469 463438 463438
112153   300 SH CONSUMERS ENERGY CO FIN III 7887 7887 7887 463438 463438
112154   200 SH EXXON MOBIL CORP 8591 8591 8591 463438 463438
112155   200 SH DTE ENERGY 8.75% PR 5155 5155 5155 463438 463438
112156   100 SH STRYKER CORP 5576 5576 5576 463438 463438
112157   LORD ABBETT AFFILIATED FUND A 814 814 814 463438 463438
112158   MFS GLOBAL TOTAL RETURN FUND B 11062 11062 11062 463438 463438
112159   OPPENHEIMER STRATEGIC INCOME FUND A 5344 5344 5344 463438 463438
112160   OPPENHEIMER QUEST VALUE FUND A 1069 1069 1069 463438 463438 
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)
);