ar_payer_payee

where rpt_id = 247985

✎ 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
25010 25010 2144 1002 501 Tri-City Electric   415 Perry Street Davenport IA 52801 Electrical Contractor 10000 0 10000 247985 247985
25011 25011 2145 1002 501 Mac's Limited   1230 Broadway Quincy IL 62301 Electrical Contractor 10000 0 10000 247985 247985
25012 25012 2146 1002 501 Brown Electric   1309 Watts Lane Quincy IL 62301 Electrical Contractor 10000 0 10000 247985 247985
25013 25013 2147 1002 501 Labor Paper   400 NE Jefferson Peoria IL 61603 Newspaper publisher 0 10914 10914 247985 247985
25014 25014 2148 1002 501 Peoria Labor Temple   400 NE Jefferson Peoria IL 61603 Labor Association 0 12273 12273 247985 247985
25015 25015 2149 1002 502 IBEW COPE   900 7th Street NW Washington DC 20001 Issue Advocacy Group 0 12000 12000 247985 247985
25016 25016 2150 1002 504 McGladrey & Pullen, LLP   401 Main Street, Suite 1200 Peoria IL 616021242 CPA firm 9340 10910 20250 247985 247985
25017 25017 2151 1002 504 RSM McGladrey   401 Main Street, Suite 1200 Peoria IL 616021242 Accounting services firm 5640 375 6015 247985 247985
25018 25018 2152 1002 504 Wisconsin Union Labor Life Insurance P.O. Box 25512 5626 N 91st Street Milwaukee WI 53225 Insurance 7995 50 8045 247985 247985
25019 25019 2153 1002 504 Hediger & Meyers   4208 W Partridge Way Peoria IL 61615 Insurance 9185 3189 12374 247985 247985
25020 25020 2154 1002 504 SBC Communications   Bill Payment Center Saginaw MI 486630003 Telephone Service 0 6600 6600 247985 247985
25021 25021 2155 1002 504 Peoria Labor Temple   400 NE Jefferson Peoria IL 61603 Labor Association 0 6137 6137 247985 247985
25022 25022 2156 1002 505 Centerplate   201 SW Jefferson Peoria IL 61602 Caterer 12380 0 12380 247985 247985
25023 25023 2157 1002 505 Peoria Labor Temple   400 NE Jefferson Peoria IL 61603 Labor Association 0 12273 12273 247985 247985
25024 25024 2158 1002 505 Union People Products   855 N Dirksen Parkway Springfield IL 62702 Promotional Products Manufacturer 0 5831 5831 247985 247985 
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)
);