ar_assets_fixed
where rpt_id = 248420
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | description | cost_basis | depreciation | book_value | value | asset_type | rpt_id |
|---|---|---|---|---|---|---|---|
| 1463 | 12908 NICOLLET AVE BURNSVILLE, MN | 25030 | 0 | 25030 | 33250 | 301 | 248420 248420 |
| 1464 | 12908 NICOLLET AVE BURNSVILLE, MN | 148171 | 101603 | 46568 | 204250 | 302 | 248420 248420 |
| 1465 | Automobiles and Other Vehicles | 87462 | 34739 | 52725 | 52723 | 303 | 248420 248420 |
| 1466 | Office Furniture and Equipment | 70533 | 39831 | 30702 | 30702 | 304 | 248420 248420 |
| 1467 | Other Fixed Liabilities | 28506 | 3671 | 24835 | 24835 | 305 | 248420 248420 |
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) );