ar_assets_accts_rcvbl
where rpt_id = 227525
Download this data as a CSV Spreadsheet (All Rows)
| oid ▼ | acct_type | name | past_due_90 | past_due_180 | liquidated | total | rpt_id |
|---|---|---|---|---|---|---|---|
| 16 | 101 | None | 0 | 0 | 0 | 0 | 227525 227525 |
| 17 | 102 | All Other Accounts | 0 | 0 | 0 | 0 | 227525 227525 |
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) );