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