LeasePak 5.1a Database Reference (Sybase)

rrr Table: Reschedule Reversal

Description	Column	Datatype
Lease	lse_s	char (10)
Payment Reschedule (RSC) number	pmt_rsc_rsc_s	char (3)
Sybase timestamp	timestamp	timestamp
Accrued to date	d_acc_s	datetime
Date of last payment reschedule (RSC)	d_rsc_rsc_s	datetime
Security deposit and deferral fee due date	d_inv_due_s	datetime
Maturity date	d_mat_s	datetime
Turn-in date	d_turn_in_s	datetime
Final payment due date	d_final_pmt_s	datetime
Payment due day	due_l	integer
Bank account G/L vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased.	bank_s	char (3)
DPN key of security deposit	dpn_sec_s	char (24)
DHT key of security deposit	dht_sec_s	char (24)
Portfolio	por_s	char (2)
Company	com_s	char (2)
Region	reg_s	char (2)
Office	off_s	char (3)
Invoice number	invo_s	char (8)
Accrual method lessor	acc_l_s	char (4)
Accrual method vendor	acc_d_s	char (4)
Accrual method investor	acc_i_s	char (4)
DPC key of principal change	dpc_prin_chng_s	char (28)
Security deposit cash received (Y/N)	sec_cash_c	char (1)
Rebook allowed (Y/N)	reb_allow_c	char (1)
Lease term	trm_l	integer
Lessor yield	p_con_d	double precision
Vendor yield	p_dly_d	double precision
Investor yield factor	p_inv_yld_d	double precision
Original IDC amount	org_idc_d	double precision
Additional insurance premium amount	add_ins_prem_d	double precision
Pay down amount	pay_down_d	double precision
Original security deposit	org_sec_d	double precision
Security deposit	sec_d	double precision
Residual write down loss	res_write_down_loss_d	double precision
Guaranteed portion of residual	res_guar_d	double precision
Change in unearned amount	chg_ue_d	double precision
Change in principal amount	chg_prin_d	double precision
Change in residual unearned amount	chg_res_ue_d	double precision
Monthly rental depreciation	dp_mly_d	double precision
Estimated unearned	l_est_ue_d	double precision
Residual amount	res_d	double precision
Contract receivable	rec_d	double precision
Vendor receivable	dlr_rec_d	double precision
Change in residual amount	chg_res_d	double precision

rrr Indexes:

Index name	Piece 1	Piece 2
rrr_idx0	lse_s	pmt_rsc_rsc_s

rrr Child Tables:

Table	Description
rrrp	Reschedule Reversal - Orig Pmt Sched
rrrq	Reschedule Reversal - New Pmt Sched

Home • Table • Indexes • Children