ar_assets_accts_rcvbl
where rpt_id = 247835
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | acct_type | name | past_due_90 | past_due_180 | liquidated | total | rpt_id |
|---|---|---|---|---|---|---|---|
| 211 | 101 | MEMBERSHIP DUES | 2658 | 810 | 0 | 4278 | 247835 247835 |
| 212 | 102 | All Other Accounts | 0 | 0 | 0 | 0 | 247835 247835 |
CREATE TABLE ar_assets_accts_rcvbl ( oid INTEGER NOT NULL PRIMARY KEY, acct_type INTEGER NOT NULL, name TEXT NULL, past_due_90 INTEGER NULL, past_due_180 INTEGER NULL, liquidated INTEGER NULL, total INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id) );