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) |
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 |