| Description | Column | Datatype |
|---|---|---|
| Lease | lse_s | char (10) |
| Record number | unique_l | number (10) |
| Oracle row stamp | stamp_l | number (10) |
| Defer payment due date | d_defer_pmt_s | date |
| Final payment due date | d_final_pmt_s | date |
| Turn-in date | d_turn_in_s | date |
| Total tax credit | orig_tax_crd_d | number (15,2) |
| Remaining tax credit | rem_tax_crd_d | number (15,2) |
| Cumulative number of deffered months | def_mon_l | number (10) |
| Final monthly payment amount | final_pmt_d | number (15,2) |
| Date of last payment reschedule | d_rsc_s | date |
| Date of last payment reschedule (RWT) | d_rsc_rwt_s | date |
| Date of last payment reschedule (DEF) | d_rsc_def_s | date |
| Number of payment reschedules (RWT) | pmt_rsc_rwt_l | number (10) |
| Number of payment reschedules (DEF) | pmt_rsc_def_l | number (10) |
| Maintenance fee (auditing only) | maint_fee_d | number (15,2) |
| 2nd 12-month payment history grid | pmt_hist2_s | char (12) |
| Bankruptcy status code | bkrpt_stat_s | char (4) |
| Previous bankruptcy status code | prev_bkrpt_stat_s | char (4) |
| First payment default (Y/N) | first_pmt_default_c | char (1) |
| Original MSRP amount | orig_x_msrp_d | number (15,2) |
| Loan type | lt_s | char (4) |
| Obligators liability | ob_liab_s | char (4) |
| Previous repossesion (Y/N) | prev_repo_c | char (1) |
| Write off reason | write_off_s | char (4) |
| NSF counter | nsf_count_l | number (10) |
| Dealer reserves SL depreciation basis | idc_depr_l | number (10) |
| Acquisition fee SL depreciation basis | idrb_depr_l | number (10) |
| Estimated lessor income L-T-D | l_in_ltd_d | number (15,2) |
| Alternate unearned IDC3 | alt_idc3_ue_d | number (15,2) |
| Alternate current IDC3 | alt_idc3_cur_d | number (15,2) |
| Alternate year to date IDC3 | alt_idc3_ytd_d | number (15,2) |
| Alternate unearned IDC4 | alt_idc4_ue_d | number (15,2) |
| Alternate current IDC4 | alt_idc4_cur_d | number (15,2) |
| Alternate year to date IDC4 | alt_idc4_ytd_d | number (15,2) |
| Alternate unearned IDC5 | alt_idc5_ue_d | number (15,2) |
| Alternate current IDC5 | alt_idc5_cur_d | number (15,2) |
| Alternate year to date IDC5 | alt_idc5_ytd_d | number (15,2) |
| Alternate unearned IDR5 | alt_idr5_ue_d | number (15,2) |
| Alternate current IDR5 | alt_idr5_cur_d | number (15,2) |
| Alternate year to date IDR5 | alt_idr5_ytd_d | number (15,2) |
| Alternate unearned IDR6 | alt_idr6_ue_d | number (15,2) |
| Alternate current IDR6 | alt_idr6_cur_d | number (15,2) |
| Alternate year to date IDR6 | alt_idr6_ytd_d | number (15,2) |
| Alternate unearned IDRB | alt_idrb_ue_d | number (15,2) |
| Alternate current IDRB | alt_idrb_cur_d | number (15,2) |
| Alternate year to date IDRB | alt_idrb_ytd_d | number (15,2) |
| GL lessor income L-T-D | gl_in_ltd_d | number (15,2) |
| GL lessor income M-T-D | gl_in_mtd_d | number (15,2) |
| GL lessor income Y-T-D | gl_in_ytd_d | number (15,2) |
| Back payment applied (Y/N) | back_pmt_appl_c | char (1) |
| Revolving credit limit [1] | revolving_limit1_d | number (15,2) |
| Revolving credit limit [2] | revolving_limit2_d | number (15,2) |
| Revolving credit limit [3] | revolving_limit3_d | number (15,2) |
| Revolving credit limit [4] | revolving_limit4_d | number (15,2) |
| Revolving credit limit effective date [1] | d_revolving_limit_eff1_s | date |
| Revolving credit limit effective date [2] | d_revolving_limit_eff2_s | date |
| Revolving credit limit effective date [3] | d_revolving_limit_eff3_s | date |
| Revolving credit limit effective date [4] | d_revolving_limit_eff4_s | date |
| Revolving credit line fee | p_revolving_line_fee_d | number (15,5) |
| Customer yield | p_cus_d | number (15,7) |
| Insurance risk fee rate | p_ins_risk_fee_d | number (15,5) |
| Insurance risk fee code | ins_risk_fee_s | char (4) |
| Date of last insurance risk fee assessment | d_last_ins_risk_fee_s | date |
| PAP bank account name | payer_acct_nam_s | varchar2 (50) |
| Deferred income amount | def_inc_d | number (15,2) |
| Deferred IDC amount | def_idc_d | number (15,2) |
| Deferred IDC1 amount | def_idc1_d | number (15,2) |
| Deferred IDC2 amount | def_idc2_d | number (15,2) |
| Deferred IDR1 amount | def_idr1_d | number (15,2) |
| Deferred IDR2 amount | def_idr2_d | number (15,2) |
| Deferred IDR3 amount | def_idr3_d | number (15,2) |
| Deferred IDR4 amount | def_idr4_d | number (15,2) |
| Number of payment reschedules (RSC) | pmt_rsc_rsc_l | number (10) |
| Date of last leveraged table download | d_lst_lvr_s | date |
| Leveraged commencement date | d_lvr_com_s | date |
| Leveraged (Y/N) | lvr_c | char (1) |
| Number of leveraged table download | lvr_l | number (10) |
| Leveraged term | lvr_trm_l | number (10) |
| Staged equity amount | stg_eqty_d | number (15,2) |
| Staged equity account payable | stg_eqty_ap_d | number (15,2) |
| Taxable income Y-T-D amount | tax_inc_ytd_d | number (15,2) |
| FSC exclusion Y-T-D amount | fsc_ytd_d | number (15,2) |
| Interest expenses Y-T-D amount | int_expn_ytd_d | number (15,2) |
| Strategic grouping for behaviour scoring | strat_grp_c | char (1) |
| Risk band for behavior scoring | risk_band_c | char (1) |
| Account behavior score | acct_bhv_scr_s | char (8) |
| External strategy for behavior scoring | ext_strat_s | char (4) |
| Staged equity fund payable to | stg_eqty_pay_to_s | char (9) |
| Deferred tax YTD amount | dfrd_tax_ytd_d | number (15,2) |
| Non-pyramiding late charge minimum payment due | npyr_min_d | number (15,2) |
| IDC amortization add-on interest rate | p_idc_addon_d | number (15,5) |
| IDC amortization interest rate | p_idc_amort_d | number (15,5) |
| Schedule principal | sch_prn_d | number (15,2) |
| Late charge date | d_ltch_s | date |
| Late charge assessed prior to last accrual (Y/N) | prev_ltch_c | char (1) |
| Invoice due date overlap (Y/N) | due_overlap_c | char (1) |
| Valuation reserve | valuat_res_d | number (15,2) |
| Recovery | recovery_d | number (15,2) |
| Optional residual | opt_res_d | number (15,2) |
| Non commission amount | non_comm_d | number (15,2) |
| Security deposit refund amount | sec_refund_d | number (15,2) |
| Principal write down (Y/N) | prn_write_down_c | char (1) |
| Metro2 file format code | metro2_s | char (4) |
| Date of first delinquency | d_first_delq_s | date |
| Invoice format code | invo_format_s | char (4) |
| Security deposit disbursal status (P/U/N)
P - processed U - unprocessed N - n/a |
sec_status_c | char (1) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| rlsb_idx0 | lse_s | unique_l |
LeasePak Database Reference
©
by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.