ar_receipts_other

where rpt_id = 248438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ receipt_type purpose date amount payer_payee_id rpt_id
1216 1201 SUBSISTENCE 2004-08-31 10000 4219 248438 248438
1217 1201 SUBSISTENCE 2004-09-30 10000 4219 248438 248438
1218 1201 SUBSISTENCE 2004-10-31 10000 4219 248438 248438
1219 1201 SUBSISTENCE 2004-11-30 5000 4219 248438 248438
1220 1201 SUBSISTENCE 2004-12-31 5000 4219 248438 248438
1221 1201 SUBSISTENCE 2005-01-31 5000 4219 248438 248438
1222 1201 SUBSISTENCE 2005-02-28 10000 4219 248438 248438
1223 1201 SUBSISTENCE 2005-03-31 10000 4219 248438 248438
1224 1201 SUBSISTENCE 2005-04-30 10000 4220 248438 248438
1225 1201 SUBSISTENCE 2005-05-31 10000 4220 248438 248438
1226 1201 SUBSISTENCE 2005-06-30 10000 4220 248438 248438 
CREATE TABLE ar_receipts_other (
oid INTEGER NOT NULL PRIMARY KEY, receipt_type INTEGER NOT NULL, purpose TEXT NULL, date TEXT NULL, amount INTEGER NULL, payer_payee_id INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id)
);