rhf Table: Historical Lease for Accrual/Billing Cycle Change/Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rhf Table: Historical Lease for Accrual/Billing Cycle Change/Reversal

Child Tables

Name Description
rhfa Historical Lease 2 for Accrual/Billing Cycle Change/Reversal
rhfb Historical Lease 3 for Accrual/Billing Cycle Change/Reversal
rhfc Historical Lease Partial Deduction for Accrual/Billing Cycle Change/Reversal
rhfd Historical Lease 4 for Accrual/Billing Cycle Change/Reversal
rhfp Historical Lease Payment Schedule for Accrual/Billing Cycle Change/Reversal
rhfr Historical Lease Recurring Charge for Accrual/Billing Cycle Change/Reversal
rhfs Historical Lease Salesperson for Accrual/Billing Cycle Change/Reversal
rhfv Historical Lease Subvention for Accrual/Billing Cycle Change/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3
rhf_idx0 lse_s ext_num_s cycle_num_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
ext_num_s
Extension
CHAR(2) no
cycle_num_s
Accrual/billing cycle change number in a given lease period
  The first lease period is from book lease to maturity.
  Each subsequent lease extension (if any) represents a
  new and separate lease period.
CHAR(2) no
lse_s
Lease
CHAR(10) no
stamp_l
Record modification stamp
NUMBER(10) no
por_s
Portfolio
CHAR(2) yes
com_s
Company
CHAR(2) yes
reg_s
Region
CHAR(2) yes
off_s
Office
CHAR(3) yes
dlr_s
Vendor
CHAR(9) yes
brk_s
Broker
CHAR(9) yes
inv_s
Investor
CHAR(9) yes
les_s
Lessee number
CHAR(9) yes
dles_s
Delinquent lessee
  Note: this field contains the lessee number if the
  lease is delinquent and is blank if the lease is
  not delinquent
CHAR(9) yes
d_lsd_s
Lease date
DATE yes
d_com_s
Lease commencement date used for calculations
DATE yes
d_boo_s
System booking date
DATE yes
d_dis_s
Disbursement date
DATE yes
d_mat_s
Maturity date
DATE yes
d_lup_s
Date of last update
DATE yes
t_lup_s
Time of last update
CHAR(6) yes
d_act_s
Activity status date
DATE yes
d_pmt_s
Next payment due date
DATE yes
d_acc_s
Accrued to date
DATE yes
d_pay_s
Last payment date
DATE yes
d_lst_s
Last payment due date
DATE yes
d_reb_s
Last rebook date
DATE yes
d_ass_s
Assumed lease date
DATE yes
d_pxt_s
Payment extension date
DATE yes
d_fxt_s
Date of first payment extension
DATE yes
d_lxt_s
Lease extension date
DATE yes
d_cus1_s
Custom date 1
DATE yes
d_susp_pmt_s
First payment on suspension
DATE yes
d_susp_on_s
Date placed on suspension/non-accrual
DATE yes
d_susp_eff_s
Effective date of suspension/non-accrual
DATE yes
d_eff_s
Effective date of last payment
DATE yes
t_boo_s
System booking time
CHAR(6) yes
d_doc_comp_s
Documentation completion date
DATE yes
d_lcus_s
Date custom outstanding last updated
  For use only by collection module
DATE yes
ym_acct_s
Accounting month time stamp (YYYYMM)
  This field contains a portion of ras.next_mth_s
