rls Table: Lease
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rls Table: Lease

Child Tables

Name Description
rlsa Lease 2
rlsb Lease 3
rlsc Lease Partial Deduction
rlsd Lease 4
rlsp Lease Payment Schedule
rlsr Lease Recurring Charge
rlss Lease Salesperson
rlsv Lease Subvention

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rls_idx0 lse_s        
rls_idx1 por_s com_s reg_s off_s lse_s
rls_idx2 dlr_s lse_s      
rls_idx3 brk_s lse_s      
rls_idx4 inv_s lse_s      
rls_idx5 les_s lse_s      
rls_idx6 dles_s lse_s      

     
Columns
Name DescriptionDatatype ¿? 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