rdr Table: Deferral Reversal

Database Reference

rdr Table: Deferral Reversal

Child Tables

Name	Description
rdrp	Deferral Reversal - Orig Pmt Sched
rdrq	Deferral Reversal - New Pmt Sched

Indexes

Name	Segment 1	Segment 2
rdr_idx0	lse_s	pmt_rsc_def_s

Columns
Name	Description	Datatype ¿?	Allow Null
lse_s	Lease
pmt_rsc_def_s	Deferred payment number
	Record modification stamp
d_acc_s	Accrued to date
d_defer_pmt_s	Defer payment due date
d_rsc_def_s	Date of last payment reschedule (DEF)
d_inv_due_s	Security deposit and deferral fee due date
ym_process_s	Processing month (YYYYMM)
def_mth_l	Number of months defer
due_l	Payment due day
bank_s	Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased
dpn_sec_s	DPN key of security deposit
dpn_def_s	DPN key of deferral fee
dht_sec_s	DHT key of security deposit
dht_def_s	DHT key of deferral fee
por_s	Portfolio
com_s	Company
reg_s	Region
off_s	Office
invo_s	Invoice number
sec_cash_c	Security deposit cash received (Y/N)
def_fee_cash_c	Deferral fee cash received (Y/N)
reb_allow_c	Rebook allowed (Y/N)
p_con_d	Lessor yield
p_dly_d	Vendor yield
p_inv_yld_d	Investor yield factor
org_idc_d	Original IDC amount
add_ins_prem_d	Additional insurance premium amount
pay_down_d	Pay down amount
org_sec_d	Original security deposit
sec_d	Security deposit
def_fee_d	Deferral fee amount
res_write_down_loss_d	Residual write down loss
res_guar_d	Guaranteed portion of residual
chg_ue_d	Change in unearned amount
chg_prin_d	Change in principal amount
chg_res_ue_d	Change in residual unearned amount
dp_mly_d	Monthly rental depreciation
d_cntr_end_s	Contract end date
dpn_stax_fee_s	DPN key of STAX fee
dht_stax_fee_s	DHT key of STAX fee
stax_fee_cash_c	STAX fee cash received (Y/N)
stax_fee_d	STAX fee amount
ddr_flg_c	DDR version flag (1/2) 1 - old style 2 - new style
org_idc_asc842_d	Original IDC ASC 842 amount