CHAR(6) yes
d_expiry_date_s
Expiry date
DATE yes
d_pap_eff_s
PAP effective date
DATE yes
act_s
Activity status
CHAR(4) 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
dir_s
Lease source
CHAR(4) yes
frm_s
Lease form code
CHAR(4) yes
del_s
Delinquency watch code
CHAR(4) yes
brk_pay_s
Broker payment code
CHAR(4) yes
late_s
Late charge assess
CHAR(4) yes
ls_typ_s
Lease type code
CHAR(4) yes
ext_s
Extension method
CHAR(4) yes
c_cus1_s
Custom code 1
CHAR(4) yes
c_cus2_s
Custom code 2
CHAR(4) yes
c_cus3_s
Custom code 3
CHAR(4) yes
po_meth_s
Purchase option billing method
CHAR(4) yes
pur_opt_s
Purchase option
CHAR(4) yes
pur_opt_owner_s
Purchase option owner
CHAR(4) yes
ml_optn_s
Maturing lease termination option
CHAR(4) yes
prim_num_s
Prime rate bank number
CHAR(4) yes
lat_ind_s
Late charge index
CHAR(4) yes
prd_s
Product type code
CHAR(4) yes
bus_c
Business/personal (B/P)
CHAR(1) yes
opn_c
Type of lease, open or closed (O/C)
CHAR(1) yes
due_lst_c
Payment due last accrual (Y/N)
CHAR(1) yes
acc_by_c
Re-accrue income for last period (Y/N)
CHAR(1) yes
a_pmt_c
Assumed payment (Y/N)
CHAR(1) yes
pre_brd_c
Backdated new lease (Y/N)
CHAR(1) yes
reb_allow_c
Rebook allowed (Y/N)
CHAR(1) yes
lse_ext_c
Lease extended (Y/N)
CHAR(1) yes
res_inc_c
Residual income separated (Y/N)
CHAR(1) yes
po_bill_c
Purchase option billed (Y/N)
CHAR(1) yes
partial_deductions_c
Lease booked using partial deductions module (Y/N)
CHAR(1) yes
b_lvl_c
Billing level (C/L/I)
  C - Customer
  L - Lessee
  I - Individual
CHAR(1) yes
stmt_c
Statement code (I/C/F/N/' ')
  I - individual invoice format
  C - coupon books
  F - group invoice format
  N - billing method outside of LeasePak
CHAR(1) yes
acc_ltch_c
Late charges assessed since last accrual
  A - Accrued, allow assessment of late charges
  L - Late charges assessed, disallow further late charges
  E - Preaccrued, enable assessment of late charges for
      prior period
  D - Preaccrued, disable further late charges for
      prior period
CHAR(1) yes
pap_pmt_c
PAP-ACH option (Y/N/1/2/3)
  Y - PAP-ACH is on. Rules are based upon U0212 Current
      Payment Only setting.
  N - PAP-ACH is off.
  1 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'Y' of the U0212 Current
      Payment Only setting.
  2 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'N' of the U0212 Current
      Payment Only setting.
  3 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'O' of the U0212 Current
      Payment Only setting.
CHAR(1) yes
auto_charge_c
Automatic charge off (Y/N/D)
  Y - Lease will be automatically charged off after
      delinquent for more than 120 days.
  N - No automatic charge off.
  D - Lease will defer charge off for 1 month.
