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 |