ar_assets_fixed

where rpt_id = 240415

✎ View and edit SQL

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)
);