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