CHAR(1) yes
ext_incm_ca_c
Cash/accrual basis for extension income (C/A)
CHAR(1) yes
susp_idc_allowed_c
Suspended IDC accrued allowed (Y/N)
CHAR(1) yes
desc_s
General description
VARCHAR2(36) yes
s_cus2_s
Custom string 2
CHAR(10) yes
trd_desc_s
Trade-in description
VARCHAR2(36) yes
ini_mcur_s
Clerk when removed from Matured Lease tracking
CHAR(3) yes
cus_s
Customer number
CHAR(9) yes
grp_s
Group number
CHAR(3) yes
prev_grp_s
Previous lease in group
CHAR(10) yes
next_grp_s
Next lease in group
CHAR(10) yes
note_s
Note attached to lease
CHAR(10) yes
index_pntr_s
Index pointer (Cost of Funds)
CHAR(4) yes
disc_invst_s
Investor/investor group of discounted lease
CHAR(9) yes
buyout_quote_l
Number of lease buyout quotes
NUMBER(10) yes
invst_defr_l
Investor settlement deferral days
NUMBER(10) yes
trm_l
Lease term
NUMBER(10) yes
est_trm_l
Estimated lease term
NUMBER(10) yes
pmt_l
Number of payments accrued
NUMBER(10) yes
n_unt_l
Number of assets on this lease
NUMBER(10) yes
del1_l
Number of times delinquent [1]
NUMBER(10) yes
del2_l
Number of times delinquent [2]
NUMBER(10) yes
del3_l
Number of times delinquent [3]
NUMBER(10) yes
del4_l
Number of times delinquent [4]
NUMBER(10) yes
due_l
Payment due day
NUMBER(10) yes
ass_l
Number of assumptions
NUMBER(10) yes
ext_l
Number of lease extensions
NUMBER(10) yes
pmt_ext_l
Number of payment extensions
NUMBER(10) yes
due_ext_l
Number of payment due date changes
NUMBER(10) yes
abp_l
Number of accruals to bypass
NUMBER(10) yes
lat_wav_l
Number of late charge waivers
NUMBER(10) yes
grc_l
Grace period in days
NUMBER(10) yes
pmt_prcd_l
Number of payments processed
NUMBER(10) yes
days_delq_l
Number of days delinquent
  See notes for del_amt_d field
NUMBER(10) yes
p_con_d
Lessor yield
NUMBER(15,7) yes
p_dly_d
Vendor yield
NUMBER(15,7) yes
p_inv_yld_d
Investor yield factor
NUMBER(15,7) yes
p_fund_d
Cost of funds
NUMBER(15,5) yes
p_erly_pay_d
NPV discount rate
NUMBER(15,5) yes
p_irr_d
IRR (yield)
NUMBER(15,7) yes
p_irr_nr_d
IRR (yield) without residual
NUMBER(15,7) yes
bad_debt_d
Bad debt percentage
NUMBER(15,5) yes
i_cus1_l
Custom integer 1
NUMBER(10) yes
i_cus2_l
Custom integer 2
NUMBER(10) yes
p_rent_d
Lessor rental simple rate
NUMBER(15,5) yes
p_byrt_d
Lessor rental rate add-on
NUMBER(15,5) yes
p_cntr_d
Contract rental rate add-on
NUMBER(15,5) yes
p_rent_i_d
Investor rental simple rate
NUMBER(15,5) yes
p_inv_d
Investor rental rate add-on
NUMBER(15,5) yes
p_rent_d_d
Vendor rental simple rate
NUMBER(15,5) yes
p_part_d
Rate of participation
NUMBER(15,5) yes
p_max_d
Maximum interest rate - lease level
NUMBER(15,5) yes
p_min_d
Minimum interest rate - lease level
NUMBER(15,5) yes
op_bill_adj_d
Operating lease princpal/income adjustment
NUMBER(15,2) yes
tot_org_d
Total acquisition cost
NUMBER(15,2) yes
tot_other_d
Other charges
NUMBER(15,2) yes
sec_d
Security deposit
NUMBER(15,2) yes
cap_d
Down payment
NUMBER(15,2) yes
up_d
Documentation fee
NUMBER(15,2) yes
pro_d
Interim rent
NUMBER(15,2) yes
brk_fee_d
Broker fees
NUMBER(15,2) yes
idc_d
Total initial direct costs
NUMBER(15,2) yes
tot_res_d
Residual amount
  If tot_res_d is entered by the user, the value of p_res_d
  is erased.
