ar_payer_payee

where rpt_id = 240415

✎ 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
397 397 363 1002 501 The Vernon Company     Newton IA 502082065 Advertising-hats 8283 0 8283 240415 240415
398 398 358 1002 501 American Express P.O. Box 650448   Dallas TX 752650448 Credit card company meals, gas, travel, meeting 0 9850 9850 240415 240415
399 399 359 1002 501 Farley Printing   1735 Loney Lane Louisville KY 40216 Printing company 0 15607 15607 240415 240415
400 400 360 1002 501 McGraw Hill Construction   7625 Collection Center Driv Chicago IL 606930076 Publishing company-Dodge report subscription 5808 0 5808 240415 240415
401 401 361 1002 501 Sackrider & Company, Inc. P.O. Box 330 1925 Wabash Avenue Terre Haute IN 478080330 Certified Public Accounting firm 5880 13204 19084 240415 240415
402 402 362 1002 501 United States Postal Service P.O. Box 0527   Carol Stream IL 601320527 Postal service 0 6000 6000 240415 240415
403 403 364 1002 501 Verizon North P.O. Box 920041   Dallas TX 753920041 Telephone service provider 0 7088 7088 240415 240415
404 404 365 1002 501 Verizon Wireless P.O. Box 790406   St. Louis MO 631790406 telecommunications company 0 12967 12967 240415 240415
405 405 366 1002 501 VISA-FFB, N.A. P.O. Box 77042   Madison WI 537071042 Credit card company-no single purchase >5000 0 69984 69984 240415 240415
406 406 367 1002 503 Illinois State Council P.O. Box 3025   Springfield IL 62708 Association and advertising 0 6000 6000 240415 240415
407 407 368 1002 504 CDK Refrigeration and Electric, Inc.   2731 Old Ramney Road Lafayette IN 47909 Heating, airconditioning and electrical contractor 9634 3265 12899 240415 240415
408 408 369 1002 504 Cinergy/PSI P.O. Box 740399   Cincinnati OH 452740399 Utility company 0 14329 14329 240415 240415
409 409 370 1002 504 Clay Ladd, Inc. P.O. Box 778   Terre Haute IN 47808 Insurance agency 6294 0 6294 240415 240415
410 410 371 1002 504 Liberty Mutual Insurance Group   75 Remittance Dr Suite 1837 Chicago IL 606751837 Insurance company 5363 9094 14457 240415 240415
411 411 372 1002 504 North Star Computer Consultant, Inc. P.O. Box 5246   Terre Haute IN 478050246 Computer programming and computer services 0 11097 11097 240415 240415
412 412 373 1002 504 VISA-FFB, N.A. P.O. Box 77042   Madison WI 537071042 Credit card company, no single disbursement >5000 0 6821 6821 240415 240415
413 413 374 1002 505 Phoenix Promotional Products, Inc. P.O. Box 636   Red Oak IA 51566 Advertising merchandise company 15417 3323 18740 240415 240415
414 414 375 1002 505 VISA-FFB, N.A. P.O. Box 77042   Madison WI 537071042 Credit card company-no single disbursement >5000 0 20517 20517 240415 240415 
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)
);