ar_receipts_inv_fa_sales

where rpt_id = 247098

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