rhfd Table: Historical Lease 4 for Accrual/Billing Cycle Change/Reversal

Database Reference

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