ar_disbursements_inv_purchases

where rpt_id = 247892

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value cash_paid rpt_id
530   2004 BUICK CENTURY 26347 18623 18847 247892 247892
531   DIGITAL CAMERA & ACCESSORIES 574 456 574 247892 247892
532   FAX MACHINE 823 796 823 247892 247892
533   TELEPHONE SYSTEM 6691 6611 6691 247892 247892
534   AMERICAN BALANCED FUND CLASS A MUTUAL FUND 30000 30206 30000 247892 247892 
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)
);