rrr Table: Reschedule Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rrr Table: Reschedule Reversal

Child Tables

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

Indexes

Name Segment 1 Segment 2
rrr_idx0 lse_s pmt_rsc_rsc_s

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