ar_disbursements_inv_purchases

where rpt_id = 240415

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value cash_paid rpt_id
77   Federated 856 Prime Value money market account 440542 440542 440542 240415 240415
78   Terre Haute Savings Bank CD 2.25% due 11/1/06 100191 100191 100191 240415 240415
79   Hederal Home Loan Bank 3.37% due 11/26/07 $100,000 100000 99563 100000 240415 240415
80   Peachtree software 720 500 720 240415 240415
81   Laptop computer 1348 1101 1348 240415 240415
82   Computer 900 765 900 240415 240415
83   Laptop computer 949 839 949 240415 240415
84   Laptop computer 950 902 950 240415 240415
85   Storage shed 2620 2555 2620 240415 240415
86   Federated Govt Tax Managed ISS #637 Money Market 1199 1199 1199 240415 240415 
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)
);