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

Database Reference Sybase 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
timestamp
Record modification stamp
timestamp 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
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
datetime yes
d_com_s
Lease commencement date used for calculations
datetime yes
d_boo_s
System booking date
datetime yes
d_dis_s
Disbursement date
datetime yes
d_mat_s
Maturity date
datetime yes
d_lup_s
Date of last update
datetime yes
t_lup_s
Time of last update
char(6) yes
d_act_s
Activity status date
datetime yes
d_pmt_s
Next payment due date
datetime yes
d_acc_s
Accrued to date
datetime yes
d_pay_s
Last payment date
datetime yes
d_lst_s
Last payment due date
datetime yes
d_reb_s
Last rebook date
datetime yes
d_ass_s
Assumed lease date
datetime yes
d_pxt_s
Payment extension date
datetime yes
d_fxt_s
Date of first payment extension
datetime yes
d_lxt_s
Lease extension date
datetime yes
d_cus1_s
Custom date 1
datetime yes
d_susp_pmt_s
First payment on suspension
datetime yes
d_susp_on_s
Date placed on suspension/non-accrual
datetime yes
d_susp_eff_s
Effective date of suspension/non-accrual
datetime yes
d_eff_s
Effective date of last payment
datetime yes
t_boo_s
System booking time
char(6) yes
d_doc_comp_s
Documentation completion date
datetime yes
d_lcus_s
Date custom outstanding last updated
  For use only by collection module
