ColumnsIndexessp1Childsp2rlsarlsbrlscrlsprlsrrlss

rls Table: Lease
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rls Lease table.

Parent-Child: This table has one or more child tables--click here for a listing.

rls Columns

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

rls Indexes

Index Name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 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

Child Table Listing

Table Name	Description
rlsa	Lease 2
rlsb	Lease 3
rlsc	Lease Partial Deduction
rlsp	Lease Payment Schedule
rlsr	Lease Recurring Charge
rlss	Lease Salesperson

Data Type Definitions and Characteristics

Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.

char

Oracle fixed length character string. Typically used to store short-length string data such as keys, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

date

Oracle date and time, containing century, year, month, day, hour, minute, and second information.
Characteristics:

• format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

number

Oracle numeric data type. Used for all numbers.
Characteristics:

• precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
• scale - The fractional granularity, meaning the maximum number of places available to the right of the decimal point.

varchar2

Oracle variable length character string. Typically used to store medium and long-length string data such as names, addresses, descriptions, and notebook entries.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

LeasePak Documentation Suite

© by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.