ris Table: Investor Settlement

Database Reference

ris Table: Investor Settlement

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4
ris_idx0	inv_s	lse_s	invo_s	rev_count_s
ris_idx1	lse_s	invo_s	inv_s	rev_count_s

Columns
Name	Description	Datatype ¿?	Allow Null
inv_s	Investor
lse_s	Lease
invo_s	Invoice number
rev_count_s	Invoice reversal counter
	Record modification stamp
d_last_s	Date of last update
t_lup_s	Time of last update
d_due_s	Payment due date
d_rev_s	Reversal date
d_ear_dis_s	Earliest disbursement date Payment due date + deferral dates (d_last_s + def_days_l)
d_dis_s	Disbursement date
disb_bank_s	Disbursal bank account GL vector
cash_check_typ_s	Type of cashier's check
bank_s	Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased
a_pmt_c	Assumed payment (Y/N)
chk_s	Check number
chk_ref_s	Check reference
part_perc_d	Participation percentage
inv_pamt_b_d	Investor participation total expected payment to be received Invoice total (payment amount + interest amount) billed times the investor participation percent (rar.pamt_b_d + rar.iamt_b_d) * ris.part_perc_l
inv_iamt_b_d	Investor participation total expected interest to be received Invoice total interest amount billed times the investor participation percent rar.iamt_b_d * ris.part_perc_l
inv_pamt_c_d	Investor participation total payment collected to date Invoice total (payment amount + interest amount) paid times the investor participation percent (rar.pamt_p_d + rar.iamt_p_d) * ris.part_perc_l
inv_iamt_c_d	Investor participation total interest collected to date Invoice total interest amount paid times the investor participation percent rar.iamt_p_d * ris.part_perc_l
inv_pamt_d_d	Investor participation total payment disbursed to date
inv_iamt_d_d	Investor participation total interest disbursed to date