| Description | Column | Datatype |
|---|---|---|
| Lease | lse_s | char (10) |
| Oracle row stamp | stamp_l | number (10) |
| Portfolio | por_s | char (2) |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Vendor | dlr_s | char (9) |
| Broker | brk_s | char (9) |
| Investor | inv_s | char (9) |
| Lessee number | les_s | char (9) |
| Delinquent lessee
Note: this field contains the lessee number if the lease is delinquent and is blank if the lease is not delinquent |
dles_s | char (9) |
| Lease date | d_lsd_s | date |
| Lease commencement date | d_com_s | date |
| System booking date | d_boo_s | date |
| Disbursement date | d_dis_s | date |
| Maturity date | d_mat_s | date |
| Date of last update | d_lup_s | date |
| Time of last update | t_lup_s | char (6) |
| Activity status date | d_act_s | date |
| Next payment due date | d_pmt_s | date |
| Accrued to date | d_acc_s | date |
| Last payment date | d_pay_s | date |
| Last payment due date | d_lst_s | date |
| Last rebook date | d_reb_s | date |
| Assumed lease date | d_ass_s | date |
| Payment extension date | d_pxt_s | date |
| Date of first payment extension | d_fxt_s | date |
| Lease extension date | d_lxt_s | date |
| Custom date 1 | d_cus1_s | date |
| First payment on suspension | d_susp_pmt_s | date |
| Date placed on suspension/non-accrual | d_susp_on_s | date |
| Effective date of suspension/non-accrual | d_susp_eff_s | date |
| Effective date of last payment | d_eff_s | date |
| System booking time | t_boo_s | char (6) |
| Documentation completion date | d_doc_comp_s | date |
| Date custom outstanding last updated
For use only by collection module |
d_lcus_s | date |
| Accounting month time stamp (YYYYMM)
This field contains a portion of ras.next_mth_s |
ym_acct_s | char (6) |
| Expiry date | d_expiry_date_s | date |
| PAP effective date | d_pap_eff_s | date |
| Activity status | act_s | char (4) |
| Accrual method lessor | acc_l_s | char (4) |
| Accrual method vendor | acc_d_s | char (4) |
| Accrual method investor | acc_i_s | char (4) |
| Lease source | dir_s | char (4) |
| Lease form code | frm_s | char (4) |
| Delinquency watch code | del_s | char (4) |
| Broker payment code | brk_pay_s | char (4) |
| Late charge assess | late_s | char (4) |
| Lease type code | ls_typ_s | char (4) |
| Extension method | ext_s | char (4) |
| Custom code 1 | c_cus1_s | char (4) |
| Custom code 2 | c_cus2_s | char (4) |
| Custom code 3 | c_cus3_s | char (4) |
| Purchase option billing method | po_meth_s | char (4) |
| Purchase option | pur_opt_s | char (4) |
| Purchase option owner | pur_opt_owner_s | char (4) |
| Maturing lease termination option | ml_optn_s | char (4) |
| Prime rate bank number | prim_num_s | char (4) |
| Late charge index | lat_ind_s | char (4) |
| IDC accounting method | idc_acct_s | char (4) |
| Product type code | prd_s | char (4) |
| Business/personal (B/P) | bus_c | char (1) |
| Type of lease, open or closed (O/C) | opn_c | char (1) |
| Payment due last accrual (Y/N) | due_lst_c | char (1) |
| Re-accrue income for last period (Y/N) | acc_by_c | char (1) |
| Assumed payment (Y/N) | a_pmt_c | char (1) |
| Backdated new lease (Y/N) | pre_brd_c | char (1) |
| Rebook allowed (Y/N) | reb_allow_c | char (1) |
| Lease extended (Y/N) | lse_ext_c | char (1) |
| Residual income separated (Y/N) | res_inc_c | char (1) |
| Purchase option billed (Y/N) | po_bill_c | char (1) |
| Lease booked using partial deductions module (Y/N) | partial_deductions_c | char (1) |
| Billing level (C/L/I)
C - Customer L - Lessee I - Individual |
b_lvl_c | char (1) |
| Statement code (I/C/F/N/' ')
I - individual invoice format C - coupon books F - group invoice format N - billing method outside of LeasePak |
stmt_c | char (1) |
| Late charges assessed since last accrual
A - Accrued, allow assessment of late charges L - Late charges assessed, disallow further late charges E - Preaccrued, enable assessment of late charges for prior period D - Preaccrued, disable further late charges for prior period |
acc_ltch_c | char (1) |
| Pre-authorize switch (Y/N) | pap_pmt_c | char (1) |
| Automatic charge off (Y/N/D)
Y - Lease will be automatically charged off after delinquent for more than 120 days. N - No automatic charge off. D - Lease will defer charge off for 1 month. |
auto_charge_c | char (1) |
| Cash/accrual basis for extension income (C/A) | ext_incm_ca_c | char (1) |
| Suspended IDC accrued allowed (Y/N) | susp_idc_allowed_c | char (1) |
| General description | desc_s | varchar2 (36) |
| Custom string 2 | s_cus2_s | char (10) |
| Trade-in description | trd_desc_s | varchar2 (36) |
| Clerk when removed from Matured Lease tracking | ini_mcur_s | char (3) |
| Customer number | cus_s | char (9) |
| Group number | grp_s | char (3) |
| Previous lease in group | prev_grp_s | char (10) |
| Next lease in group | next_grp_s | char (10) |
| Note attached to lease | note_s | char (10) |
| Index pointer (Cost of Funds) | index_pntr_s | char (4) |
| Investor/investor group of discounted lease | disc_invst_s | char (9) |
| Number of lease buyout quotes | buyout_quote_l | number (10) |
| Investor settlement deferral days | invst_defr_l | number (10) |
| Lease term | trm_l | number (10) |
| Estimated lease term | est_trm_l | number (10) |
| Number of payments accrued | pmt_l | number (10) |
| Number of assets on this lease | n_unt_l | number (10) |
| Number of times delinquent [1] | del1_l | number (10) |
| Number of times delinquent [2] | del2_l | number (10) |
| Number of times delinquent [3] | del3_l | number (10) |
| Number of times delinquent [4] | del4_l | number (10) |
| Payment due day | due_l | number (10) |
| Number of assumptions | ass_l | number (10) |
| Number of lease extensions | ext_l | number (10) |
| Number of payment extensions | pmt_ext_l | number (10) |
| Number of payment due date changes | due_ext_l | number (10) |
| Number of accruals to bypass | abp_l | number (10) |
| Number of late charge waivers | lat_wav_l | number (10) |
| Grace period in days | grc_l | number (10) |
| Number of payments processed | pmt_prcd_l | number (10) |
| Number of days delinquent
See notes for del_amt_d field |
days_delq_l | number (10) |
| Lessor yield | p_con_d | number (15,7) |
| Vendor yield | p_dly_d | number (15,7) |
| Investor yield factor | p_inv_yld_d | number (15,7) |
| Cost of funds | p_fund_d | number (15,5) |
| NPV discount rate | p_erly_pay_d | number (15,5) |
| IRR (yield) | p_irr_d | number (15,7) |
| IRR (yield) without residual | p_irr_nr_d | number (15,7) |
| Bad debt percentage | bad_debt_d | number (15,5) |
| Custom integer 1 | i_cus1_l | number (10) |
| Custom integer 2 | i_cus2_l | number (10) |
| Lessor rental simple rate | p_rent_d | number (15,5) |
| Lessor rental rate add-on | p_byrt_d | number (15,5) |
| Contract rental rate add-on | p_cntr_d | number (15,5) |
| Investor rental simple rate | p_rent_i_d | number (15,5) |
| Investor rental rate add-on | p_inv_d | number (15,5) |
| Vendor rental simple rate | p_rent_d_d | number (15,5) |
| Rate of participation | p_part_d | number (15,5) |
| Maximum interest rate - lease level | p_max_d | number (15,5) |
| Minimum interest rate - lease level | p_min_d | number (15,5) |
| Operating lease princpal/income adjustment | op_bill_adj_d | number (15,2) |
| Total acquisition cost | tot_org_d | number (15,2) |
| Other charges | tot_other_d | number (15,2) |
| Security deposit | sec_d | number (15,2) |
| Down payment | cap_d | number (15,2) |
| Documentation fee | up_d | number (15,2) |
| Interim rent | pro_d | number (15,2) |
| Broker fees | brk_fee_d | number (15,2) |
| Total initial direct costs | idc_d | number (15,2) |
| Residual amount
If tot_res_d is entered by the user, the value of p_res_d is erased. |
tot_res_d | number (15,2) |
| Guaranteed portion of residual | res_guar_d | number (15,2) |
| Mark up | mrk_up_d | number (15,2) |
| In-house fee | in_fee_d | number (15,2) |
| Accrued principal | prn_d | number (15,2) |
| Contract receivable | rec_d | number (15,2) |
| Principal receivable | prn_rec_d | number (15,2) |
| Net receipts Y-T-D (actual) | rec_ytd_actual_d | number (15,2) |
| Net receipts L-T-D (actual) | rec_ltd_d | number (15,2) |
| Rental income Y-T-D | rent_ytd_d | number (15,2) |
| Other income Y-T-D | oth_ytd_d | number (15,2) |
| Other income L-T-D | oth_ltd_d | number (15,2) |
| Lessor income Y-T-D | l_in_ytd_d | number (15,2) |
| Vendor income Y-T-D | d_in_ytd_d | number (15,2) |
| Investor income Y-T-D | i_in_ytd_d | number (15,2) |
| Lessor unearned rental income | l_ue_d | number (15,2) |
| Lessor orig unearned rental income | l_ue_org_d | number (15,2) |
| Lessor rental income accrued P-T-D | l_in_ptd_d | number (15,2) |
| Lessor current month rent income | l_in_cur_d | number (15,2) |
| Vendor current unearned rental income | d_ue_d | number (15,2) |
| Vendor original unearned rental | d_ue_org_d | number (15,2) |
| Vendor rental income accrued P-T-D | d_in_ptd_d | number (15,2) |
| Vendor rental income accrued, current month | d_in_cur_d | number (15,2) |
| Investor unearned rental income | i_ue_d | number (15,2) |
| Investor orig unearned rental income | i_ue_org_d | number (15,2) |
| Investor rental income accrued P-T-D | i_in_ptd_d | number (15,2) |
| Investor current month rental income | i_in_cur_d | number (15,2) |
| Monthly rental income | in_mly_d | number (15,2) |
| Monthly rental depreciation | dp_mly_d | number (15,2) |
| Late charge waiver amount | lat_wav_amt_d | number (15,2) |
| Unrecognized operating income | unrec_in_d | number (15,2) |
| Accumulated depreciation | acl_depr_d | number (15,2) |
| Broker fee accounts payable | brk_ap_d | number (15,2) |
| Amount of stub interest owed (-) or earned (+) | stub_amt_d | number (15,2) |
| Vendor payment receivable, current month | d_pmt_cur_d | number (15,2) |
| NPV of payment stream | npv_d | number (15,2) |
| Titling tax paid up-front | tax_paid_d | number (15,2) |
| Use tax accrued | tax_accr_d | number (15,2) |
| Custom float 1 | f_cus1_d | number (15,2) |
| Custom float 2 | f_cus2_d | number (15,2) |
| Custom float 3 | f_cus3_d | number (15,2) |
| Custom float 4 | f_cus4_d | number (15,2) |
| Custom float 5 | f_cus5_d | number (15,2) |
| Vendor receivable | d_rec_d | number (15,2) |
| Vendor payment participation unearned | d_part_ue_d | number (15,2) |
| Amount current paid | cur_paid_d | number (15,2) |
| Amount last paid | lst_paid_d | number (15,2) |
| Scheduled interest P-T-D | sch_int_ptd_d | number (15,2) |
| Unamortized IDC - book | idc_rem_d | number (15,2) |
| IDC current month amortization - book | idc_cur_d | number (15,2) |
| Leased assets
Starting cost of assets under lease |
lsd_unit_d | number (15,2) |
| Payment amount accrued Y-T-D | pmt_acc_d | number (15,2) |
| Residual income Y-T-D | r_in_ytd_d | number (15,2) |
| Unearned residual | r_ue_d | number (15,2) |
| Original unearned residual | r_ue_org_d | number (15,2) |
| Residual income accrued P-T-D | r_in_ptd_d | number (15,2) |
| Residual current month income | r_in_cur_d | number (15,2) |
| Suspended lessor income accrued | susp_l_acc_d | number (15,2) |
| Suspended vendor income accrued | susp_d_acc_d | number (15,2) |
| Suspended investor income accrued | susp_i_acc_d | number (15,2) |
| Suspended residual income accrued | susp_r_acc_d | number (15,2) |
| Suspended income collected | susp_col_d | number (15,2) |
| Fixed price purchase | fp_amt_d | number (15,2) |
| First payment suspended earnings | susp_frst_d | number (15,2) |
| Contract receivable (begin of year) | rec_boy_d | number (15,2) |
| Lessor unearned income (begin of year) | l_ue_boy_d | number (15,2) |
| Residual (beginning of year) | res_boy_d | number (15,2) |
| Y-T-D lessor unearned income changes | l_ue_chg_ytd_d | number (15,2) |
| Interest carryover | car_d | number (15,2) |
| Interest unpaid | int_unpd_d | number (15,2) |
| Principal paid Y-T-D | prn_ytd_d | number (15,2) |
| Principal paid L-T-D | prn_ltd_d | number (15,2) |
| Interest paid Y-T-D | int_pd_ytd_d | number (15,2) |
| Interest paid L-T-D | int_ltd_d | number (15,2) |
| Trade-in | trade_in_d | number (15,2) |
| Accrual amount to date (COF) | accrual_amt_to_date_d | number (15,2) |
| Total delinquent amount
Notes: 1. Used only by the collection module 2. Calculated only for delinquent leases 3. Only accurate as of the last time EOP Sequential Updates was run with the U1121 Collection switch on 4. Set to 0 for non-delinquent leases 5. These notes also apply to the gr_rec_d, net_out_d, gr_out_d, and days_delq_l fields |
del_amt_d | number (15,2) |
| Custom gross receivable
See notes for del_amt_d field |
gr_rec_d | number (15,2) |
| Custom net outstanding
See notes for del_amt_d field |
net_out_d | number (15,2) |
| Custom gross outstanding
See notes for del_amt_d field |
gr_out_d | number (15,2) |
| Excess mileage adjustment | ml_mile_d | number (15,2) |
| Wear and tear adjustment | ml_wear_d | number (15,2) |
| Proceeds of sale | ml_sale_d | number (15,2) |
| Book value | ml_book_d | number (15,2) |
| Tax IDC | idc_tax_d | number (15,2) |
| Unamortized IDC - tax | idc_rem_tax_d | number (15,2) |
| IDC current month amortization - tax | idc_cur_tax_d | number (15,2) |
| IDC Y-T-D amortization - tax | idc_ytd_tax_d | number (15,2) |
| IDC Y-T-D amount - book | idc_ytd_d | number (15,2) |
| Lessor income reduction Y-T-D | l_in_red_ytd_d | number (15,2) |
| Residual income reduction Y-T-D | r_in_red_ytd_d | number (15,2) |
| IDC reduction | idc_red_d | number (15,2) |
| IDC interest portion | idc_interest_d | number (15,2) |
| Accrual amount this month (COF) | accrual_amt_this_month_d | number (15,2) |
| Cost of funds 2 (For FCT) | p_fund2_d | number (15,5) |
| Number of automatic lease extensions | auto_ext_l | number (10) |
| Deferred extension income | dfrd_ext_incm_d | number (15,2) |
| Deferred residual reduction | dfrd_residual_red_d | number (15,2) |
| Suspended IDC accrued | susp_idc_acc_d | number (15,2) |
| Change lease key is in progress | msi_chg_key_c | char (1) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 |
|---|---|---|---|---|---|
| rls_idx0 | lse_s | ||||
| rls_idx1 | por_s | com_s | reg_s | off_s | lse_s |
| rls_idx2 | dlr_s | lse_s | |||
| rls_idx3 | brk_s | lse_s | |||
| rls_idx4 | inv_s | lse_s | |||
| rls_idx5 | les_s | lse_s | |||
| rls_idx6 | dles_s | lse_s |
| Table | Description |
|---|---|
| rlsa | Lease 2 |
| rlsb | Lease 3 |
| rlsc | Lease Partial Deduction |
| rlsp | Lease Payment Schedule |
| rlsr | Lease Recurring Charge |
| rlss | Lease Salesperson |
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.