ar_receipts_inv_fa_sales

where rpt_id = 463438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value gross_sales_price amount_recd rpt_id
55343   600 SH DTE ENERGY 15157 15157 15271 15271 463438 463438
55344   1000 SH COHEN & STEERS QUALITY INCOME REALTY 14933 14933 18530 18530 463438 463438
55345   1000 SH NUVEEN QUALITY PFD INCOME FUND 15018 15018 15673 15673 463438 463438
55346   300 SH CONSUMERS ENERGY CO FIN III 7887 7887 7591 7591 463438 463438
55347   100 SH EXXON MOBIL CORP 4295 4295 4890 4890 463438 463438
55348   500 SH NEXEN INC 9.375% PFD DUE 3/31/48 12873 12873 12500 12500 463438 463438 
CREATE TABLE ar_receipts_inv_fa_sales (
oid INTEGER NOT NULL PRIMARY KEY, inv_type INTEGER NULL, description TEXT NULL, cost INTEGER NULL, book_value INTEGER NULL, gross_sales_price INTEGER NULL, amount_recd INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id)
);