| Description | Column | Datatype |
|---|---|---|
| Portfolio | por_s | char (2) |
| Record number | unique_l | integer |
| Sybase timestamp | timestamp | timestamp |
| List of application statuses | app_stat_list_s | char (148) |
| Entry requirements | app_ent_s | char (148) |
| Display field (X/' ') | disp1_s | char (200) |
| Display field (X/' ') | disp2_s | char (200) |
| Display field (X/' ') | disp3_s | char (200) |
| FMV term [1] | fmv_trm1_l | integer |
| FMV term [2] | fmv_trm2_l | integer |
| FMV term [3] | fmv_trm3_l | integer |
| FMV term [4] | fmv_trm4_l | integer |
| FMV term [5] | fmv_trm5_l | integer |
| Maximum lease rate - precomputed simple | h_cntr1_d | double precision |
| Maximum lease rate - simple interest | h_cntr2_d | double precision |
| Maximum lease rate - level yield | h_cntr3_d | double precision |
| Maximum lease rate - rule of 12/78ths | h_cntr4_d | double precision |
| Maximum lease rate - straight line | h_cntr5_d | double precision |
| Minimum lease rate - precomputed simple | l_cntr1_d | double precision |
| Minimum lease rate - simple interest | l_cntr2_d | double precision |
| Minimum lease rate - level yield | l_cntr3_d | double precision |
| Minimum lease rate - rule of 12/78ths | l_cntr4_d | double precision |
| Minimum lease rate - straight line | l_cntr5_d | double precision |
| Maximum vendor rate - precomputed simple | h_dlr1_d | double precision |
| Maximum vendor rate - simple interest | h_dlr2_d | double precision |
| Maximum vendor rate - level yield | h_dlr3_d | double precision |
| Maximum vendor rate - rule of 12/78ths | h_dlr4_d | double precision |
| Maximum vendor rate - straight line | h_dlr5_d | double precision |
| Minimum vendor rate - precomputed simple | l_dlr1_d | double precision |
| Minimum vendor rate - simple interest | l_dlr2_d | double precision |
| Minimum vendor rate - level yield | l_dlr3_d | double precision |
| Minimum vendor rate - rule of 12/78ths | l_dlr4_d | double precision |
| Minimum vendor rate - straight line | l_dlr5_d | double precision |
| Maximum investor rate - precomputed simple | h_inv1_d | double precision |
| Maximum investor rate - simple interest | h_inv2_d | double precision |
| Maximum investor rate - level yield | h_inv3_d | double precision |
| Maximum investor rate - rule of 12/78ths | h_inv4_d | double precision |
| Maximum investor rate - straight line | h_inv5_d | double precision |
| Minimum investor rate - precomputed simple | l_inv1_d | double precision |
| Minimum investor rate - simple interest | l_inv2_d | double precision |
| Minimum investor rate - level yield | l_inv3_d | double precision |
| Minimum investor rate - rule of 12/78ths | l_inv4_d | double precision |
| Minimum investor rate - straight line | l_inv5_d | double precision |
| FMV percentage [1] | fmv_per1_d | double precision |
| FMV percentage [2] | fmv_per2_d | double precision |
| FMV percentage [3] | fmv_per3_d | double precision |
| FMV percentage [4] | fmv_per4_d | double precision |
| FMV percentage [5] | fmv_per5_d | double precision |
| 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 | char (33) |
| Principal/payment interest bank code | waive_bank_s | char (3) |
| IDC1 alias - 21 characters | s_idc1_s | char (21) |
| IDC2 alias - 21 characters | s_idc2_s | char (21) |
| IDC3 alias - 21 characters | s_idc3_s | char (21) |
| IDC4 alias - 21 characters | s_idc4_s | char (21) |
| IDC5 alias - 21 characters | s_idc5_s | char (21) |
| IDR1 alias - 21 characters | s_idr1_s | char (21) |
| IDR2 alias - 21 characters | s_idr2_s | char (21) |
| IDR3 alias - 21 characters | s_idr3_s | char (21) |
| IDR4 alias - 21 characters | s_idr4_s | char (21) |
| IDR5 alias - 21 characters | s_idr5_s | char (21) |
| IDR6 alias - 21 characters | s_idr6_s | char (21) |
| IDR7 alias - 21 characters | s_idr7_s | char (21) |
| IDR8 alias - 21 characters | s_idr8_s | char (21) |
| IDR9 alias - 21 characters | s_idr9_s | char (21) |
| IDRA alias - 21 characters | s_idra_s | char (21) |
| IDRB alias - 21 characters | s_idrb_s | char (21) |
| IDRC alias - 21 characters | s_idrc_s | char (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 | double precision |
| Automatic payoff gain tolerance | auto_payo_gain_tol_d | double precision |
| 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 | integer |
| Delinquency category boundaries [4] | delq4_l | integer |
| Delinquency category boundaries [5] | delq5_l | integer |
| Delinquency category boundaries [6] | delq6_l | integer |
| 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 | integer |
| Number of payments between for next extension/deferment | pmt_btw_extdef_l | integer |
| 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.