ar_payer_payee

where rpt_id = 463699

✎ 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
151 151 854015 1001 1201 N/A   N/A   00   N/A 178246 0 178246 463699 463699
152 152 854016 1002 502 N/A           N/A 27870 0 27870 463699 463699
153 153 854017 1002 503 N/A   N/A   00   N/A 6643 0 6643 463699 463699
154 154 854018 1002 504 N/A   N/A   00   N/A 54750 0 54750 463699 463699
155 155 854019 1002 505 N/A   N/A   00   N/A 410600 0 410600 463699 463699
156 156 854020 1002 505 N/A       00   N/A 107553 0 107553 463699 463699
157 157 854021 1002 505 N/A   N/A   00   N/A 99303 0 99303 463699 463699 
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)
);