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