ar_receipts_inv_fa_sales
where rpt_id = 247523
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | inv_type | description | cost | book_value | gross_sales_price | amount_recd | rpt_id |
|---|---|---|---|---|---|---|---|
| 174 | AUTOMOBILE | 15000 | 2083 | 1150 | 1150 | 247523 247523 |
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) );