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