ris Table: Investor Settlement

Database Reference Sybase DBMS

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	char(9)	no
lse_s	Lease	char(10)	no
invo_s	Invoice number	char(8)	no
rev_count_s	Invoice reversal counter	char(3)	no
timestamp	Record modification stamp	timestamp	yes
d_last_s	Date of last update	datetime	yes
t_lup_s	Time of last update	char(6)	yes
d_due_s	Payment due date	datetime	yes
d_rev_s	Reversal date	datetime	yes
d_ear_dis_s	Earliest disbursement date Payment due date + deferral dates (d_last_s + def_days_l)	datetime	yes
d_dis_s	Disbursement date	datetime	yes
disb_bank_s	Disbursal bank account GL vector	char(3)	yes
cash_check_typ_s	Type of cashier's check	char(4)	yes
bank_s	Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased	char(3)	yes
a_pmt_c	Assumed payment (Y/N)	char(1)	yes
chk_s	Check number	char(6)	yes
chk_ref_s	Check reference	char(36)	yes
part_perc_d	Participation percentage	double precision	yes
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	double precision	yes
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	double precision	yes
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	double precision	yes
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	double precision	yes
inv_pamt_d_d	Investor participation total payment disbursed to date	double precision	yes
inv_iamt_d_d	Investor participation total interest disbursed to date	double precision	yes