ar_receipts_inv_fa_sales
where rpt_id = 232727
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | inv_type | description | cost | book_value | gross_sales_price | amount_recd | rpt_id |
|---|---|---|---|---|---|---|---|
| 24 | A.G. EDWARDS & SONS | 32183 | 32183 | 70756 | 38574 | 232727 232727 |
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) );