| Name | Segment 1 | Segment 2 | Segment 3 | 
|---|---|---|---|
| rhf_idx0 | lse_s | ext_num_s | cycle_num_s | 
| 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 | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| 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  | 
datetime | yes | 
| d_com_s | Lease commencement date used for calculations  | 
datetime | yes | 
| d_boo_s | System booking date  | 
datetime | yes | 
| d_dis_s | Disbursement date  | 
datetime | yes | 
| d_mat_s | Maturity date  | 
datetime | yes | 
| d_lup_s | Date of last update  | 
datetime | yes | 
| t_lup_s | Time of last update  | 
char(6) | yes | 
| d_act_s | Activity status date  | 
datetime | yes | 
| d_pmt_s | Next payment due date  | 
datetime | yes | 
| d_acc_s | Accrued to date  | 
datetime | yes | 
| d_pay_s | Last payment date  | 
datetime | yes | 
| d_lst_s | Last payment due date  | 
datetime | yes | 
| d_reb_s | Last rebook date  | 
datetime | yes | 
| d_ass_s | Assumed lease date  | 
datetime | yes | 
| d_pxt_s | Payment extension date  | 
datetime | yes | 
| d_fxt_s | Date of first payment extension  | 
datetime | yes | 
| d_lxt_s | Lease extension date  | 
datetime | yes | 
| d_cus1_s | Custom date 1  | 
datetime | yes | 
| d_susp_pmt_s | First payment on suspension  | 
datetime | yes | 
| d_susp_on_s | Date placed on suspension/non-accrual  | 
datetime | yes | 
| d_susp_eff_s | Effective date of suspension/non-accrual  | 
datetime | yes | 
| d_eff_s | Effective date of last payment  | 
datetime | yes | 
| t_boo_s | System booking time  | 
char(6) | yes | 
| d_doc_comp_s | Documentation completion date  | 
datetime | yes | 
| d_lcus_s | Date custom outstanding last updated For use only by collection module  | 
datetime | 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  | 
datetime | yes | 
| d_pap_eff_s | PAP effective date  | 
datetime | 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  | 
char(36) | yes | 
| s_cus2_s | Custom string 2  | 
char(10) | yes | 
| trd_desc_s | Trade-in description  | 
char(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  | 
integer | yes | 
| invst_defr_l | Investor settlement deferral days  | 
integer | yes | 
| trm_l | Lease term  | 
integer | yes | 
| est_trm_l | Estimated lease term  | 
integer | yes | 
| pmt_l | Number of payments accrued  | 
integer | yes | 
| n_unt_l | Number of assets on this lease  | 
integer | yes | 
| del1_l | Number of times delinquent [1]  | 
integer | yes | 
| del2_l | Number of times delinquent [2]  | 
integer | yes | 
| del3_l | Number of times delinquent [3]  | 
integer | yes | 
| del4_l | Number of times delinquent [4]  | 
integer | yes | 
| due_l | Payment due day  | 
integer | yes | 
| ass_l | Number of assumptions  | 
integer | yes | 
| ext_l | Number of lease extensions  | 
integer | yes | 
| pmt_ext_l | Number of payment extensions  | 
integer | yes | 
| due_ext_l | Number of payment due date changes  | 
integer | yes | 
| abp_l | Number of accruals to bypass  | 
integer | yes | 
| lat_wav_l | Number of late charge waivers  | 
integer | yes | 
| grc_l | Grace period in days  | 
integer | yes | 
| pmt_prcd_l | Number of payments processed  | 
integer | yes | 
| days_delq_l | Number of days delinquent See notes for del_amt_d field  | 
integer | yes | 
| p_con_d | Lessor yield  | 
double precision | yes | 
| p_dly_d | Vendor yield  | 
double precision | yes | 
| p_inv_yld_d | Investor yield factor  | 
double precision | yes | 
| p_fund_d | Cost of funds  | 
double precision | yes | 
| p_erly_pay_d | NPV discount rate  | 
double precision | yes | 
| p_irr_d | IRR (yield)  | 
double precision | yes | 
| p_irr_nr_d | IRR (yield) without residual  | 
double precision | yes | 
| bad_debt_d | Bad debt percentage  | 
double precision | yes | 
| i_cus1_l | Custom integer 1  | 
integer | yes | 
| i_cus2_l | Custom integer 2  | 
integer | yes | 
| p_rent_d | Lessor rental simple rate  | 
double precision | yes | 
| p_byrt_d | Lessor rental rate add-on  | 
double precision | yes | 
| p_cntr_d | Contract rental rate add-on  | 
double precision | yes | 
| p_rent_i_d | Investor rental simple rate  | 
double precision | yes | 
| p_inv_d | Investor rental rate add-on  | 
double precision | yes | 
| p_rent_d_d | Vendor rental simple rate  | 
double precision | yes | 
| p_part_d | Rate of participation  | 
double precision | yes | 
| p_max_d | Maximum interest rate - lease level  | 
double precision | yes | 
| p_min_d | Minimum interest rate - lease level  | 
double precision | yes | 
| op_bill_adj_d | Operating lease princpal/income adjustment  | 
double precision | yes | 
| tot_org_d | Total acquisition cost  | 
double precision | yes | 
| tot_other_d | Other charges  | 
double precision | yes | 
| sec_d | Security deposit  | 
double precision | yes | 
| cap_d | Down payment  | 
double precision | yes | 
| up_d | Documentation fee  | 
double precision | yes | 
| pro_d | Interim rent  | 
double precision | yes | 
| brk_fee_d | Broker fees  | 
double precision | yes | 
| idc_d | Total initial direct costs  | 
double precision | yes | 
| tot_res_d | Residual amount If tot_res_d is entered by the user, the value of p_res_d is erased.  | 
double precision | yes | 
| res_guar_d | Guaranteed portion of residual  | 
double precision | yes | 
| mrk_up_d | Mark up  | 
double precision | yes | 
| in_fee_d | In-house fee  | 
double precision | yes | 
| prn_d | Accrued principal  | 
double precision | yes | 
| rec_d | Contract receivable  | 
double precision | yes | 
| prn_rec_d | Principal receivable  | 
double precision | yes | 
| rec_ytd_actual_d | Net receipts Y-T-D (actual)  | 
double precision | yes | 
| rec_ltd_d | Net receipts L-T-D (actual)  | 
double precision | yes | 
| rent_ytd_d | Rental income Y-T-D  | 
double precision | yes | 
| oth_ytd_d | Other income Y-T-D  | 
double precision | yes | 
| oth_ltd_d | Other income L-T-D  | 
double precision | yes | 
| l_in_ytd_d | Lessor income Y-T-D  | 
double precision | yes | 
| d_in_ytd_d | Vendor income Y-T-D  | 
double precision | yes | 
| i_in_ytd_d | Investor income Y-T-D  | 
double precision | yes | 
| l_ue_d | Lessor unearned rental income  | 
double precision | yes | 
| l_ue_org_d | Lessor orig unearned rental income  | 
double precision | yes | 
| l_in_ptd_d | Lessor rental income accrued P-T-D  | 
double precision | yes | 
| l_in_cur_d | Lessor current month rent income  | 
double precision | yes | 
| d_ue_d | Vendor current unearned rental income  | 
double precision | yes | 
| d_ue_org_d | Vendor original unearned rental  | 
double precision | yes | 
| d_in_ptd_d | Vendor rental income accrued P-T-D  | 
double precision | yes | 
| d_in_cur_d | Vendor rental income accrued, current month  | 
double precision | yes | 
| i_ue_d | Investor unearned rental income  | 
double precision | yes | 
| i_ue_org_d | Investor original unearned rental income  | 
double precision | yes | 
| i_in_ptd_d | Investor rental income accrued P-T-D  | 
double precision | yes | 
| i_in_cur_d | Investor current month rental income  | 
double precision | yes | 
| in_mly_d | Monthly rental income  | 
double precision | yes | 
| dp_mly_d | Monthly rental depreciation  | 
double precision | yes | 
| lat_wav_amt_d | Late charge waiver amount  | 
double precision | yes | 
| unrec_in_d | Unrecognized operating income  | 
double precision | yes | 
| acl_depr_d | Accumulated depreciation  | 
double precision | yes | 
| brk_ap_d | Broker fee accounts payable  | 
double precision | yes | 
| stub_amt_d | Amount of stub interest owed (-) or earned (+)  | 
double precision | yes | 
| d_pmt_cur_d | Vendor payment receivable, current month  | 
double precision | yes | 
| npv_d | NPV of payment stream  | 
double precision | yes | 
| tax_paid_d | Titling tax paid up-front  | 
double precision | yes | 
| tax_accr_d | Use tax accrued  | 
double precision | yes | 
| f_cus1_d | Custom float 1  | 
double precision | yes | 
| f_cus2_d | Custom float 2  | 
double precision | yes | 
| f_cus3_d | Custom float 3  | 
double precision | yes | 
| f_cus4_d | Custom float 4  | 
double precision | yes | 
| f_cus5_d | Custom float 5  | 
double precision | yes | 
| d_rec_d | Vendor receivable  | 
double precision | yes | 
| d_part_ue_d | Vendor payment participation unearned  | 
double precision | yes | 
| cur_paid_d | Amount current paid  | 
double precision | yes | 
| lst_paid_d | Amount last paid  | 
double precision | yes | 
| sch_int_ptd_d | Scheduled interest P-T-D  | 
double precision | yes | 
| idc_rem_d | Unamortized IDC - book  | 
double precision | yes | 
| idc_cur_d | IDC current month amortization - book  | 
double precision | yes | 
| lsd_unit_d | Leased assets Starting cost of assets under lease  | 
double precision | yes | 
| pmt_acc_d | Payment amount accrued Y-T-D  | 
double precision | yes | 
| r_in_ytd_d | Residual income Y-T-D  | 
double precision | yes | 
| r_ue_d | Unearned residual  | 
double precision | yes | 
| r_ue_org_d | Original unearned residual  | 
double precision | yes | 
| r_in_ptd_d | Residual income accrued P-T-D  | 
double precision | yes | 
| r_in_cur_d | Residual current month income  | 
double precision | yes | 
| susp_l_acc_d | Suspended lessor income accrued  | 
double precision | yes | 
| susp_d_acc_d | Suspended vendor income accrued  | 
double precision | yes | 
| susp_i_acc_d | Suspended investor income accrued  | 
double precision | yes | 
| susp_r_acc_d | Suspended residual income accrued  | 
double precision | yes | 
| susp_col_d | Suspended income collected  | 
double precision | yes | 
| fp_amt_d | Fixed price purchase  | 
double precision | yes | 
| susp_frst_d | First payment suspended earnings  | 
double precision | yes | 
| rec_boy_d | Contract receivable (begin of year)  | 
double precision | yes | 
| l_ue_boy_d | Lessor unearned income (begin of year)  | 
double precision | yes | 
| res_boy_d | Residual (beginning of year)  | 
double precision | yes | 
| l_ue_chg_ytd_d | Y-T-D lessor unearned income changes  | 
double precision | yes | 
| car_d | Interest carryover  | 
double precision | yes | 
| int_unpd_d | Interest unpaid  | 
double precision | yes | 
| prn_ytd_d | Principal paid Y-T-D  | 
double precision | yes | 
| prn_ltd_d | Principal paid L-T-D  | 
double precision | yes | 
| int_pd_ytd_d | Interest paid Y-T-D  | 
double precision | yes | 
| int_ltd_d | Interest paid L-T-D  | 
double precision | yes | 
| trade_in_d | Trade-in  | 
double precision | yes | 
| accrual_amt_to_date_d | Accrual amount to date (COF)  | 
double precision | yes | 
| del_amt_d | Total delinquent amount  | 
double precision | yes | 
| gr_rec_d | Custom gross receivable See notes for del_amt_d field  | 
double precision | yes | 
| net_out_d | Custom net outstanding See notes for del_amt_d field  | 
double precision | yes | 
| gr_out_d | Custom gross outstanding See notes for del_amt_d field  | 
double precision | yes | 
| ml_mile_d | Excess mileage adjustment  | 
double precision | yes | 
| ml_wear_d | Wear and tear adjustment  | 
double precision | yes | 
| ml_sale_d | Proceeds of sale  | 
double precision | yes | 
| ml_book_d | Book value  | 
double precision | yes | 
| idc_tax_d | Tax IDC  | 
double precision | yes | 
| idc_rem_tax_d | Unamortized IDC - tax  | 
double precision | yes | 
| idc_cur_tax_d | IDC current month amortization - tax  | 
double precision | yes | 
| idc_ytd_tax_d | IDC Y-T-D amortization - tax  | 
double precision | yes | 
| idc_ytd_d | IDC Y-T-D amount - book  | 
double precision | yes | 
| l_in_red_ytd_d | Lessor income reduction Y-T-D  | 
double precision | yes | 
| r_in_red_ytd_d | Residual income reduction Y-T-D  | 
double precision | yes | 
| idc_red_d | IDC reduction  | 
double precision | yes | 
| idc_interest_d | IDC interest portion  | 
double precision | yes | 
| tot_cap_int_d | Total capitalized interest  | 
double precision | yes | 
| p_fund2_d | Cost of funds 2 (For FCT)  | 
double precision | yes | 
| auto_ext_l | Number of automatic lease extensions  | 
integer | yes | 
| dfrd_ext_incm_d | Deferred extension income  | 
double precision | yes | 
| dfrd_residual_red_d | Deferred residual reduction  | 
double precision | yes | 
| susp_idc_acc_d | Suspended IDC accrued  | 
double precision | yes | 
| msi_chg_key_c | Change lease key is in progress  | 
char(1) | yes |