ar_payer_payee
where rpt_id = 463553
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
223 | 223 | 853636 | 1001 | 1201 | HUNTINGTON HOSPITAL | HUNTINGTON | NY | 11743 | HOSPITAL | 25000 | 0 | 25000 | 463553 463553 | ||
224 | 224 | 853637 | 1001 | 1201 | UNION | OTHER RECEIPTS | 1289 | 0 | 1289 | 463553 463553 | |||||
225 | 225 | 853638 | 1001 | 1201 | MISCELLANEOUS | OTHER RECEIPTS | 38 | 0 | 38 | 463553 463553 | |||||
226 | 226 | 853639 | 1002 | 501 | JOHN E SANDS | 200 EXECUTIVE DRIVE | WEST ORANGE | NJ | 07052 | ATTORNEY | 1000 | 0 | 1000 | 463553 463553 | |
227 | 227 | 853640 | 1002 | 501 | VARIOUS | REP ACTIVITIES | 3165 | 0 | 3165 | 463553 463553 | |||||
228 | 228 | 853641 | 1002 | 501 | DAVIS & HERSH, LLP | 200 PARKWAY DRIVE SOUTH | HAUPPAUGE | NY | 11788 | ATTORNEY | 73023 | 0 | 73023 | 463553 463553 | |
229 | 229 | 853642 | 1002 | 501 | VARIOUS | ATTORNEY | 350 | 0 | 350 | 463553 463553 | |||||
230 | 230 | 853643 | 1002 | 501 | VARIOUS | REP ACTIVITIES | 4836 | 0 | 4836 | 463553 463553 | |||||
231 | 231 | 853644 | 1002 | 501 | VARIOUS | REP ACTIVITIES | 290 | 0 | 290 | 463553 463553 | |||||
232 | 232 | 853645 | 1002 | 503 | VARIOUS | CONTRIBUTIONS, GIFTS | 534 | 0 | 534 | 463553 463553 | |||||
233 | 233 | 853646 | 1002 | 504 | PETER ENGLEMANN | 345 FORT SALONGA ROAD | NORTHPORT | NY | 11768 | LANDLORD | 5960 | 0 | 5960 | 463553 463553 | |
234 | 234 | 853647 | 1002 | 504 | INTERNAL REVENUE SERVICE | GOVT AGENCY | 1986 | 0 | 1986 | 463553 463553 | |||||
235 | 235 | 853648 | 1002 | 504 | NEW YORK STATE EMPLOYMENT TAX | GOVT AGENCY | 218 | 0 | 218 | 463553 463553 | |||||
236 | 236 | 853649 | 1002 | 504 | KENNETH C DINKER & CO PC | 514 LARKFIELD RD, STE #1 | EAST NORTHPORT | NY | 11731 | ACCOUNTANT | 1410 | 0 | 1410 | 463553 463553 | |
237 | 237 | 853650 | 1002 | 504 | VARIOUS | OFFICE SUPPLY VENDOR | 2209 | 0 | 2209 | 463553 463553 | |||||
238 | 238 | 853651 | 1002 | 504 | HUNTINGTON HOSPITAL | HUNTINGTON | NY | 11743 | HOSPITAL | 3575 | 0 | 3575 | 463553 463553 | ||
239 | 239 | 853652 | 1002 | 504 | FIRST CLEARING LLC | BROKERAGE | 150 | 0 | 150 | 463553 463553 | |||||
240 | 240 | 853653 | 1002 | 504 | VARIOUS | GENERAL OVERHEAD | 300 | 0 | 300 | 463553 463553 | |||||
241 | 241 | 853654 | 1002 | 504 | VARIOUS | GENERAL OVERHEAD | 302 | 0 | 302 | 463553 463553 | |||||
242 | 242 | 853655 | 1002 | 504 | VARIOUS | GENERAL OVERHEAD | 1383 | 0 | 1383 | 463553 463553 | |||||
243 | 243 | 853656 | 1002 | 504 | VARIOUS | GENERAL OVERHEAD | 280 | 0 | 280 | 463553 463553 |
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) );