datetime 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
datetime yes
d_pap_eff_s
PAP effective date
datetime 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
char(36) yes
s_cus2_s
Custom string 2
char(10) yes
trd_desc_s
Trade-in description
char(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
integer yes
invst_defr_l
Investor settlement deferral days
integer yes
trm_l
Lease term
integer yes
est_trm_l
Estimated lease term
integer yes
pmt_l
Number of payments accrued
integer yes
n_unt_l
Number of assets on this lease
integer yes
del1_l
Number of times delinquent [1]
integer yes
del2_l
Number of times delinquent [2]
integer yes
del3_l
Number of times delinquent [3]
integer yes
del4_l
Number of times delinquent [4]
integer yes
due_l
Payment due day
integer yes
ass_l
Number of assumptions
integer yes
ext_l
Number of lease extensions
integer yes
pmt_ext_l
Number of payment extensions
integer yes
due_ext_l
Number of payment due date changes
integer yes
abp_l
Number of accruals to bypass
integer yes
lat_wav_l
Number of late charge waivers
integer yes
grc_l
Grace period in days
integer yes
pmt_prcd_l
Number of payments processed
integer yes
days_delq_l
Number of days delinquent
  See notes for del_amt_d field
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
p_fund_d
Cost of funds
double precision yes
p_erly_pay_d
NPV discount rate
double precision yes
p_irr_d
IRR (yield)
double precision yes
p_irr_nr_d
IRR (yield) without residual
double precision yes
bad_debt_d
Bad debt percentage
double precision yes
i_cus1_l
Custom integer 1
integer yes
i_cus2_l
Custom integer 2
integer yes
p_rent_d
Lessor rental simple rate
double precision yes
p_byrt_d
Lessor rental rate add-on
double precision yes
p_cntr_d
Contract rental rate add-on
double precision yes
p_rent_i_d
Investor rental simple rate
double precision yes
p_inv_d
Investor rental rate add-on
double precision yes
p_rent_d_d
Vendor rental simple rate
double precision yes
p_part_d
Rate of participation
double precision yes
p_max_d
Maximum interest rate - lease level
double precision yes
p_min_d
Minimum interest rate - lease level
double precision yes
op_bill_adj_d
Operating lease princpal/income adjustment
double precision yes
tot_org_d
Total acquisition cost
double precision yes
tot_other_d
Other charges
double precision yes
sec_d
Security deposit
double precision yes
cap_d
Down payment
double precision yes
up_d
Documentation fee
double precision yes
pro_d
Interim rent
double precision yes
brk_fee_d
Broker fees
double precision yes
idc_d
Total initial direct costs
double precision yes
tot_res_d
Residual amount
  If tot_res_d is entered by the user, the value of p_res_d
  is erased.
double precision yes
res_guar_d
Guaranteed portion of residual
double precision yes
mrk_up_d
Mark up
double precision yes
in_fee_d
In-house fee
double precision yes
prn_d
Accrued principal
double precision yes
rec_d
Contract receivable
double precision yes
prn_rec_d
Principal receivable
double precision yes
rec_ytd_actual_d
Net receipts Y-T-D (actual)
double precision yes
rec_ltd_d
Net receipts L-T-D (actual)
double precision yes
rent_ytd_d
Rental income Y-T-D
double precision yes
oth_ytd_d
Other income Y-T-D
double precision yes
oth_ltd_d
Other income L-T-D
double precision yes
l_in_ytd_d
Lessor income Y-T-D
double precision yes
d_in_ytd_d
Vendor income Y-T-D
double precision yes
i_in_ytd_d
Investor income Y-T-D
double precision yes
l_ue_d
Lessor unearned rental income
double precision yes
l_ue_org_d
Lessor orig unearned rental income
double precision yes
l_in_ptd_d
Lessor rental income accrued P-T-D
double precision yes
l_in_cur_d
Lessor current month rent income
double precision yes
d_ue_d
Vendor current unearned rental income
double precision yes
d_ue_org_d
Vendor original unearned rental
double precision yes
d_in_ptd_d
Vendor rental income accrued P-T-D
double precision yes
d_in_cur_d
Vendor rental income accrued, current month
double precision yes
i_ue_d
Investor unearned rental income
double precision yes
i_ue_org_d
Investor original unearned rental income
double precision yes
i_in_ptd_d
Investor rental income accrued P-T-D
double precision yes
i_in_cur_d
Investor current month rental income
double precision yes
in_mly_d
Monthly rental income
double precision yes
dp_mly_d
Monthly rental depreciation
double precision yes
lat_wav_amt_d
Late charge waiver amount
double precision yes
unrec_in_d
Unrecognized operating income
double precision yes
acl_depr_d
Accumulated depreciation
double precision yes
brk_ap_d
Broker fee accounts payable
double precision yes
stub_amt_d
Amount of stub interest owed (-) or earned (+)
double precision yes
d_pmt_cur_d
Vendor payment receivable, current month
double precision yes
npv_d
NPV of payment stream
double precision yes
tax_paid_d
Titling tax paid up-front
double precision yes
tax_accr_d
Use tax accrued
double precision yes
f_cus1_d
Custom float 1
double precision yes
f_cus2_d
Custom float 2
double precision yes
f_cus3_d
Custom float 3
double precision yes
f_cus4_d
Custom float 4
double precision yes
f_cus5_d
Custom float 5
double precision yes
d_rec_d
Vendor receivable
double precision yes
d_part_ue_d
Vendor payment participation unearned
double precision yes
cur_paid_d
Amount current paid
double precision yes
lst_paid_d
Amount last paid
double precision yes
sch_int_ptd_d
Scheduled interest P-T-D
double precision yes
idc_rem_d
Unamortized IDC - book
double precision yes
idc_cur_d
IDC current month amortization - book
double precision yes
lsd_unit_d
Leased assets
  Starting cost of assets under lease
double precision yes
pmt_acc_d
Payment amount accrued Y-T-D
double precision yes
r_in_ytd_d
Residual income Y-T-D
double precision yes
r_ue_d
Unearned residual
double precision yes
r_ue_org_d
Original unearned residual
double precision yes
r_in_ptd_d
Residual income accrued P-T-D
double precision yes
r_in_cur_d
Residual current month income
double precision yes
susp_l_acc_d
Suspended lessor income accrued
double precision yes
susp_d_acc_d
Suspended vendor income accrued
double precision yes
susp_i_acc_d
Suspended investor income accrued
double precision yes
susp_r_acc_d
Suspended residual income accrued
double precision yes
susp_col_d
Suspended income collected
double precision yes
fp_amt_d
Fixed price purchase
double precision yes
susp_frst_d
First payment suspended earnings
double precision yes
rec_boy_d
Contract receivable (begin of year)
double precision yes
l_ue_boy_d
Lessor unearned income (begin of year)
double precision yes
res_boy_d
Residual (beginning of year)
double precision yes
l_ue_chg_ytd_d
Y-T-D lessor unearned income changes
double precision yes
car_d
Interest carryover
double precision yes
int_unpd_d
Interest unpaid
double precision yes
prn_ytd_d
Principal paid Y-T-D
double precision yes
prn_ltd_d
Principal paid L-T-D
double precision yes
int_pd_ytd_d
Interest paid Y-T-D
double precision yes
int_ltd_d
Interest paid L-T-D
double precision yes
trade_in_d
Trade-in
double precision yes
accrual_amt_to_date_d
Accrual amount to date (COF)
double precision yes
del_amt_d
Total delinquent amount
double precision yes
gr_rec_d
Custom gross receivable
  See notes for del_amt_d field
double precision yes
net_out_d
Custom net outstanding
  See notes for del_amt_d field
double precision yes
gr_out_d
Custom gross outstanding
  See notes for del_amt_d field
double precision yes
ml_mile_d
Excess mileage adjustment
double precision yes
ml_wear_d
Wear and tear adjustment
double precision yes
ml_sale_d
Proceeds of sale
double precision yes
ml_book_d
Book value
double precision yes
idc_tax_d
Tax IDC
double precision yes
idc_rem_tax_d
Unamortized IDC - tax
double precision yes
idc_cur_tax_d
IDC current month amortization - tax
double precision yes
idc_ytd_tax_d
IDC Y-T-D amortization - tax
double precision yes
idc_ytd_d
IDC Y-T-D amount - book
double precision yes
l_in_red_ytd_d
Lessor income reduction Y-T-D
double precision yes
r_in_red_ytd_d
Residual income reduction Y-T-D
double precision yes
idc_red_d
IDC reduction
double precision yes
idc_interest_d
IDC interest portion
double precision yes
tot_cap_int_d
Total capitalized interest
double precision yes
p_fund2_d
Cost of funds 2 (For FCT)
double precision yes
auto_ext_l
Number of automatic lease extensions
integer yes
dfrd_ext_incm_d
Deferred extension income
double precision yes
dfrd_residual_red_d
Deferred residual reduction
double precision yes
susp_idc_acc_d
Suspended IDC accrued
double precision yes
msi_chg_key_c
Change lease key is in progress
char(1) yes