| Description | Column | Datatype |
|---|---|---|
| Portfolio | por_s | char (2) |
| Record number | unique_l | number (10) |
| Oracle row stamp | stamp_l | number (10) |
| Gross receivable balance (Y/N) | grs_rec1_s | varchar2 (40) |
| Net outstanding balance (Y/N) | net_out1_s | varchar2 (40) |
| Gross outstanding balance (Y/N) | grs_out1_s | varchar2 (40) |
| Reversed deferment fee to suspense (Y/N) | rev_def_c | char (1) |
| Extension/deferment fee required (Y/N) | extdef_c | char (1) |
| Allow deferment residual update (Y/N) | def_res_c | char (1) |
| Dealer remittance bank code | dlr_rem_bank_s | char (3) |
| Automatic suspended days | auto_susp_l | number (10) |
| Automatic unsuspended days | auto_unsusp_l | number (10) |
| Recognize suspended income at payment (Y/N) | susp_inc_c | char (1) |
| Batch application status | batch_app_stat_s | char (4) |
| Late charge tolerance amount | ltch_tol_d | number (15,2) |
| Collection tolerance amount | coll_tol_d | number (15,2) |
| Assumption fee tolerance amount | asmf_tol_d | number (15,2) |
| Property tax tolerance amount | prtx_tol_d | number (15,2) |
| Legal fee tolerance amount | legf_tol_d | number (15,2) |
| Payment extension tolerance amount | pext_tol_d | number (15,2) |
| Lease extension tolerance amount | lext_tol_d | number (15,2) |
| ITC fee tolerance amount | itcf_tol_d | number (15,2) |
| Federal HWY use tax tolerance amount | fhut_tol_d | number (15,2) |
| Lease rewrite fee tolerance amount | lsrw_tol_d | number (15,2) |
| Other fee tolerance amount | othf_tol_d | number (15,2) |
| Sales/use tax tolerance amount | stax_tol_d | number (15,2) |
| Recurring charge tolerance amount [1] | rcr1_tol_d | number (15,2) |
| Recurring charge tolerance amount [2] | rcr2_tol_d | number (15,2) |
| Recurring charge tolerance amount [3] | rcr3_tol_d | number (15,2) |
| Recurring charge tolerance amount [4] | rcr4_tol_d | number (15,2) |
| Recurring charge tolerance amount [5] | rcr5_tol_d | number (15,2) |
| Recurring charge tolerance amount [6] | rcr6_tol_d | number (15,2) |
| Recurring charge tolerance amount [7] | rcr7_tol_d | number (15,2) |
| Recurring charge tolerance amount [8] | rcr8_tol_d | number (15,2) |
| Recurring charge tolerance amount [9] | rcr9_tol_d | number (15,2) |
| Recurring charge tolerance amount [10] | rcr10_tol_d | number (15,2) |
| Recurring charge tolerance amount [11] | rcr11_tol_d | number (15,2) |
| Recurring charge tolerance amount [12] | rcr12_tol_d | number (15,2) |
| Recurring charge tolerance amount [13] | rcr13_tol_d | number (15,2) |
| Recurring charge tolerance amount [14] | rcr14_tol_d | number (15,2) |
| Recurring charge tolerance amount [15] | rcr15_tol_d | number (15,2) |
| Maximum months that may be added via payment def/ext FIN | max_mths_add_fin_l | number (10) |
| Maximum months that may be added via payment def/ext OPR | max_mths_add_opr_l | number (10) |
| Reversal suspense limit in days | rev_susp_l | number (10) |
| Recurring charge for payoff invoice | payoff_invo_rcr_l | number (10) |
| Insurance finance (Y/N) | ins_fin_c | char (1) |
| Insurance policy fee | ins_pol_fee_d | number (15,2) |
| Include IDC and IDR in calculating IRR (Y/N) | idc_idr_in_irr_c | char (1) |
| Include open commission in calculating IRR (Y/N) | open_comm_in_irr_c | char (1) |
| Change book accounting and depreciation methods (Y/N) | chg_acct_bkd_c | char (1) |
| Principal write down (Y/N) | prn_write_down_c | char (1) |
| Automatic payoff of CSA leases (Y/N) | auto_payo_csa_c | char (1) |
| Calculate book depreciation on suspended leases (Y/N) | susp_bkd_c | char (1) |
| EOM pre-accrual and invoicing (Y/N) | eom_pre_acc_c | char (1) |
| Prorate income, IDC/IDR and depreciation (Y/N) | prorate_inc_idc_depr_c | char (1) |
| Take income on PRN payoff for suspended simple interest
lease (Y/N) |
take_incm_susp_prn_c | char (1) |
| Take income on OPR payoff for suspended operating
lease (Y/N) |
take_incm_susp_opr_c | char (1) |
| Take income on INV termination for suspended operating
lease (Y/N) |
take_incm_susp_inv_o_c | char (1) |
| Use third-party payoff quote (Y/N) | use_quote_c | char (1) |
| Default refund bank | refund_bank_s | char (3) |
| Refund check date deferral | refund_defr_l | number (10) |
| Asset percentage calculation method | unit_pct_calc_c | char (1) |
| Verify sum of payments (Y/N) | ver_sum_pmt_c | char (1) |
| OLB apply rent amount to base payoff (Y/N) | olb_rent_base_c | char (1) |
| NSF assessment code | nsf_assmt_code_s | char (4) |
| Post unbilled income to gain/loss (Y/N) | post_unb_gnls_c | char (1) |
| Take unrecognized OPR income at payoff (Y/N) | unrec_opr_inc_payo_c | char (1) |
| Notebook follow-up days | note_follow_up_l | number (10) |
| Template directory | template_path_s | varchar2 (120) |
| Document directory | doc_path_s | varchar2 (120) |
| Credit report directory | crd_rpt_path_s | varchar2 (120) |
| FASB 13 IRR for NPV calculation (A/B/C)
A - use p_con_d B - use p_irr_d C - use p_irr_nr_d |
fasb13_irr_c | char (1) |
| Calculate payment history (Y/N) | calc_pmt_hist_c | char (1) |
| Cost per use assessment code | cpu_assmt_code_s | char (4) |
| Recurring charge code for American Lease Insurance | rcr_ali_s | char (4) |
| Default bank code for security deposit disbursal | cc_sec_bank_s | char (3) |
| Hold security deposit in payoff/termination (Y/N) | hold_sec_c | char (1) |
| Period in days to hold security deposit before disbursal | hold_sec_days_l | number (10) |
| Index name | Piece 1 | Piece 2 |
|---|---|---|
| rpay_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.