NUMBER(15,2) yes
res_guar_d
Guaranteed portion of residual
NUMBER(15,2) yes
mrk_up_d
Mark up
NUMBER(15,2) yes
in_fee_d
In-house fee
NUMBER(15,2) yes
prn_d
Accrued principal
NUMBER(15,2) yes
rec_d
Contract receivable
NUMBER(15,2) yes
prn_rec_d
Principal receivable
NUMBER(15,2) yes
rec_ytd_actual_d
Net receipts Y-T-D (actual)
NUMBER(15,2) yes
rec_ltd_d
Net receipts L-T-D (actual)
NUMBER(15,2) yes
rent_ytd_d
Rental income Y-T-D
NUMBER(15,2) yes
oth_ytd_d
Other income Y-T-D
NUMBER(15,2) yes
oth_ltd_d
Other income L-T-D
NUMBER(15,2) yes
l_in_ytd_d
Lessor income Y-T-D
NUMBER(15,2) yes
d_in_ytd_d
Vendor income Y-T-D
NUMBER(15,2) yes
i_in_ytd_d
Investor income Y-T-D
NUMBER(15,2) yes
l_ue_d
Lessor unearned rental income
NUMBER(15,2) yes
l_ue_org_d
Lessor orig unearned rental income
NUMBER(15,2) yes
l_in_ptd_d
Lessor rental income accrued P-T-D
NUMBER(15,2) yes
l_in_cur_d
Lessor current month rent income
NUMBER(15,2) yes
d_ue_d
Vendor current unearned rental income
NUMBER(15,2) yes
d_ue_org_d
Vendor original unearned rental
NUMBER(15,2) yes
d_in_ptd_d
Vendor rental income accrued P-T-D
NUMBER(15,2) yes
d_in_cur_d
Vendor rental income accrued, current month
NUMBER(15,2) yes
i_ue_d
Investor unearned rental income
NUMBER(15,2) yes
i_ue_org_d
Investor original unearned rental income
NUMBER(15,2) yes
i_in_ptd_d
Investor rental income accrued P-T-D
NUMBER(15,2) yes
i_in_cur_d
Investor current month rental income
NUMBER(15,2) yes
in_mly_d
Monthly rental income
NUMBER(15,2) yes
dp_mly_d
Monthly rental depreciation
NUMBER(15,2) yes
lat_wav_amt_d
Late charge waiver amount
NUMBER(15,2) yes
unrec_in_d
Unrecognized operating income
NUMBER(15,2) yes
acl_depr_d
Accumulated depreciation
NUMBER(15,2) yes
brk_ap_d
Broker fee accounts payable
NUMBER(15,2) yes
stub_amt_d
Amount of stub interest owed (-) or earned (+)
NUMBER(15,2) yes
d_pmt_cur_d
Vendor payment receivable, current month
NUMBER(15,2) yes
npv_d
NPV of payment stream
NUMBER(15,2) yes
tax_paid_d
Titling tax paid up-front
NUMBER(15,2) yes
tax_accr_d
Use tax accrued
NUMBER(15,2) yes
f_cus1_d
Custom float 1
NUMBER(15,2) yes
f_cus2_d
Custom float 2
NUMBER(15,2) yes
f_cus3_d
Custom float 3
NUMBER(15,2) yes
f_cus4_d
Custom float 4
NUMBER(15,2) yes
f_cus5_d
Custom float 5
NUMBER(15,2) yes
d_rec_d
Vendor receivable
NUMBER(15,2) yes
d_part_ue_d
Vendor payment participation unearned
NUMBER(15,2) yes
cur_paid_d
Amount current paid
NUMBER(15,2) yes
lst_paid_d
Amount last paid
NUMBER(15,2) yes
sch_int_ptd_d
Scheduled interest P-T-D
NUMBER(15,2) yes
idc_rem_d
Unamortized IDC - book
NUMBER(15,2) yes
idc_cur_d
IDC current month amortization - book
NUMBER(15,2) yes
lsd_unit_d
Leased assets
  Starting cost of assets under lease
