rlsb Table: Lease 3
Sybase DBMS

Specifies the columns and rows with Sybase 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(10)
Record number	unique_l	integer
Record modification stamp	timestamp	timestamp
Defer payment due date	d_defer_pmt_s	datetime
Final payment due date	d_final_pmt_s	datetime
Turn-in date	d_turn_in_s	datetime
Total tax credit	orig_tax_crd_d	double precision
Remaining tax credit	rem_tax_crd_d	double precision
Cumulative number of deferred months	def_mon_l	integer
Final monthly payment amount	final_pmt_d	double precision
Date of last payment reschedule	d_rsc_s	datetime
Date of last payment reschedule (RWT)	d_rsc_rwt_s	datetime
Date of last payment reschedule (DEF)	d_rsc_def_s	datetime
Number of payment reschedules (RWT)	pmt_rsc_rwt_l	integer
Number of payment reschedules (DEF)	pmt_rsc_def_l	integer
Maintenance fee (auditing only)	maint_fee_d	double precision
2nd 12-month payment history grid	pmt_hist2_s	char(12)
Bankruptcy status code	bkrpt_stat_s	char(4)
Previous bankruptcy status code	prev_bkrpt_stat_s	char(4)
First payment default (Y/N)	first_pmt_default_c	char(1)
Original MSRP amount	orig_x_msrp_d	double precision
Loan type	lt_s	char(4)
Obligators liability	ob_liab_s	char(4)
Previous repossesion (Y/N)	prev_repo_c	char(1)
Write off reason	write_off_s	char(4)
NSF counter	nsf_count_l	integer
Dealer reserves SL depreciation basis	idc_depr_l	integer
Acquisition fee SL depreciation basis	idrb_depr_l	integer
Estimated lessor income L-T-D	l_in_ltd_d	double precision
Alternate unearned IDC3	alt_idc3_ue_d	double precision
Alternate current IDC3	alt_idc3_cur_d	double precision
Alternate year to date IDC3	alt_idc3_ytd_d	double precision
Alternate unearned IDC4	alt_idc4_ue_d	double precision
Alternate current IDC4	alt_idc4_cur_d	double precision
Alternate year to date IDC4	alt_idc4_ytd_d	double precision
Alternate unearned IDC5	alt_idc5_ue_d	double precision
Alternate current IDC5	alt_idc5_cur_d	double precision
Alternate year to date IDC5	alt_idc5_ytd_d	double precision
Alternate unearned IDR5	alt_idr5_ue_d	double precision
Alternate current IDR5	alt_idr5_cur_d	double precision
Alternate year to date IDR5	alt_idr5_ytd_d	double precision
Alternate unearned IDR6	alt_idr6_ue_d	double precision
Alternate current IDR6	alt_idr6_cur_d	double precision
Alternate year to date IDR6	alt_idr6_ytd_d	double precision
Alternate unearned IDRB	alt_idrb_ue_d	double precision
Alternate current IDRB	alt_idrb_cur_d	double precision
Alternate year to date IDRB	alt_idrb_ytd_d	double precision
GL lessor income L-T-D	gl_in_ltd_d	double precision
GL lessor income M-T-D	gl_in_mtd_d	double precision
GL lessor income Y-T-D	gl_in_ytd_d	double precision
Back payment applied (Y/N)	back_pmt_appl_c	char(1)
Revolving credit limit [1]	revolving_limit1_d	double precision
Revolving credit limit [2]	revolving_limit2_d	double precision
Revolving credit limit [3]	revolving_limit3_d	double precision
Revolving credit limit [4]	revolving_limit4_d	double precision
Revolving credit limit effective date [1]	d_revolving_limit_eff1_s	datetime
Revolving credit limit effective date [2]	d_revolving_limit_eff2_s	datetime
Revolving credit limit effective date [3]	d_revolving_limit_eff3_s	datetime
Revolving credit limit effective date [4]	d_revolving_limit_eff4_s	datetime
Revolving credit line fee	p_revolving_line_fee_d	double precision
Customer yield	p_cus_d	double precision
Insurance risk fee rate	p_ins_risk_fee_d	double precision
Insurance risk fee code	ins_risk_fee_s	char(4)
Date of last insurance risk fee assessment	d_last_ins_risk_fee_s	datetime
PAP bank account name	payer_acct_nam_s	char(50)
Deferred income amount	def_inc_d	double precision
Deferred IDC amount	def_idc_d	double precision
Deferred IDC1 amount	def_idc1_d	double precision
Deferred IDC2 amount	def_idc2_d	double precision
Deferred IDR1 amount	def_idr1_d	double precision
Deferred IDR2 amount	def_idr2_d	double precision
Deferred IDR3 amount	def_idr3_d	double precision
Deferred IDR4 amount	def_idr4_d	double precision
Number of payment reschedules (RSC)	pmt_rsc_rsc_l	integer
Date of last leveraged table download	d_lst_lvr_s	datetime
Leveraged commencement date	d_lvr_com_s	datetime
Leveraged (Y/N)	lvr_c	char(1)
Number of leveraged table download	lvr_l	integer
Leveraged term	lvr_trm_l	integer
Staged equity amount	stg_eqty_d	double precision
Staged equity account payable	stg_eqty_ap_d	double precision
Taxable income Y-T-D amount	tax_inc_ytd_d	double precision
FSC exclusion Y-T-D amount	fsc_ytd_d	double precision
Interest expenses Y-T-D amount	int_expn_ytd_d	double precision
Strategic grouping for behaviour scoring	strat_grp_c	char(1)
Risk band for behavior scoring	risk_band_c	char(1)
Account behavior score	acct_bhv_scr_s	char(8)
External strategy for behavior scoring	ext_strat_s	char(4)
Staged equity fund payable to	stg_eqty_pay_to_s	char(9)
Deferred tax YTD amount	dfrd_tax_ytd_d	double precision
Non-pyramiding late charge minimum payment due	npyr_min_d	double precision
IDC amortization add-on interest rate	p_idc_addon_d	double precision
IDC amortization interest rate	p_idc_amort_d	double precision
Schedule principal	sch_prn_d	double precision
Late charge date	d_ltch_s	datetime
Late charge assessed prior to last accrual (Y/N)	prev_ltch_c	char(1)
Invoice due date overlap (Y/N)	due_overlap_c	char(1)
Valuation reserve	valuat_res_d	double precision
Recovery	recovery_d	double precision
Optional residual	opt_res_d	double precision
Non commission amount	non_comm_d	double precision
Security deposit refund amount	sec_refund_d	double precision
Principal write down (Y/N)	prn_write_down_c	char(1)
Metro2 file format code	metro2_s	char(4)
Date of first delinquency	d_first_delq_s	datetime
Invoice format code	invo_format_s	char(4)
Security deposit disbursal status (P/U/N)   P - processed   U - unprocessed   N - n/a	sec_status_c	char(1)
Sales/use tax exempt code	stax_exempt_s	char(4)
Cash Control used (Y/N)	cash_control_used_c	char(1)
Last OFSA (Oracle Fin Svcs Apps) run date	d_last_ofsa_s	datetime
Payoff quote preparation date	d_payoff_quote_s	datetime
Custom payoff quote amount [1]	custom_payoff_quote1_d	double precision
Custom payoff quote amount [2]	custom_payoff_quote2_d	double precision
Custom payoff quote amount [3]	custom_payoff_quote3_d	double precision
Custom payoff quote amount [4]	custom_payoff_quote4_d	double precision
Custom payoff quote amount [5]	custom_payoff_quote5_d	double precision
Ad hoc PAP amount	adhoc_pap_d	double precision
Ad hoc effective date	d_adhoc_eff_s	datetime
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(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(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	integer
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	integer
Float base rate percentage	p_float_base_d	double precision
Calendar to use for determining business days	calendar_s	char(4)
Original dealer-received payments	orig_dlr_rec_pmt_d	double precision
Dealer payments batch number	dlr_pmt_batch_num_s	char(20)
Contract end date	d_cntr_end_s	datetime
Has recurring charge payment schedule (Y/N)	rcr_pmt_sched_c	char(1)
Recurring charge payment schedule in synch with lease (Y/N)	rcr_synch_c	char(1)
Has asset level payment schedule (Y/N)	asset_lvl_c	char(1)
Has assessment description (Y/N)	assmt_desc_c	char(1)
Extension income on cash or accrual basis before   payoff (C/A/N)    C - Cash    A - Accrual    N - Not decided	ext_incm_ca_before_pf_c	char(1)
Assumption fees manual assessment L-T-D	asmf_man_ltd_d	double precision
Collection fees manual assessment L-T-D	coll_man_ltd_d	double precision
Federal highway use tax manual assessment L-T-D	fhut_man_ltd_d	double precision
ITC fees manual assessment L-T-D	itcf_man_ltd_d	double precision
Legal fees manual assessment L-T-D	legf_man_ltd_d	double precision
Lease extension fees manual assessment L-T-D	lext_man_ltd_d	double precision
Lease re-write fees manual assessment L-T-D	lsrw_man_ltd_d	double precision
Late charges manual assessment L-T-D	ltch_man_ltd_d	double precision
Other fees manual assessment L-T-D	othf_man_ltd_d	double precision
Payment extension fees manual assessment L-T-D	pext_man_ltd_d	double precision
Property tax manual assessment L-T-D	prtx_man_ltd_d	double precision
Sales/Use tax manual assessment L-T-D	stax_man_ltd_d	double precision
Recurring charge manual assessment L-T-D [1]	rcr_man_ltd1_d	double precision
Recurring charge manual assessment L-T-D [2]	rcr_man_ltd2_d	double precision
Recurring charge manual assessment L-T-D [3]	rcr_man_ltd3_d	double precision
Recurring charge manual assessment L-T-D [4]	rcr_man_ltd4_d	double precision
Recurring charge manual assessment L-T-D [5]	rcr_man_ltd5_d	double precision
Recurring charge manual assessment L-T-D [6]	rcr_man_ltd6_d	double precision
Recurring charge manual assessment L-T-D [7]	rcr_man_ltd7_d	double precision
Recurring charge manual assessment L-T-D [8]	rcr_man_ltd8_d	double precision
Recurring charge manual assessment L-T-D [9]	rcr_man_ltd9_d	double precision
Recurring charge manual assessment L-T-D [10]	rcr_man_ltd10_d	double precision
Recurring charge manual assessment L-T-D [11]	rcr_man_ltd11_d	double precision
Recurring charge manual assessment L-T-D [12]	rcr_man_ltd12_d	double precision
Recurring charge manual assessment L-T-D [13]	rcr_man_ltd13_d	double precision
Recurring charge manual assessment L-T-D [14]	rcr_man_ltd14_d	double precision
Recurring charge manual assessment L-T-D [15]	rcr_man_ltd15_d	double precision

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 Sybase data types used in the LeasePak database. Note that LeasePak does not use all the Sybase data types.

char

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

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

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 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.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
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 number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

LeasePak 6.2a Documentation Suite

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