ar_assets_fixed
where rpt_id = 229116
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | description | cost_basis | depreciation | book_value | value | asset_type | rpt_id |
|---|---|---|---|---|---|---|---|
| 88 | 0 | 0 | 0 | 0 | 302 | 229116 229116 | |
| 89 | Automobiles and Other Vehicles | 38129 | 1270 | 36859 | 34000 | 303 | 229116 229116 |
| 90 | Office Furniture and Equipment | 3411 | 3141 | 270 | 250 | 304 | 229116 229116 |
| 91 | Other Fixed Liabilities | 0 | 0 | 0 | 0 | 305 | 229116 229116 |
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) );