Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
lse_s |
Lease |
char(10) |
no |
timestamp |
Record modification stamp |
timestamp |
yes |
por_s |
Portfolio |
char(2) |
no |
com_s |
Company |
char(2) |
no |
reg_s |
Region |
char(2) |
no |
off_s |
Office |
char(3) |
no |
dlr_s |
Vendor |
char(9) |
no |
brk_s |
Broker |
char(9) |
no |
inv_s |
Investor |
char(9) |
no |
les_s |
Lessee number |
char(9) |
no |
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) |
no |
d_lsd_s |
Lease date |
datetime |
yes |
d_com_s |
Lease commencement date used for calculations
rls.d_com_s is set to rlsb.d_org_com_s at booking and
whenever an extension occurs. It may later be changed
to another date based on lease adjustments. |
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
Notes:
1. Used only by the collection module
2. Calculated only for delinquent leases
3. Only accurate as of the last time EOP Sequential
Updates was run with the U1121 Collection switch on
4. Set to 0 for non-delinquent leases
5. These notes also apply to the gr_rec_d, net_out_d,
gr_out_d, and days_delq_l fields |
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 |