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

Database Reference Sybase DBMS

rhfv Table: Historical Lease Subvention 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
rhfv_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 5)
integer no
timestamp
Record modification stamp
timestamp yes
subv_type_s
Subvention type (SUBV.TYP code)
char(4) yes
subv_prog_id_1_s
Program ID #1
char(15) yes
subv_prog_id_2_s
Program ID #2
char(15) yes
p_subv_buy_rate_d
Buy rate
double precision yes
p_subv_rate_d
Subvention rate
double precision yes
subv_d
Subvention amount
double precision yes
subv_ue_d
Unearned subvention
double precision yes
subv_cur_d
Current subvention
double precision yes
subv_ytd_d
Y-T-D subvention
double precision yes
subv_red_d
Reduction subvention
double precision yes
subv_susp_d
Suspended subvention
double precision yes