ar_receipts_inv_fa_sales
where rpt_id = 247098
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | inv_type | description | cost | book_value | gross_sales_price | amount_recd | rpt_id |
---|---|---|---|---|---|---|---|
121 | AUTOMOBILES | 226555 | 92799 | 116799 | 24000 | 247098 247098 | |
122 | MUTUAL FUNDS | 0 | 0 | 49135 | 49135 | 247098 247098 |
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) );