ar_payer_payee
where rpt_id = 240415
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) );