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

Database Reference Oracle DBMS

rhfr Table: Historical Lease Recurring Charge for Accrual/Billing Cycle Change/Reversal

Parent Table

Name Description
rhf Historical Lease for Accrual/Billing Cycle Change/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rhfr_idx0 lse_s ext_num_s cycle_num_s unique_l

    
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
unique_l
Record number (possible values are 1 to 35)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
por_s
Portfolio
CHAR(2) yes
rcr_s
Recurring charge code
CHAR(4) yes
d_srcr_s
Recurring charge start date
DATE yes
d_mrcr_s
Recurring charge maturity date
DATE yes
rcr_pay_brk_s
Recurring charge payable to broker
CHAR(9) yes
rcr_pay_dlr_s
Recurring charge payable to dealer
CHAR(9) yes
rcr_amt_d
Recurring charge amount
NUMBER(15,2) yes
bundle_rcr_c
Bundle recurring charge on invoice
CHAR(1) yes