ar_payer_payee

where rpt_id = 248420

✎ 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
64631 64631 4200 1001 1201 IBEW LOCAL 2047   12908 NICOLLET AVENUE BURNSVILLE MN 55337 LABOR UNION 116111 1196 117307 248420 248420
64632 64632 4201 1001 1201 IBEW   500 7TH ST NW WASHINGTON DC 20001 PARENT ORGANIZATION 5000 0 5000 248420 248420
64633 64633 4202 1001 1201 MN IBEW STATE COUNCIL   2522 MARSHALL ST NE MINNEAPOLIS MN 55418 AFFILIATED ORGANIZATION 11140 3142 14282 248420 248420
64634 64634 4203 1002 501 METCALF, KASPARI, HOWARD, ENGDAHL & LAZARU   333 PARKDALE PLAZA MINNEAPOLIS MN 55416 LAW FIRM 0 15910 15910 248420 248420
64635 64635 4204 1002 501 HOLIDAY INN   450 MAIN STREET DUBUQUE IA 52001 HOTEL 0 7713 7713 248420 248420
64636 64636 4205 1002 504 AUTO OWNERS INSURANCE P. O. BOX 30315   LANSING MI 48909 AUTO INSURANCE COMPANY 0 7543 7543 248420 248420
64637 64637 4206 1002 504 PURCHASE POWER P. O. BOX 856042   LOUISVILLE KY 40285 POSTAGE PROVIDER 0 7020 7020 248420 248420
64638 64638 4207 1002 504 INNOVATIVE OFFICE SOLUTIONS P. O. BOX 1575   MINNEAPOLIS MN 55480 OFFICE SUPPLY COMPANY 0 6119 6119 248420 248420
64639 64639 4208 1002 504 INTEGRA TELECOM OF MN INC. P. O. BOX 299   PRIOR LAKE MN 55372 TELEPHONE COMPANY 0 5844 5844 248420 248420
64640 64640 4209 1002 505 LEGACY PROFESSIONALS LLP   4930 WEST 77TH ST. STE 360 EDINA MN 55435 PUBLIC ACCOUNTING FIRM 0 7600 7600 248420 248420
64641 64641 4210 1002 505 RUTTGER'S BAY LAKE LODGE   25039 TAME FISH LAKE DEERWOOD MN 56444 HOTEL/LODGE 5485 288 5773 248420 248420 
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)
);