| Description | Column | Datatype |
|---|---|---|
| Portfolio | por_s | char (2) |
| Record number | unique_l | number (10) |
| Oracle row stamp | stamp_l | number (10) |
| List of application statuses | app_stat_list_s | varchar2 (148) |
| Entry requirements | app_ent_s | varchar2 (148) |
| Display field (X/' ') | disp1_s | varchar2 (200) |
| Display field (X/' ') | disp2_s | varchar2 (200) |
| Display field (X/' ') | disp3_s | varchar2 (200) |
| FMV term [1] | fmv_trm1_l | number (10) |
| FMV term [2] | fmv_trm2_l | number (10) |
| FMV term [3] | fmv_trm3_l | number (10) |
| FMV term [4] | fmv_trm4_l | number (10) |
| FMV term [5] | fmv_trm5_l | number (10) |
| Maximum lease rate - precomputed simple | h_cntr1_d | number (15,5) |
| Maximum lease rate - simple interest | h_cntr2_d | number (15,5) |
| Maximum lease rate - level yield | h_cntr3_d | number (15,5) |
| Maximum lease rate - rule of 12/78ths | h_cntr4_d | number (15,5) |
| Maximum lease rate - straight line | h_cntr5_d | number (15,5) |
| Minimum lease rate - precomputed simple | l_cntr1_d | number (15,5) |
| Minimum lease rate - simple interest | l_cntr2_d | number (15,5) |
| Minimum lease rate - level yield | l_cntr3_d | number (15,5) |
| Minimum lease rate - rule of 12/78ths | l_cntr4_d | number (15,5) |
| Minimum lease rate - straight line | l_cntr5_d | number (15,5) |
| Maximum vendor rate - precomputed simple | h_dlr1_d | number (15,5) |
| Maximum vendor rate - simple interest | h_dlr2_d | number (15,5) |
| Maximum vendor rate - level yield | h_dlr3_d | number (15,5) |
| Maximum vendor rate - rule of 12/78ths | h_dlr4_d | number (15,5) |
| Maximum vendor rate - straight line | h_dlr5_d | number (15,5) |
| Minimum vendor rate - precomputed simple | l_dlr1_d | number (15,5) |
| Minimum vendor rate - simple interest | l_dlr2_d | number (15,5) |
| Minimum vendor rate - level yield | l_dlr3_d | number (15,5) |
| Minimum vendor rate - rule of 12/78ths | l_dlr4_d | number (15,5) |
| Minimum vendor rate - straight line | l_dlr5_d | number (15,5) |
| Maximum investor rate - precomputed simple | h_inv1_d | number (15,5) |
| Maximum investor rate - simple interest | h_inv2_d | number (15,5) |
| Maximum investor rate - level yield | h_inv3_d | number (15,5) |
| Maximum investor rate - rule of 12/78ths | h_inv4_d | number (15,5) |
| Maximum investor rate - straight line | h_inv5_d | number (15,5) |
| Minimum investor rate - precomputed simple | l_inv1_d | number (15,5) |
| Minimum investor rate - simple interest | l_inv2_d | number (15,5) |
| Minimum investor rate - level yield | l_inv3_d | number (15,5) |
| Minimum investor rate - rule of 12/78ths | l_inv4_d | number (15,5) |
| Minimum investor rate - straight line | l_inv5_d | number (15,5) |
| FMV percentage [1] | fmv_per1_d | number (15,2) |
| FMV percentage [2] | fmv_per2_d | number (15,2) |
| FMV percentage [3] | fmv_per3_d | number (15,2) |
| FMV percentage [4] | fmv_per4_d | number (15,2) |
| FMV percentage [5] | fmv_per5_d | number (15,2) |
| Default display payment amount (Y/N) | dflt_displ_pmt_c | char (1) |
| Add comment to transaction (Y/N) | add_com_trn_c | char (1) |
| Apply payments past due/priority (A/B/N) | past_due_priority_c | char (1) |
| Priority assessment (Y/N) | asm_priority_c | varchar2 (33) |
| Principal/payment interest bank code | waive_bank_s | char (3) |
| IDC1 alias - 21 characters | s_idc1_s | varchar2 (21) |
| IDC2 alias - 21 characters | s_idc2_s | varchar2 (21) |
| IDC3 alias - 21 characters | s_idc3_s | varchar2 (21) |
| IDC4 alias - 21 characters | s_idc4_s | varchar2 (21) |
| IDC5 alias - 21 characters | s_idc5_s | varchar2 (21) |
| IDR1 alias - 21 characters | s_idr1_s | varchar2 (21) |
| IDR2 alias - 21 characters | s_idr2_s | varchar2 (21) |
| IDR3 alias - 21 characters | s_idr3_s | varchar2 (21) |
| IDR4 alias - 21 characters | s_idr4_s | varchar2 (21) |
| IDR5 alias - 21 characters | s_idr5_s | varchar2 (21) |
| IDR6 alias - 21 characters | s_idr6_s | varchar2 (21) |
| IDR7 alias - 21 characters | s_idr7_s | varchar2 (21) |
| IDR8 alias - 21 characters | s_idr8_s | varchar2 (21) |
| IDR9 alias - 21 characters | s_idr9_s | varchar2 (21) |
| IDRA alias - 21 characters | s_idra_s | varchar2 (21) |
| IDRB alias - 21 characters | s_idrb_s | varchar2 (21) |
| IDRC alias - 21 characters | s_idrc_s | varchar2 (21) |
| IDC1 alias - 9 characters | ss_idc1_s | char (9) |
| IDC2 alias - 9 characters | ss_idc2_s | char (9) |
| IDC3 alias - 9 characters | ss_idc3_s | char (9) |
| IDC4 alias - 9 characters | ss_idc4_s | char (9) |
| IDC5 alias - 9 characters | ss_idc5_s | char (9) |
| IDR1 alias - 9 characters | ss_idr1_s | char (9) |
| IDR2 alias - 9 characters | ss_idr2_s | char (9) |
| IDR3 alias - 9 characters | ss_idr3_s | char (9) |
| IDR4 alias - 9 characters | ss_idr4_s | char (9) |
| IDR5 alias - 9 characters | ss_idr5_s | char (9) |
| IDR6 alias - 9 characters | ss_idr6_s | char (9) |
| IDR7 alias - 9 characters | ss_idr7_s | char (9) |
| IDR8 alias - 9 characters | ss_idr8_s | char (9) |
| IDR9 alias - 9 characters | ss_idr9_s | char (9) |
| IDRA alias - 9 characters | ss_idra_s | char (9) |
| IDRB alias - 9 characters | ss_idrb_s | char (9) |
| IDRC alias - 9 characters | ss_idrc_s | char (9) |
| Down payment is informational only (Y/N) | dwn_pmt_inf_c | char (1) |
| Automatic payoff loss tolerance | auto_payo_loss_tol_d | number (15,2) |
| Automatic payoff gain tolerance | auto_payo_gain_tol_d | number (15,2) |
| Reversal reason code/bank code [1] | rev_cat1_s | char (5) |
| Reversal reason code/bank code [2] | rev_cat2_s | char (5) |
| Reversal reason code/bank code [3] | rev_cat3_s | char (5) |
| Reversal reason code/bank code [4] | rev_cat4_s | char (5) |
| Reversal reason code/bank code [5] | rev_cat5_s | char (5) |
| Default bank code for auto suspense | cc_auto_sus_bank_s | char (3) |
| Default C/R/O for auto suspense | cc_auto_sus_cro_s | char (7) |
| Delinquency payment percentage | del_pmt_perc_l | number (10) |
| Delinquency category boundaries [4] | delq4_l | number (10) |
| Delinquency category boundaries [5] | delq5_l | number (10) |
| Delinquency category boundaries [6] | delq6_l | number (10) |
| Default securitization bank code | sec_bank_s | char (3) |
| Override late charges for delinquency
payment percentage (Y/N) |
over_ltchgs_del_pmt_c | char (1) |
| Number of payments for first extension/deferment eligibility | pmt_frst_extdef_l | number (10) |
| Number of payments between for next extension/deferment | pmt_btw_extdef_l | number (10) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| rpaz_idx0 | por_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.