ar_receipts_inv_fa_sales
where rpt_id = 245699
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | inv_type | description | cost | book_value | gross_sales_price | amount_recd | rpt_id |
---|---|---|---|---|---|---|---|
64 | STOCKS | 14979 | 14979 | 12936 | 12936 | 245699 245699 | |
65 | CORPORATE BONDS | 10005 | 10005 | 10000 | 10000 | 245699 245699 | |
66 | GOVERNMENT BONDS | 69302 | 69302 | 70625 | 70625 | 245699 245699 |
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) );