ar_disbursements_inv_purchases
where rpt_id = 228896
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | inv_type | description | cost | book_value | cash_paid | rpt_id |
---|---|---|---|---|---|---|
42 | US TREASURY AND AGENCY OBLIGATIONS | 53801 | 53801 | 53801 | 228896 228896 | |
43 | MARKETABLE SECURITIES | 246807 | 246807 | 246807 | 228896 228896 | |
44 | (2) 2004 BUICK LESABRES | 32071 | 32071 | 32071 | 228896 228896 | |
45 | COMPUTER SYSTEM | 4186 | 4186 | 4186 | 228896 228896 |
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) );