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

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