rpu Table: Payment Reschedule Reversal Asset
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpu Table: Payment Reschedule Reversal Asset

Child Tables

Name Description
rpup Payment Reschedule Reversal Asset Payment Schedule

Indexes

Name Segment 1 Segment 2 Segment 3
rpu_idx0 lse_s pmt_rsc_rsc_s unit_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
pmt_rsc_rsc_s
Payment Reschedule (RSC) number
CHAR(3) no
unit_s
Asset
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
pre_inv_c
Pre-inventory (Y/N)
CHAR(1) yes
p_con_unit_d
Asset yield
NUMBER(15,7) yes
ins_prem_diff_d
Insurance premium difference
NUMBER(15,2) yes
org_res_d
Original residual amount
NUMBER(15,2) yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
CHAR(3) yes
sec_cash_c
Security deposit cash received (Y/N)
CHAR(1) yes
p_con_d
Yield
NUMBER(15,7) yes
chg_prin_d
Change in principal amount
NUMBER(15,2) yes
chg_res_d
Change in residual amount
NUMBER(15,2) yes
chg_res_ue_d
Change in residual unearned amount
NUMBER(15,2) yes
chg_ue_d
Change in unearned amount
NUMBER(15,2) yes
dp_mly_d
Monthly rental depreciation
NUMBER(15,2) yes
l_est_ue_d
Estimated unearned
NUMBER(15,2) yes
org_idc_d
Original IDC amount
NUMBER(15,2) yes
org_sec_d
Original security deposit
NUMBER(15,2) yes
pay_down_d
Pay down amount
NUMBER(15,2) yes
rec_d
Contract receivable
NUMBER(15,2) yes
res_d
Residual amount
NUMBER(15,2) yes
res_guar_d
Guaranteed portion of residual
NUMBER(15,2) yes
res_write_down_loss_d
Residual write down loss
NUMBER(15,2) yes
org_idc_asc842_d
Original IDC ASC 842 amount
NUMBER(15,2) yes