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