ar_payer_payee

where rpt_id = 245699

✎ View and edit SQL

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)
);