ar_assets_loans_rcvbl

where rpt_id = 248368

✎ 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
255 2001 UFCW Bldg. Construction Unsecured 9% 25yr monthly 1767975 1723897 0 0 44078 248368 248368
256 2001 WA State AFCME DC28 Organizing Costs Guar. By Int'l Unspecified 500000 511038 11038 0 0 248368 248368
257 2001 PA AFL-CIO RELP Mortgage Real estate prop. 5000/mo. until 07/2014 0 480862 522959 42097 0 248368 248368
258 2002 All Other Loans       0 0 0 0 0 248368 248368 
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)
);