ar_payer_payee
where rpt_id = 245699
Download this data as a CSV Spreadsheet (All Rows)
Link | rowid ▼ | payer_payee_id | payer_payee_type | rcpt_disb_type | name | po_box | street | city | state | zip | type_or_class | itemized | non_itemized | total | rpt_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49410 | 49410 | 873 | 1001 | 1201 | MID-CENTRAL IL REGIONAL COUNCIL OF CARPENTERS | #1 KALMIA WAY | SPRINGFIELD | IL | 62702 | CARPENTERS REGIONAL COUNCIL | 10000 | 2342 | 12342 | 245699 245699 | |
49411 | 49411 | 874 | 1002 | 501 | AMEREN CILCO | 66826 | ST. LOUIS | MO | 63166 | UTILITY COMPANY | 0 | 5478 | 5478 | 245699 245699 | |
49412 | 49412 | 875 | 1002 | 501 | WMBD RADIO/JMP MEDIA LLC | 9050 | PEORIA | IL | 61612 | RADIO STATION | 0 | 8568 | 8568 | 245699 245699 | |
49413 | 49413 | 876 | 1002 | 503 | ILLINOIS CENTRAL COLLEGE EDUCATIONAL FOUNDATION | 1 COLLEGE DRIVE | EAST PEORIA | IL | 61635 | JUNIOR COLLEGE | 7500 | 150 | 7650 | 245699 245699 | |
49414 | 49414 | 877 | 1002 | 505 | HOLIDAY INN CITY CENTRE | 500 HAMILTON BLVD. | PEORIA | IL | 61602 | HOTEL | 8869 | 500 | 9369 | 245699 245699 |
CREATE TABLE ar_payer_payee ( payer_payee_id INTEGER NOT NULL, payer_payee_type INTEGER NOT NULL, rcpt_disb_type INTEGER NOT NULL, name TEXT NULL, po_box TEXT NULL, street TEXT NULL, city TEXT NULL, state TEXT NULL, zip TEXT NULL, type_or_class TEXT NULL, itemized INTEGER NULL, non_itemized INTEGER NULL, total INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id) );