ar_assets_fixed
where rpt_id = 248186
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | description | cost_basis | depreciation | book_value | value | asset_type | rpt_id |
|---|---|---|---|---|---|---|---|
| 1198 | 319 N. CHURCH ST., VISALIA, CA | 28313 | 0 | 28313 | 28313 | 301 | 248186 248186 |
| 1199 | 319 N. CHURCH ST., VISALIA, CA | 5534 | 4729 | 805 | 805 | 302 | 248186 248186 |
| 1200 | Automobiles and Other Vehicles | 0 | 0 | 0 | 0 | 303 | 248186 248186 |
| 1201 | Office Furniture and Equipment | 53803 | 42517 | 11286 | 11286 | 304 | 248186 248186 |
| 1202 | Other Fixed Liabilities | 0 | 0 | 0 | 0 | 305 | 248186 248186 |
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) );