ar_assets_accts_rcvbl
where rpt_id = 229128
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | acct_type | name | past_due_90 | past_due_180 | liquidated | total | rpt_id |
|---|---|---|---|---|---|---|---|
| 37 | 101 | AFSCME Local 552 | 135 | 115 | 0 | 7869 | 229128 229128 |
| 38 | 102 | All Other Accounts | 26835 | 2006 | 0 | 191688 | 229128 229128 |
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) );