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

Database Reference Oracle DBMS

rhfp Table: Historical Lease Payment Schedule 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
rhfp_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 360)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
pmt_frq_l
Number of payments at frequency
NUMBER(10) yes
pmt_amt_d
Payment amount
NUMBER(15,2) yes
pmt_cd_s
Payment frequency code
CHAR(4) yes