ar_assets_fixed
where rpt_id = 232727
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | description | cost_basis | depreciation | book_value | value | asset_type | rpt_id |
---|---|---|---|---|---|---|---|
120 | Automobiles and Other Vehicles | 23562 | 23562 | 0 | 3500 | 303 | 232727 232727 |
121 | Office Furniture and Equipment | 29506 | 23651 | 5855 | 3000 | 304 | 232727 232727 |
122 | Other Fixed Liabilities | 0 | 0 | 0 | 0 | 305 | 232727 232727 |
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) );