ar_payer_payee

where rpt_id = 247838

✎ 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
48724 48724 1954 1001 1201 NATIONAL GENERAL INS.CO P O BOX 66937   ST LOUIS MO 631666937 INSURANCE COMPANY 54882 0 54882 247838 247838
48725 48725 1955 1001 1201 NATL RURAL LETTER CARR ASSOC.   1630 DUKE ST ALEXANDRIA VA 223143465 NATIONAL UNION 17868 0 17868 247838 247838
48726 48726 1956 1002 504 BARON-BUTLER GRAPHICS   62 PIONEER STREET COOPERSTOWN NY 13326 PRINTER 13928 0 13928 247838 247838
48727 48727 1957 1002 504 USPS-POSTMASTER-COOPERSTOWN   40 MAIN ST COOPERSTOWN NY 133269998 POSTAGE/POST OFFICE 5084 0 5084 247838 247838 
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)
);