ar_assets_loans_rcvbl

where rpt_id = 248420

✎ 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
263 2001 VINCENT GUERTIN EXPENSE ACCT ADVANCE NONE ON DEMAND 1500 1500 0 0 0 248420 248420
264 2001 RAYMOND TURNER EXPENSE ACCT ADVANCE NONE ON DEMAND 1500 1500 0 0 0 248420 248420
265 2001 RICHARD OAKES EXPENSE ACCT ADVANCE NONE ON DEMAND 1500 1500 0 0 0 248420 248420
266 2001 MARK KAUFMAN EXPENSE ACCT ADVANCE NONE ON DEMAND 1500 1500 0 0 0 248420 248420
267 2001 GARY THOMFORDE EXPENSE ACCT ADVANCE NONE ON DEMAND 1500 1500 0 0 0 248420 248420
268 2001 STEVE MURPHY EXPENSE ACCT ADVANCE NONE ON DEMAND 0 0 1500 1500 0 248420 248420
269 2002 All Other Loans       0 0 0 0 0 248420 248420 
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)
);