ar_disbursements_inv_purchases
where rpt_id = 247098
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | inv_type | description | cost | book_value | cash_paid | rpt_id |
---|---|---|---|---|---|---|
335 | MUTUAL FUNDS | 116094 | 116094 | 116094 | 247098 247098 | |
336 | AUTOMOBILES | 176612 | 176612 | 96287 | 247098 247098 | |
337 | FURNITURE | 2061 | 2061 | 2061 | 247098 247098 | |
338 | OFFICE EQUIPMENT | 14641 | 14641 | 14641 | 247098 247098 | |
339 | BUILDING IMPROVEMENTS | 6242 | 6242 | 6242 | 247098 247098 |
CREATE TABLE ar_disbursements_inv_purchases ( oid INTEGER NOT NULL PRIMARY KEY, inv_type INTEGER NULL, description TEXT NULL, cost INTEGER NULL, book_value INTEGER NULL, cash_paid INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id) );