ar_receipts_inv_fa_sales
where rpt_id = 229116
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | inv_type | description | cost | book_value | gross_sales_price | amount_recd | rpt_id |
|---|---|---|---|---|---|---|---|
| 18 | AUTOMOBILE TRADED-IN ON PURCHASE OF NEW AUTOMOBILE | 35793 | 32733 | 18000 | 0 | 229116 229116 |
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) );