ar_assets_loans_rcvbl

where rpt_id = 247835

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

oid ▼ loan_type name purpose security terms outstanding_start_amt outstanding_end_amt new_loan_amt cash_repayments non_cash_repayments rpt_id
58 2001 PETER DRISCOLL ADVANCED EXPENSE NONE ASAP 1208 1208 0 0 0 247835 247835
59 2001 CERI ADAMS ADVANCED EXPENSE NONE ASAP 4343 4343 0 0 0 247835 247835
60 2002 All Other Loans       0 0 0 0 0 247835 247835 
CREATE TABLE ar_assets_loans_rcvbl (
oid INTEGER NOT NULL PRIMARY KEY, loan_type INTEGER NULL, name TEXT NULL, purpose TEXT NULL, security TEXT NULL, terms TEXT NULL, outstanding_start_amt INTEGER NULL, outstanding_end_amt INTEGER NULL, new_loan_amt INTEGER NULL, cash_repayments INTEGER NULL, non_cash_repayments INTEGER NULL, rpt_id INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id)
);