ar_assets_fixed
where rpt_id = 240415
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | description | cost_basis | depreciation | book_value | value | asset_type | rpt_id |
---|---|---|---|---|---|---|---|
152 | 6501 U.S. Highway 41 S. Terre Haute, IN | 85205 | 0 | 85205 | 85205 | 301 | 240415 240415 |
153 | 616 South Oakwood Street, Oakwood, IL | 5500 | 0 | 5500 | 5500 | 301 | 240415 240415 |
154 | 6501 U.S. Highway 41 S. Tere Haute, IN | 496977 | 399472 | 97505 | 200000 | 302 | 240415 240415 |
155 | 616 S. Oakwood St. Oakwood, IL | 50250 | 22249 | 28001 | 40000 | 302 | 240415 240415 |
156 | 1602 Main Street Vincennes, IN | 51882 | 26385 | 25497 | 35000 | 302 | 240415 240415 |
157 | Automobiles and Other Vehicles | 2000 | 567 | 1433 | 2000 | 303 | 240415 240415 |
158 | Office Furniture and Equipment | 319420 | 238353 | 81067 | 81067 | 304 | 240415 240415 |
159 | Other Fixed Liabilities | 0 | 0 | 0 | 0 | 305 | 240415 240415 |
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) );