ar_disbursements_inv_purchases

where rpt_id = 248168

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value cash_paid rpt_id
721   United States Government Agency 11244 11244 11244 248168 248168
722   Common Stock 338794 338794 338794 248168 248168
723   Corporate Bonds 697411 697411 697411 248168 248168
724   Furniture and Fixtures 12401 12401 12401 248168 248168
725   Automobiles (16) 418569 418569 418569 248168 248168
726   Leaseholds 5000 5000 5000 248168 248168 
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)
);