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

Database Reference Oracle DBMS

rhfd Table: Historical Lease 4 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
rhfd_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 (value is always 1)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
lse_fee1_man_ltd_d
Lease fee manual assessment L-T-D [1]
NUMBER(15,2) yes
lse_fee2_man_ltd_d
Lease fee manual assessment L-T-D [2]
NUMBER(15,2) yes
lse_fee3_man_ltd_d
Lease fee manual assessment L-T-D [3]
NUMBER(15,2) yes
lse_fee4_man_ltd_d
Lease fee manual assessment L-T-D [4]
NUMBER(15,2) yes
lse_fee5_man_ltd_d
Lease fee manual assessment L-T-D [5]
NUMBER(15,2) yes
lse_fee6_man_ltd_d
Lease fee manual assessment L-T-D [6]
NUMBER(15,2) yes
lse_fee7_man_ltd_d
Lease fee manual assessment L-T-D [7]
NUMBER(15,2) yes
lse_fee8_man_ltd_d
Lease fee manual assessment L-T-D [8]
NUMBER(15,2) yes
lse_fee9_man_ltd_d
Lease fee manual assessment L-T-D [9]
NUMBER(15,2) yes
lse_fee10_man_ltd_d
Lease fee manual assessment L-T-D [10]
NUMBER(15,2) yes
lse_fee11_man_ltd_d
Lease fee manual assessment L-T-D [11]
NUMBER(15,2) yes
lse_fee12_man_ltd_d
Lease fee manual assessment L-T-D [12]
NUMBER(15,2) yes
lse_fee13_man_ltd_d
Lease fee manual assessment L-T-D [13]
NUMBER(15,2) yes
lse_fee14_man_ltd_d
Lease fee manual assessment L-T-D [14]
NUMBER(15,2) yes
lse_fee15_man_ltd_d
Lease fee manual assessment L-T-D [15]
NUMBER(15,2) yes
lse_fee16_man_ltd_d
Lease fee manual assessment L-T-D [16]
NUMBER(15,2) yes
lse_fee17_man_ltd_d
Lease fee manual assessment L-T-D [17]
NUMBER(15,2) yes
lse_fee18_man_ltd_d
Lease fee manual assessment L-T-D [18]
NUMBER(15,2) yes
lse_fee19_man_ltd_d
Lease fee manual assessment L-T-D [19]
NUMBER(15,2) yes
lse_fee20_man_ltd_d
Lease fee manual assessment L-T-D [20]
NUMBER(15,2) yes
unit_fee1_man_ltd_d
Asset fee manual assessment L-T-D [1]
NUMBER(15,2) yes
unit_fee2_man_ltd_d
Asset fee manual assessment L-T-D [2]
NUMBER(15,2) yes
unit_fee3_man_ltd_d
Asset fee manual assessment L-T-D [3]
NUMBER(15,2) yes
unit_fee4_man_ltd_d
Asset fee manual assessment L-T-D [4]
NUMBER(15,2) yes
unit_fee5_man_ltd_d
Asset fee manual assessment L-T-D [5]
NUMBER(15,2) yes
unit_fee6_man_ltd_d
Asset fee manual assessment L-T-D [6]
NUMBER(15,2) yes
unit_fee7_man_ltd_d
Asset fee manual assessment L-T-D [7]
NUMBER(15,2) yes
unit_fee8_man_ltd_d
Asset fee manual assessment L-T-D [8]
NUMBER(15,2) yes
unit_fee9_man_ltd_d
Asset fee manual assessment L-T-D [9]
NUMBER(15,2) yes
unit_fee10_man_ltd_d
Asset fee manual assessment L-T-D [10]
NUMBER(15,2) yes
rcr_man_ltd16_d
Recurring charge manual assessment L-T-D [16]
NUMBER(15,2) yes
rcr_man_ltd17_d
Recurring charge manual assessment L-T-D [17]
NUMBER(15,2) yes
rcr_man_ltd18_d
Recurring charge manual assessment L-T-D [18]
NUMBER(15,2) yes
rcr_man_ltd19_d
Recurring charge manual assessment L-T-D [19]
NUMBER(15,2) yes
rcr_man_ltd20_d
Recurring charge manual assessment L-T-D [20]
NUMBER(15,2) yes
rcr_man_ltd21_d
Recurring charge manual assessment L-T-D [21]
NUMBER(15,2) yes
rcr_man_ltd22_d
Recurring charge manual assessment L-T-D [22]
NUMBER(15,2) yes
rcr_man_ltd23_d
Recurring charge manual assessment L-T-D [23]
NUMBER(15,2) yes
rcr_man_ltd24_d
Recurring charge manual assessment L-T-D [24]
NUMBER(15,2) yes
rcr_man_ltd25_d
Recurring charge manual assessment L-T-D [25]
NUMBER(15,2) yes
rcr_man_ltd26_d
Recurring charge manual assessment L-T-D [26]
NUMBER(15,2) yes
rcr_man_ltd27_d
Recurring charge manual assessment L-T-D [27]
NUMBER(15,2) yes
rcr_man_ltd28_d
Recurring charge manual assessment L-T-D [28]
NUMBER(15,2) yes
rcr_man_ltd29_d
Recurring charge manual assessment L-T-D [29]
NUMBER(15,2) yes
rcr_man_ltd30_d
Recurring charge manual assessment L-T-D [30]
NUMBER(15,2) yes
rcr_man_ltd31_d
Recurring charge manual assessment L-T-D [31]
NUMBER(15,2) yes
rcr_man_ltd32_d
Recurring charge manual assessment L-T-D [32]
NUMBER(15,2) yes
rcr_man_ltd33_d
Recurring charge manual assessment L-T-D [33]
NUMBER(15,2) yes
rcr_man_ltd34_d
Recurring charge manual assessment L-T-D [34]
NUMBER(15,2) yes
rcr_man_ltd35_d
Recurring charge manual assessment L-T-D [35]
NUMBER(15,2) yes
lse_fee1_waive_ltd_d
Lease fee waived L-T-D [1]
NUMBER(15,2) yes
lse_fee2_waive_ltd_d
Lease fee waived L-T-D [2]
NUMBER(15,2) yes
lse_fee3_waive_ltd_d
Lease fee waived L-T-D [3]
NUMBER(15,2) yes
lse_fee4_waive_ltd_d
Lease fee waived L-T-D [4]
NUMBER(15,2) yes
lse_fee5_waive_ltd_d
Lease fee waived L-T-D [5]
NUMBER(15,2) yes
lse_fee6_waive_ltd_d
Lease fee waived L-T-D [6]
NUMBER(15,2) yes
lse_fee7_waive_ltd_d
Lease fee waived L-T-D [7]
NUMBER(15,2) yes
lse_fee8_waive_ltd_d
Lease fee waived L-T-D [8]
NUMBER(15,2) yes
lse_fee9_waive_ltd_d
Lease fee waived L-T-D [9]
NUMBER(15,2) yes
lse_fee10_waive_ltd_d
Lease fee waived L-T-D [10]
NUMBER(15,2) yes
lse_fee11_waive_ltd_d
Lease fee waived L-T-D [11]
NUMBER(15,2) yes
lse_fee12_waive_ltd_d
Lease fee waived L-T-D [12]
NUMBER(15,2) yes
lse_fee13_waive_ltd_d
Lease fee waived L-T-D [13]
NUMBER(15,2) yes
lse_fee14_waive_ltd_d
Lease fee waived L-T-D [14]
NUMBER(15,2) yes
lse_fee15_waive_ltd_d
Lease fee waived L-T-D [15]
NUMBER(15,2) yes
lse_fee16_waive_ltd_d
Lease fee waived L-T-D [16]
NUMBER(15,2) yes
lse_fee17_waive_ltd_d
Lease fee waived L-T-D [17]
NUMBER(15,2) yes
lse_fee18_waive_ltd_d
Lease fee waived L-T-D [18]
NUMBER(15,2) yes
lse_fee19_waive_ltd_d
Lease fee waived L-T-D [19]
NUMBER(15,2) yes
lse_fee20_waive_ltd_d
Lease fee waived L-T-D [20]
NUMBER(15,2) yes
unit_fee1_waive_ltd_d
Asset fee waived L-T-D [1]
NUMBER(15,2) yes
unit_fee2_waive_ltd_d
Asset fee waived L-T-D [2]
NUMBER(15,2) yes
unit_fee3_waive_ltd_d
Asset fee waived L-T-D [3]
NUMBER(15,2) yes
unit_fee4_waive_ltd_d
Asset fee waived L-T-D [4]
NUMBER(15,2) yes
unit_fee5_waive_ltd_d
Asset fee waived L-T-D [5]
NUMBER(15,2) yes
unit_fee6_waive_ltd_d
Asset fee waived L-T-D [6]
NUMBER(15,2) yes
unit_fee7_waive_ltd_d
Asset fee waived L-T-D [7]
NUMBER(15,2) yes
unit_fee8_waive_ltd_d
Asset fee waived L-T-D [8]
NUMBER(15,2) yes
unit_fee9_waive_ltd_d
Asset fee waived L-T-D [9]
NUMBER(15,2) yes
unit_fee10_waive_ltd_d
Asset fee waived L-T-D [10]
NUMBER(15,2) yes
rcr_waive_ltd16_d
Recurring charge waived L-T-D [16]
NUMBER(15,2) yes
rcr_waive_ltd17_d
Recurring charge waived L-T-D [17]
NUMBER(15,2) yes
rcr_waive_ltd18_d
Recurring charge waived L-T-D [18]
NUMBER(15,2) yes
rcr_waive_ltd19_d
Recurring charge waived L-T-D [19]
NUMBER(15,2) yes
rcr_waive_ltd20_d
Recurring charge waived L-T-D [20]
NUMBER(15,2) yes
rcr_waive_ltd21_d
Recurring charge waived L-T-D [21]
NUMBER(15,2) yes
rcr_waive_ltd22_d
Recurring charge waived L-T-D [22]
NUMBER(15,2) yes
rcr_waive_ltd23_d
Recurring charge waived L-T-D [23]
NUMBER(15,2) yes
rcr_waive_ltd24_d
Recurring charge waived L-T-D [24]
NUMBER(15,2) yes
rcr_waive_ltd25_d
Recurring charge waived L-T-D [25]
NUMBER(15,2) yes
rcr_waive_ltd26_d
Recurring charge waived L-T-D [26]
NUMBER(15,2) yes
rcr_waive_ltd27_d
Recurring charge waived L-T-D [27]
NUMBER(15,2) yes
rcr_waive_ltd28_d
Recurring charge waived L-T-D [28]
NUMBER(15,2) yes
rcr_waive_ltd29_d
Recurring charge waived L-T-D [29]
NUMBER(15,2) yes
rcr_waive_ltd30_d
Recurring charge waived L-T-D [30]
NUMBER(15,2) yes
rcr_waive_ltd31_d
Recurring charge waived L-T-D [31]
NUMBER(15,2) yes
rcr_waive_ltd32_d
Recurring charge waived L-T-D [32]
NUMBER(15,2) yes
rcr_waive_ltd33_d
Recurring charge waived L-T-D [33]
NUMBER(15,2) yes
rcr_waive_ltd34_d
Recurring charge waived L-T-D [34]
NUMBER(15,2) yes
rcr_waive_ltd35_d
Recurring charge waived L-T-D [35]
NUMBER(15,2) yes
idc8_d
Guaranteed reserves IDC8
NUMBER(15,2) yes
idc8_ap_d
Payable amount IDC8
NUMBER(15,2) yes
idc8_cur_d
Current IDC8
NUMBER(15,2) yes
idc8_red_d
Reduction IDC8
NUMBER(15,2) yes
idc8_susp_d
Suspended IDC8
NUMBER(15,2) yes
idc8_ue_d
Unearned IDC8
NUMBER(15,2) yes
idc8_ytd_d
Year to date IDC8
NUMBER(15,2) yes
alt_idc8_cur_d
Alternate current IDC8
NUMBER(15,2) yes
alt_idc8_ue_d
Alternate unearned IDC8
NUMBER(15,2) yes
alt_idc8_ytd_d
Alternate year to date IDC8
NUMBER(15,2) yes
idc9_d
Guaranteed reserves IDC9
NUMBER(15,2) yes
idc9_ap_d
Payable amount IDC9
NUMBER(15,2) yes
idc9_cur_d
Current IDC9
NUMBER(15,2) yes
idc9_red_d
Reduction IDC9
NUMBER(15,2) yes
idc9_susp_d
Suspended IDC9
NUMBER(15,2) yes
idc9_ue_d
Unearned IDC9
NUMBER(15,2) yes
idc9_ytd_d
Year to date IDC9
NUMBER(15,2) yes
alt_idc9_cur_d
Alternate current IDC9
NUMBER(15,2) yes
alt_idc9_ue_d
Alternate unearned IDC9
NUMBER(15,2) yes
alt_idc9_ytd_d
Alternate year to date IDC9
NUMBER(15,2) yes
idca_d
Guaranteed reserves IDCA
NUMBER(15,2) yes
idca_ap_d
Payable amount IDCA
NUMBER(15,2) yes
idca_cur_d
Current IDCA
NUMBER(15,2) yes
idca_red_d
Reduction IDCA
NUMBER(15,2) yes
idca_susp_d
Suspended IDCA
NUMBER(15,2) yes
idca_ue_d
Unearned IDCA
NUMBER(15,2) yes
idca_ytd_d
Year to date IDCA
NUMBER(15,2) yes
alt_idca_cur_d
Alternate current IDCA
NUMBER(15,2) yes
alt_idca_ue_d
Alternate unearned IDCA
NUMBER(15,2) yes
alt_idca_ytd_d
Alternate year to date IDCA
NUMBER(15,2) yes
idcb_d
Guaranteed reserves IDCB
NUMBER(15,2) yes
idcb_ap_d
Payable amount IDCB
NUMBER(15,2) yes
idcb_cur_d
Current IDCB
NUMBER(15,2) yes
idcb_red_d
Reduction IDCB
NUMBER(15,2) yes
idcb_susp_d
Suspended IDCB
NUMBER(15,2) yes
idcb_ue_d
Unearned IDCB
NUMBER(15,2) yes
idcb_ytd_d
Year to date IDCB
NUMBER(15,2) yes
alt_idcb_cur_d
Alternate current IDCB
NUMBER(15,2) yes
alt_idcb_ue_d
Alternate unearned IDCB
NUMBER(15,2) yes
alt_idcb_ytd_d
Alternate year to date IDCB
NUMBER(15,2) yes
idcc_d
Guaranteed reserves IDCC
NUMBER(15,2) yes
idcc_ap_d
Payable amount IDCC
NUMBER(15,2) yes
idcc_cur_d
Current IDCC
NUMBER(15,2) yes
idcc_red_d
Reduction IDCC
NUMBER(15,2) yes
idcc_susp_d
Suspended IDCC
NUMBER(15,2) yes
idcc_ue_d
Unearned IDCC
NUMBER(15,2) yes
idcc_ytd_d
Year to date IDCC
NUMBER(15,2) yes
alt_idcc_cur_d
Alternate current IDCC
NUMBER(15,2) yes
alt_idcc_ue_d
Alternate unearned IDCC
NUMBER(15,2) yes
alt_idcc_ytd_d
Alternate year to date IDCC
NUMBER(15,2) yes
idcd_d
Guaranteed reserves IDCD
NUMBER(15,2) yes
idcd_ap_d
Payable amount IDCD
NUMBER(15,2) yes
idcd_cur_d
Current IDCD
NUMBER(15,2) yes
idcd_red_d
Reduction IDCD
NUMBER(15,2) yes
idcd_susp_d
Suspended IDCD
NUMBER(15,2) yes
idcd_ue_d
Unearned IDCD
NUMBER(15,2) yes
idcd_ytd_d
Year to date IDCD
NUMBER(15,2) yes
alt_idcd_cur_d
Alternate current IDCD
NUMBER(15,2) yes
alt_idcd_ue_d
Alternate unearned IDCD
NUMBER(15,2) yes
alt_idcd_ytd_d
Alternate year to date IDCD
NUMBER(15,2) yes
idce_d
Guaranteed reserves IDCE
NUMBER(15,2) yes
idce_ap_d
Payable amount IDCE
NUMBER(15,2) yes
idce_cur_d
Current IDCE
NUMBER(15,2) yes
idce_red_d
Reduction IDCE
NUMBER(15,2) yes
idce_susp_d
Suspended IDCE
NUMBER(15,2) yes
idce_ue_d
Unearned IDCE
NUMBER(15,2) yes
idce_ytd_d
Year to date IDCE
NUMBER(15,2) yes
alt_idce_cur_d
Alternate current IDCE
NUMBER(15,2) yes
alt_idce_ue_d
Alternate unearned IDCE
NUMBER(15,2) yes
alt_idce_ytd_d
Alternate year to date IDCE
NUMBER(15,2) yes
idcf_d
Guaranteed reserves IDCF
NUMBER(15,2) yes
idcf_ap_d
Payable amount IDCF
NUMBER(15,2) yes
idcf_cur_d
Current IDCF
NUMBER(15,2) yes
idcf_red_d
Reduction IDCF
NUMBER(15,2) yes
idcf_susp_d
Suspended IDCF
NUMBER(15,2) yes
idcf_ue_d
Unearned IDCF
NUMBER(15,2) yes
idcf_ytd_d
Year to date IDCF
NUMBER(15,2) yes
alt_idcf_cur_d
Alternate current IDCF
NUMBER(15,2) yes
alt_idcf_ue_d
Alternate unearned IDCF
NUMBER(15,2) yes
alt_idcf_ytd_d
Alternate year to date IDCF
NUMBER(15,2) yes
idcg_d
Guaranteed reserves IDCG
NUMBER(15,2) yes
idcg_ap_d
Payable amount IDCG
NUMBER(15,2) yes
idcg_cur_d
Current IDCG
NUMBER(15,2) yes
idcg_red_d
Reduction IDCG
NUMBER(15,2) yes
idcg_susp_d
Suspended IDCG
NUMBER(15,2) yes
idcg_ue_d
Unearned IDCG
NUMBER(15,2) yes
idcg_ytd_d
Year to date IDCG
NUMBER(15,2) yes
alt_idcg_cur_d
Alternate current IDCG
NUMBER(15,2) yes
alt_idcg_ue_d
Alternate unearned IDCG
NUMBER(15,2) yes
alt_idcg_ytd_d
Alternate year to date IDCG
NUMBER(15,2) yes
idch_d
Guaranteed reserves IDCH
NUMBER(15,2) yes
idch_ap_d
Payable amount IDCH
NUMBER(15,2) yes
idch_cur_d
Current IDCH
NUMBER(15,2) yes
idch_red_d
Reduction IDCH
NUMBER(15,2) yes
idch_susp_d
Suspended IDCH
NUMBER(15,2) yes
idch_ue_d
Unearned IDCH
NUMBER(15,2) yes
idch_ytd_d
Year to date IDCH
NUMBER(15,2) yes
alt_idch_cur_d
Alternate current IDCH
NUMBER(15,2) yes
alt_idch_ue_d
Alternate unearned IDCH
NUMBER(15,2) yes
alt_idch_ytd_d
Alternate year to date IDCH
NUMBER(15,2) yes