| 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 |