ar_disbursements_inv_purchases

where rpt_id = 227525

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ inv_type description cost book_value cash_paid rpt_id
24   2004 Mercury Gran Marquis Automobile 26500 22525 26500 227525 227525
25   Computer-Server 3312 2705 3312 227525 227525
26   Central Processing Unit (CPU) 613 501 613 227525 227525
27   Central Processing Unit (CPU) 596 507 596 227525 227525
28   Lexmark Fax/Printer/Scanner 221 192 221 227525 227525
29   Monitor 143 122 143 227525 227525
30   Peachtree Software 730 596 730 227525 227525 
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)
);