rlsb Table: Lease 3
Oracle DBMS

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

Parent-Child: This table has a parent table--click here for a listing.

rlsb Columns

Description	Column Name	Data Type ?	Characteristics ?
Lease	lse_s	char	length 10
Record number	unique_l	number	precision 10
Record modification stamp	stamp_l	number	precision 10
Defer payment due date	d_defer_pmt_s	date	format YYYYMMDD
Final payment due date	d_final_pmt_s	date	format YYYYMMDD
Turn-in date	d_turn_in_s	date	format YYYYMMDD
Total tax credit	orig_tax_crd_d	number	precision 15, scale 2
Remaining tax credit	rem_tax_crd_d	number	precision 15, scale 2
Cumulative number of deferred months	def_mon_l	number	precision 10
Final monthly payment amount	final_pmt_d	number	precision 15, scale 2
Date of last payment reschedule	d_rsc_s	date	format YYYYMMDD
Date of last payment reschedule (RWT)	d_rsc_rwt_s	date	format YYYYMMDD
Date of last payment reschedule (DEF)	d_rsc_def_s	date	format YYYYMMDD
Number of payment reschedules (RWT)	pmt_rsc_rwt_l	number	precision 10
Number of payment reschedules (DEF)	pmt_rsc_def_l	number	precision 10
Maintenance fee (auditing only)	maint_fee_d	number	precision 15, scale 2
2nd 12-month payment history grid	pmt_hist2_s	char	length 12
Bankruptcy status code	bkrpt_stat_s	char	length 4
Previous bankruptcy status code	prev_bkrpt_stat_s	char	length 4
First payment default (Y/N)	first_pmt_default_c	char	length 1
Original MSRP amount	orig_x_msrp_d	number	precision 15, scale 2
Loan type	lt_s	char	length 4
Obligators liability	ob_liab_s	char	length 4
Previous repossesion (Y/N)	prev_repo_c	char	length 1
Write off reason	write_off_s	char	length 4
NSF counter	nsf_count_l	number	precision 10
Dealer reserves SL depreciation basis	idc_depr_l	number	precision 10
Acquisition fee SL depreciation basis	idrb_depr_l	number	precision 10
Estimated lessor income L-T-D	l_in_ltd_d	number	precision 15, scale 2
Alternate unearned IDC3	alt_idc3_ue_d	number	precision 15, scale 2
Alternate current IDC3	alt_idc3_cur_d	number	precision 15, scale 2
Alternate year to date IDC3	alt_idc3_ytd_d	number	precision 15, scale 2
Alternate unearned IDC4	alt_idc4_ue_d	number	precision 15, scale 2
Alternate current IDC4	alt_idc4_cur_d	number	precision 15, scale 2
Alternate year to date IDC4	alt_idc4_ytd_d	number	precision 15, scale 2
Alternate unearned IDC5	alt_idc5_ue_d	number	precision 15, scale 2
Alternate current IDC5	alt_idc5_cur_d	number	precision 15, scale 2
Alternate year to date IDC5	alt_idc5_ytd_d	number	precision 15, scale 2
Alternate unearned IDR5	alt_idr5_ue_d	number	precision 15, scale 2
Alternate current IDR5	alt_idr5_cur_d	number	precision 15, scale 2
Alternate year to date IDR5	alt_idr5_ytd_d	number	precision 15, scale 2
Alternate unearned IDR6	alt_idr6_ue_d	number	precision 15, scale 2
Alternate current IDR6	alt_idr6_cur_d	number	precision 15, scale 2
Alternate year to date IDR6	alt_idr6_ytd_d	number	precision 15, scale 2
Alternate unearned IDRB	alt_idrb_ue_d	number	precision 15, scale 2
Alternate current IDRB	alt_idrb_cur_d	number	precision 15, scale 2
Alternate year to date IDRB	alt_idrb_ytd_d	number	precision 15, scale 2
GL lessor income L-T-D	gl_in_ltd_d	number	precision 15, scale 2
GL lessor income M-T-D	gl_in_mtd_d	number	precision 15, scale 2
GL lessor income Y-T-D	gl_in_ytd_d	number	precision 15, scale 2
Back payment applied (Y/N)	back_pmt_appl_c	char	length 1
Revolving credit limit [1]	revolving_limit1_d	number	precision 15, scale 2
Revolving credit limit [2]	revolving_limit2_d	number	precision 15, scale 2
Revolving credit limit [3]	revolving_limit3_d	number	precision 15, scale 2
Revolving credit limit [4]	revolving_limit4_d	number	precision 15, scale 2
Revolving credit limit effective date [1]	d_revolving_limit_eff1_s	date	format YYYYMMDD
Revolving credit limit effective date [2]	d_revolving_limit_eff2_s	date	format YYYYMMDD
Revolving credit limit effective date [3]	d_revolving_limit_eff3_s	date	format YYYYMMDD
Revolving credit limit effective date [4]	d_revolving_limit_eff4_s	date	format YYYYMMDD
Revolving credit line fee	p_revolving_line_fee_d	number	precision 15, scale 5
Customer yield	p_cus_d	number	precision 15, scale 7
Insurance risk fee rate	p_ins_risk_fee_d	number	precision 15, scale 5
Insurance risk fee code	ins_risk_fee_s	char	length 4
Date of last insurance risk fee assessment	d_last_ins_risk_fee_s	date	format YYYYMMDD
PAP bank account name	payer_acct_nam_s	varchar2	length 50
Deferred income amount	def_inc_d	number	precision 15, scale 2
Deferred IDC amount	def_idc_d	number	precision 15, scale 2
Deferred IDC1 amount	def_idc1_d	number	precision 15, scale 2
Deferred IDC2 amount	def_idc2_d	number	precision 15, scale 2
Deferred IDR1 amount	def_idr1_d	number	precision 15, scale 2
Deferred IDR2 amount	def_idr2_d	number	precision 15, scale 2
Deferred IDR3 amount	def_idr3_d	number	precision 15, scale 2
Deferred IDR4 amount	def_idr4_d	number	precision 15, scale 2
Number of payment reschedules (RSC)	pmt_rsc_rsc_l	number	precision 10
Date of last leveraged table download	d_lst_lvr_s	date	format YYYYMMDD
Leveraged commencement date	d_lvr_com_s	date	format YYYYMMDD
Leveraged (Y/N)	lvr_c	char	length 1
Number of leveraged table download	lvr_l	number	precision 10
Leveraged term	lvr_trm_l	number	precision 10
Staged equity amount	stg_eqty_d	number	precision 15, scale 2
Staged equity account payable	stg_eqty_ap_d	number	precision 15, scale 2
Taxable income Y-T-D amount	tax_inc_ytd_d	number	precision 15, scale 2
FSC exclusion Y-T-D amount	fsc_ytd_d	number	precision 15, scale 2
Interest expenses Y-T-D amount	int_expn_ytd_d	number	precision 15, scale 2
Strategic grouping for behaviour scoring	strat_grp_c	char	length 1
Risk band for behavior scoring	risk_band_c	char	length 1
Account behavior score	acct_bhv_scr_s	char	length 8
External strategy for behavior scoring	ext_strat_s	char	length 4
Staged equity fund payable to	stg_eqty_pay_to_s	char	length 9
Deferred tax YTD amount	dfrd_tax_ytd_d	number	precision 15, scale 2
Non-pyramiding late charge minimum payment due	npyr_min_d	number	precision 15, scale 2
IDC amortization add-on interest rate	p_idc_addon_d	number	precision 15, scale 5
IDC amortization interest rate	p_idc_amort_d	number	precision 15, scale 5
Schedule principal	sch_prn_d	number	precision 15, scale 2
Late charge date	d_ltch_s	date	format YYYYMMDD
Late charge assessed prior to last accrual (Y/N)	prev_ltch_c	char	length 1
Invoice due date overlap (Y/N)	due_overlap_c	char	length 1
Valuation reserve	valuat_res_d	number	precision 15, scale 2
Recovery	recovery_d	number	precision 15, scale 2
Optional residual	opt_res_d	number	precision 15, scale 2
Non commission amount	non_comm_d	number	precision 15, scale 2
Security deposit refund amount	sec_refund_d	number	precision 15, scale 2
Principal write down (Y/N)	prn_write_down_c	char	length 1
Metro2 file format code	metro2_s	char	length 4
Date of first delinquency	d_first_delq_s	date	format YYYYMMDD
Invoice format code	invo_format_s	char	length 4
Security deposit disbursal status (P/U/N) P - processed U - unprocessed N - n/a	sec_status_c	char	length 1
Sales/use tax exempt code	stax_exempt_s	char	length 4
Cash Control used (Y/N)	cash_control_used_c	char	length 1
Last OFSA (Oracle Fin Svcs Apps) run date	d_last_ofsa_s	date	format YYYYMMDD
Payoff quote preparation date	d_payoff_quote_s	date	format YYYYMMDD
Custom payoff quote amount [1]	custom_payoff_quote1_d	number	precision 15, scale 2
Custom payoff quote amount [2]	custom_payoff_quote2_d	number	precision 15, scale 2
Custom payoff quote amount [3]	custom_payoff_quote3_d	number	precision 15, scale 2
Custom payoff quote amount [4]	custom_payoff_quote4_d	number	precision 15, scale 2
Custom payoff quote amount [5]	custom_payoff_quote5_d	number	precision 15, scale 2
Ad hoc PAP amount	adhoc_pap_d	number	precision 15, scale 2
Ad hoc effective date	d_adhoc_eff_s	date	format YYYYMMDD
Set float rate on business or calendar day (P/F/C) P - previous business day F - following business day C - calendar day	float_bus_or_cal_c	char	length 1
Frequency of float rate setting DAY - daily MON - monthly QTR - quarterly SEMI - semiannually ANNL - annually NONE - rate setting functionality is disabled	float_frq_s	char	length 4
Day of month on which float rate is set (1-31 or 0) A value of zero indicates that the rate setting functionality has been disabled.	float_day_l	number	precision 10
Month in which float rate is set (1-12 or 0) 0 - if frequency is NONE, MON or DAY 1 to 3 - if frequency is QTR 1 to 6 - if frequency is SEMI 1 to 12 - if frequency is ANNL	float_mon_l	number	precision 10
Float base rate percentage	p_float_base_d	number	precision 15, scale 5
Calendar to use for determining business days	calendar_s	char	length 4
Original dealer-received payments	orig_dlr_rec_pmt_d	number	precision 15, scale 2
Dealer payments batch number	dlr_pmt_batch_num_s	varchar2	length 20
Contract end date	d_cntr_end_s	date	format YYYYMMDD
Has recurring charge payment schedule (Y/N)	rcr_pmt_sched_c	char	length 1
Recurring charge payment schedule in synch with lease (Y/N)	rcr_synch_c	char	length 1
Has asset level payment schedule (Y/N)	asset_lvl_c	char	length 1
Has assessment description (Y/N)	assmt_desc_c	char	length 1

rlsb Indexes

Index Name	Piece 1	Piece 2
rlsb_idx0	lse_s	unique_l

Parent Table Listing

Table Name	Description
rls	Lease

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 6.1a Documentation Suite

© 2008 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.