ar_receipts_inv_fa_sales

where rpt_id = 245699

✎ 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
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)
);