ar_disbursements_inv_purchases

where rpt_id = 247098

✎ View and edit SQL

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