ar_assets_fixed
where rpt_id = 247098
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | description | cost_basis | depreciation | book_value | value | asset_type | rpt_id |
---|---|---|---|---|---|---|---|
568 | 16 TROTTER DRIVE, MEDWAY, MA, 02053-2299 | 501561 | 0 | 501561 | 501561 | 301 | 247098 247098 |
569 | 16 TROTTER DRIVE, MEDWAY, MA, 02053-2299 | 2464012 | 191140 | 2272872 | 2272872 | 302 | 247098 247098 |
570 | Automobiles and Other Vehicles | 333148 | 130332 | 202816 | 202816 | 303 | 247098 247098 |
571 | Office Furniture and Equipment | 316814 | 195098 | 121716 | 121716 | 304 | 247098 247098 |
572 | Other Fixed Liabilities | 0 | 0 | 0 | 0 | 305 | 247098 247098 |
CREATE TABLE ar_assets_fixed ( oid INTEGER NOT NULL PRIMARY KEY, description TEXT NULL, cost_basis INTEGER NULL, depreciation INTEGER NULL, book_value INTEGER NULL, value INTEGER NULL, asset_type INTEGER NOT NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id) );