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

Database Reference

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