ar_receipts_inv_fa_sales

where rpt_id = 247985

✎ 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
244   400 SHS JOHNSON & JOHNSON 21464 21464 22560 22560 247985 247985
245   300 SHS GILLETTE CO 9483 9483 11670 11670 247985 247985
246   6 SHS GE CALL 0 0 990 990 247985 247985
247   2 SHS 3M COMPANY CALL MNZ 0 0 510 510 247985 247985
248   200 SHS AMERICAN INTL GROUP INC 14790 14790 14800 14800 247985 247985
249   MOTOROLA INC BONDS 9045 9045 9550 9550 247985 247985
250   5 SHS WYE JUL 04 0 0 575 575 247985 247985
251   TYCO INTL LTD 10956 10956 18660 18660 247985 247985
252   WALGREEN CO 11508 11508 14760 14760 247985 247985
253   3 SHS CYQ JUL 04 0 0 435 435 247985 247985
254   CALL CAH SEP 04 CARDINAL HEALTH INC 0 0 860 860 247985 247985
255   3 SHS CALL YAA JAN 05 0 0 1740 1740 247985 247985
256   UTS VAN KAMPEN FOCUS PORTFOLIO 1571 1571 2419 2419 247985 247985
257   2 SHS XBA APR 05 0 0 275 275 247985 247985
258   200 SHS BIOGEN IDEC INC 11517 11517 13480 13480 247985 247985
259   800 SHS QUALCOMM INC 23951 23951 28599 28599 247985 247985
260   SB MONEY FUNDS 276633 276633 276633 276633 247985 247985 
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)
);