NUMBER(15,2) yes
pmt_acc_d
Payment amount accrued Y-T-D
NUMBER(15,2) yes
r_in_ytd_d
Residual income Y-T-D
NUMBER(15,2) yes
r_ue_d
Unearned residual
NUMBER(15,2) yes
r_ue_org_d
Original unearned residual
NUMBER(15,2) yes
r_in_ptd_d
Residual income accrued P-T-D
NUMBER(15,2) yes
r_in_cur_d
Residual current month income
NUMBER(15,2) yes
susp_l_acc_d
Suspended lessor income accrued
NUMBER(15,2) yes
susp_d_acc_d
Suspended vendor income accrued
NUMBER(15,2) yes
susp_i_acc_d
Suspended investor income accrued
NUMBER(15,2) yes
susp_r_acc_d
Suspended residual income accrued
NUMBER(15,2) yes
susp_col_d
Suspended income collected
NUMBER(15,2) yes
fp_amt_d
Fixed price purchase
NUMBER(15,2) yes
susp_frst_d
First payment suspended earnings
NUMBER(15,2) yes
rec_boy_d
Contract receivable (begin of year)
NUMBER(15,2) yes
l_ue_boy_d
Lessor unearned income (begin of year)
NUMBER(15,2) yes
res_boy_d
Residual (beginning of year)
NUMBER(15,2) yes
l_ue_chg_ytd_d
Y-T-D lessor unearned income changes
NUMBER(15,2) yes
car_d
Interest carryover
NUMBER(15,2) yes
int_unpd_d
Interest unpaid
NUMBER(15,2) yes
prn_ytd_d
Principal paid Y-T-D
NUMBER(15,2) yes
prn_ltd_d
Principal paid L-T-D
NUMBER(15,2) yes
int_pd_ytd_d
Interest paid Y-T-D
NUMBER(15,2) yes
int_ltd_d
Interest paid L-T-D
NUMBER(15,2) yes
trade_in_d
Trade-in
NUMBER(15,2) yes
accrual_amt_to_date_d
Accrual amount to date (COF)
NUMBER(15,2) yes
del_amt_d
Total delinquent amount
NUMBER(15,2) yes
gr_rec_d
Custom gross receivable
  See notes for del_amt_d field
NUMBER(15,2) yes
net_out_d
Custom net outstanding
  See notes for del_amt_d field
NUMBER(15,2) yes
gr_out_d
Custom gross outstanding
  See notes for del_amt_d field
NUMBER(15,2) yes
ml_mile_d
Excess mileage adjustment
NUMBER(15,2) yes
ml_wear_d
Wear and tear adjustment
NUMBER(15,2) yes
ml_sale_d
Proceeds of sale
NUMBER(15,2) yes
ml_book_d
Book value
NUMBER(15,2) yes
idc_tax_d
Tax IDC
NUMBER(15,2) yes
idc_rem_tax_d
Unamortized IDC - tax
NUMBER(15,2) yes
idc_cur_tax_d
IDC current month amortization - tax
NUMBER(15,2) yes
idc_ytd_tax_d
IDC Y-T-D amortization - tax
NUMBER(15,2) yes
idc_ytd_d
IDC Y-T-D amount - book
NUMBER(15,2) yes
l_in_red_ytd_d
Lessor income reduction Y-T-D
NUMBER(15,2) yes
r_in_red_ytd_d
Residual income reduction Y-T-D
NUMBER(15,2) yes
idc_red_d
IDC reduction
NUMBER(15,2) yes
idc_interest_d
IDC interest portion
NUMBER(15,2) yes
tot_cap_int_d
Total capitalized interest
NUMBER(15,2) yes
p_fund2_d
Cost of funds 2 (For FCT)
NUMBER(15,5) yes
auto_ext_l
Number of automatic lease extensions
NUMBER(10) yes
dfrd_ext_incm_d
Deferred extension income
NUMBER(15,2) yes
dfrd_residual_red_d
Deferred residual reduction
NUMBER(15,2) yes
susp_idc_acc_d
Suspended IDC accrued
NUMBER(15,2) yes
msi_chg_key_c
Change lease key is in progress
CHAR(1) yes