ar_payer_payee
where rpt_id = 248398
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52743 | 52743 | 4106 | 1001 | 1201 | NORTHERN CALIFORNIA CARPENTERS REGIONAL COUNCIL | 265 HEGENBERGER RD, STE 200 | OAKLAND | CA | 94621 | REGIONAL COUNCIL | 169919 | 3005 | 172924 | 248398 248398 | |
52744 | 52744 | 4107 | 1001 | 1201 | STATE COMPENSATION INSURANCE FUND | 7854 | SAN FRANCISCO | CA | 94120 | INSURANCE | 9987 | 1230 | 11217 | 248398 248398 | |
52745 | 52745 | 4108 | 1002 | 501 | WEINBERG, ROGER & ROSENFELD | 1001 MARINA VILLAGE PKWY | ALAMEDA | CA | 94501 | ATTORNEYS AT LAW | 90741 | 13015 | 103756 | 248398 248398 | |
52746 | 52746 | 4109 | 1002 | 504 | AT & T | 78225 | PHOENIX | AZ | 85062 | TELEPHONE COMPANY | 0 | 5656 | 5656 | 248398 248398 | |
52747 | 52747 | 4110 | 1002 | 504 | CLEM'S JANITORIAL | 5145 E. LANE #119 | FRESNO | CA | 93727 | JANITORIAL SERVICE | 0 | 11040 | 11040 | 248398 248398 | |
52748 | 52748 | 4111 | 1002 | 504 | P G & E | 705 P STREET | FRESNO | CA | 93760 | UTILITIES | 0 | 11147 | 11147 | 248398 248398 | |
52749 | 52749 | 4112 | 1002 | 504 | PITNEY BOWES | 856390 | LOUISVILLE | KY | 40285 | POSTAGE | 0 | 9922 | 9922 | 248398 248398 | |
52750 | 52750 | 4113 | 1002 | 504 | NORTHERN CALIFORNIA CARPENTERS REGIONAL COUNCIL | 265 HEGENBERGER RD, STE 200 | OAKLAND | CA | 94621 | MORTGAGOR | 0 | 52591 | 52591 | 248398 248398 |
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) );