ar_disbursements_inv_purchases
where rpt_id = 247835
Download this data as a CSV Spreadsheet (All Rows)
oid ▼ | inv_type | description | cost | book_value | cash_paid | rpt_id |
---|---|---|---|---|---|---|
489 | TWO PACKS OF MICROPHONE SYSTEM | 1063 | 1063 | 1063 | 247835 247835 | |
490 | BINDING MACHINE | 170 | 170 | 170 | 247835 247835 | |
491 | FOLDING TABLE | 179 | 179 | 179 | 247835 247835 | |
492 | CHAIRS | 256 | 256 | 256 | 247835 247835 |
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) );