ColumnsIndexessp1Parentsp2rhs

rhsb Table: Historical Lease for Lease Extension/Reversal 3
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rhsb Historical Lease for Lease Extension/Reversal 3 table.

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

rhsb Columns

Description	Column Name	Data Type ?	Characteristics ?
Extension	ext_num_s	char	length 2
Lease	lse_s	char	length 10
Record number	unique_l	integer
Record modification stamp	timestamp	timestamp
Defer payment due date	d_defer_pmt_s	datetime	format YYYYMMDD
Final payment due date	d_final_pmt_s	datetime	format YYYYMMDD
Turn-in date	d_turn_in_s	datetime	format YYYYMMDD
Total tax credit	orig_tax_crd_d	double	scale 2
Remaining tax credit	rem_tax_crd_d	double	scale 2
Cumulative number of deferred months	def_mon_l	integer
Final monthly payment amount	final_pmt_d	double	scale 2
Date of last payment reschedule	d_rsc_s	datetime	format YYYYMMDD
Date of last payment reschedule (RWT)	d_rsc_rwt_s	datetime	format YYYYMMDD
Date of last payment reschedule (DEF)	d_rsc_def_s	datetime	format YYYYMMDD
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	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	double	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	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	scale 2
Alternate unearned IDC3	alt_idc3_ue_d	double	scale 2
Alternate current IDC3	alt_idc3_cur_d	double	scale 2
Alternate year to date IDC3	alt_idc3_ytd_d	double	scale 2
Alternate unearned IDC4	alt_idc4_ue_d	double	scale 2
Alternate current IDC4	alt_idc4_cur_d	double	scale 2
Alternate year to date IDC4	alt_idc4_ytd_d	double	scale 2
Alternate unearned IDC5	alt_idc5_ue_d	double	scale 2
Alternate current IDC5	alt_idc5_cur_d	double	scale 2
Alternate year to date IDC5	alt_idc5_ytd_d	double	scale 2
Alternate unearned IDR5	alt_idr5_ue_d	double	scale 2
Alternate current IDR5	alt_idr5_cur_d	double	scale 2
Alternate year to date IDR5	alt_idr5_ytd_d	double	scale 2
Alternate unearned IDR6	alt_idr6_ue_d	double	scale 2
Alternate current IDR6	alt_idr6_cur_d	double	scale 2
Alternate year to date IDR6	alt_idr6_ytd_d	double	scale 2
Alternate unearned IDRB	alt_idrb_ue_d	double	scale 2
Alternate current IDRB	alt_idrb_cur_d	double	scale 2
Alternate year to date IDRB	alt_idrb_ytd_d	double	scale 2
GL lessor income L-T-D	gl_in_ltd_d	double	scale 2
GL lessor income M-T-D	gl_in_mtd_d	double	scale 2
GL lessor income Y-T-D	gl_in_ytd_d	double	scale 2
Back payment applied (Y/N)	back_pmt_appl_c	char	length 1
Revolving credit limit [1]	revolving_limit1_d	double	scale 2
Revolving credit limit [2]	revolving_limit2_d	double	scale 2
Revolving credit limit [3]	revolving_limit3_d	double	scale 2
Revolving credit limit [4]	revolving_limit4_d	double	scale 2
Revolving credit limit effective date [1]	d_revolving_limit_eff1_s	datetime	format YYYYMMDD
Revolving credit limit effective date [2]	d_revolving_limit_eff2_s	datetime	format YYYYMMDD
Revolving credit limit effective date [3]	d_revolving_limit_eff3_s	datetime	format YYYYMMDD
Revolving credit limit effective date [4]	d_revolving_limit_eff4_s	datetime	format YYYYMMDD
Revolving credit line fee	p_revolving_line_fee_d	double	scale 5
Customer yield	p_cus_d	double	scale 7
Insurance risk fee rate	p_ins_risk_fee_d	double	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	datetime	format YYYYMMDD
PAP bank account name	payer_acct_nam_s	char	length 50
Deferred income amount	def_inc_d	double	scale 2
Deferred IDC amount	def_idc_d	double	scale 2
Deferred IDC1 amount	def_idc1_d	double	scale 2
Deferred IDC2 amount	def_idc2_d	double	scale 2
Deferred IDR1 amount	def_idr1_d	double	scale 2
Deferred IDR2 amount	def_idr2_d	double	scale 2
Deferred IDR3 amount	def_idr3_d	double	scale 2
Deferred IDR4 amount	def_idr4_d	double	scale 2
Number of payment reschedules (RSC)	pmt_rsc_rsc_l	integer
Date of last leveraged table download	d_lst_lvr_s	datetime	format YYYYMMDD
Leveraged commencement date	d_lvr_com_s	datetime	format YYYYMMDD
Leveraged (Y/N)	lvr_c	char	length 1
Number of leveraged table download	lvr_l	integer
Leveraged term	lvr_trm_l	integer
Staged equity amount	stg_eqty_d	double	scale 2
Staged equity account payable	stg_eqty_ap_d	double	scale 2
Taxable income Y-T-D amount	tax_inc_ytd_d	double	scale 2
FSC exclusion Y-T-D amount	fsc_ytd_d	double	scale 2
Interest expenses Y-T-D amount	int_expn_ytd_d	double	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	double	scale 2
Non-pyramiding late charge minimum payment due	npyr_min_d	double	scale 2
IDC amortization add-on interest rate	p_idc_addon_d	double	scale 5
IDC amortization interest rate	p_idc_amort_d	double	scale 5
Schedule principal	sch_prn_d	double	scale 2
Late charge date	d_ltch_s	datetime	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	double	scale 2
Recovery	recovery_d	double	scale 2
Optional residual	opt_res_d	double	scale 2
Non commission amount	non_comm_d	double	scale 2
Security deposit refund amount	sec_refund_d	double	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	datetime	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	datetime	format YYYYMMDD
Payoff quote preparation date	d_payoff_quote_s	datetime	format YYYYMMDD
Custom payoff quote amount [1]	custom_payoff_quote1_d	double	scale 2
Custom payoff quote amount [2]	custom_payoff_quote2_d	double	scale 2
Custom payoff quote amount [3]	custom_payoff_quote3_d	double	scale 2
Custom payoff quote amount [4]	custom_payoff_quote4_d	double	scale 2
Custom payoff quote amount [5]	custom_payoff_quote5_d	double	scale 2
Ad hoc PAP amount	adhoc_pap_d	double	scale 2
Ad hoc effective date	d_adhoc_eff_s	datetime	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	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	scale 5
Calendar to use for determining business days	calendar_s	char	length 4
Original dealer-received payments	orig_dlr_rec_pmt_d	double	scale 2
Dealer payments batch number	dlr_pmt_batch_num_s	char	length 20
Contract end date	d_cntr_end_s	datetime	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

rhsb Indexes

Index Name	Piece 1	Piece 2	Piece 3
rhsb_idx0	lse_s	ext_num_s	unique_l

Parent Table Listing

Table Name	Description
rhs	Historical Lease for Lease Extension/Reversal

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