ColumnsIndexessp1

rca Table: Lease Form
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rca Lease Form table.

rca Columns

Description	Column Name	Data Type ?	Characteristics ?
Lease form code	frm_s	char	length 4
Record modification stamp	timestamp	timestamp
Late charge method	latch_s	char	length 4
Purchase option method	purch_s	char	length 4
Out of state relocation policy	reloc_s	char	length 4
Payoff calculation method	payoff_s	char	length 4
Termination calculation method	termin_s	char	length 4
Prepayment penalty method	prepay_s	char	length 4
Property tax late charge code	ptax_s	char	length 4
Lease form description	desc_s	char	length 36
Use assessments in late charge calculations (Y/N)	asm_in_late_chrg_c	char	length 1
Insurance - public liability (Y/N)	ins_pl_c	char	length 1
Insurance - property damage (Y/N)	ins_pd_c	char	length 1
Insurance - collision deductible (Y/N)	ins_cd_c	char	length 1
Insurance - comprehensive (Y/N)	ins_co_c	char	length 1
Insurance - additional insured (Y/N)	ins_ai_c	char	length 1
Insurance - loss payable (Y/N)	ins_lp_c	char	length 1
Insurance - bodily injury liability (Y/N)	ins_bi_c	char	length 1
Early term - termination fee (Y/N)	tea_tf_c	char	length 1
Early term - pre-payment penalties (Y/N)	tea_pp_c	char	length 1
Maturity - termination late charge (Y/N)	tma_lc_c	char	length 1
Maturity - termination late charge (Y/N)	tma_tf_c	char	length 1
Maturity - excess mileage charge (Y/N)	tma_em_c	char	length 1
Maturity - wear & tear deductible (Y/N)	tma_wt_c	char	length 1
Maturity - purchase option (Y/N)	tma_po_c	char	length 1
Maturity - new lease (Y/N)	tma_nl_c	char	length 1
Maturity - finance (Y/N)	tma_fn_c	char	length 1
Mileage - average allowable (Y/N)	mil_aa_c	char	length 1
Payoff - calculate sales tax on payoff (Y/N)	pay_st_c	char	length 1
Payoff - include ITC recapture (Y/N)	pay_it_c	char	length 1
Payment effective date default (C/D) C - Current date D - Due date	eff_def_c	char	length 1
Place late charge on delinquent invoice (Y/N)	ltch_on_delinq_c	char	length 1
Average yearly allowable mileage	mil_aam_l	integer
Grace days for late charge termination calculation	tma_grc_l	integer
Grace period in days	grc_l	integer
Late charge percentage	p_lc_d	double	scale 5
Purchase percentage - KBB wholesale	p_bb_d	double	scale 5
Purchase percentage - original cost	p_oc_d	double	scale 5
Termination fee percentage	p_tf_d	double	scale 5
Pre-payment penalties percentage	p_pp_d	double	scale 5
Termination late charge rate	p_tlc_d	double	scale 5
Property tax late charge percentage	p_pt_d	double	scale 5
Insurance - public liability coverage	ins_plc_d	double	scale 2
Insurance - property damage coverage	ins_pdc_d	double	scale 2
Insurance - collision deductible amount	ins_cda_d	double	scale 2
Insurance - comprehensive amount	ins_coa_d	double	scale 2
Insurance - bodily injury coverage	ins_bic_d	double	scale 2
Late charge - minimum dollar amount	lch_min_d	double	scale 2
Late charge - maximum dollar amount	lch_max_d	double	scale 2
Late charge - fixed dollar amount	lch_fix_d	double	scale 2
Early term - termination fee	tea_tfe_d	double	scale 2
Early term - pre-payment penalty	tea_ppp_d	double	scale 2
Maturity - termination fee	tma_tfe_d	double	scale 2
Maturity - excess mile (cents/mile)	tma_emc_d	double	scale 2
Maturity - wear and tear deductible	tma_wtd_d	double	scale 2
Relocation - monthly removal fee	rel_mrf_d	double	scale 2
Late charge grace amount	ltch_grc_amt_d	double	scale 2
Advanced invoice days	adv_inv_days_l	integer
Revision date	d_revision_s	datetime	format YYYYMMDD
Late charge state	late_chrg_st_s	char	length 2
Type of contract	typ_cont_s	char	length 20
Maximum group life insurance (Y/N)	max_grp_life_c	char	length 1
Maximum group life insurance	max_grp_life_d	double	scale 2
Written notice of termination days	writ_ntc_term_l	integer
Returned check charge maximum	ret_chk_chrg_d	double	scale 2
Returned check charge percent maximum	p_ret_chk_chrg_per_d	double	scale 5
Payment accrual method	pmt_acc_meth_s	char	length 4
Purchase option grace days	pur_opt_grc_days_l	integer
Purchase option notice required days	pur_opt_ntc_req_days_l	integer
Group life premimum allow (Y/N)	grp_life_prem_allw_c	char	length 1
Minimum finance charge	min_fin_chrg_d	double	scale 2
Payoff adjustment period	payoff_adj_per_l	integer
Payoff adjustment source	payoff_adj_src_s	char	length 25
Payoff grace period days	payoff_grc_per_days_l	integer
Payoff notice required days	payoff_ntc_req_days_l	integer
Pre-payment fees (Y/N)	pre_pmt_fee_c	char	length 1
Additional rent type	add_rent_typ_s	char	length 10
Excess restoration costs	exc_rest_cost_d	double	scale 2
Excess msrp charges	exc_msrp_chrg_d	double	scale 2
Excess mileage charges	exc_mile_chrg_msrp_d	double	scale 2
Switch for fees and taxes (Y/N)	fee_tax_c	char	length 1
Attorney fees maximum percent	p_att_fee_max_d	double	scale 5
Notice of sale days	ntc_sale_days_l	integer
Effective date on lease	d_clnt_eff_s	datetime	format YYYYMMDD
Last date accepted	d_last_acpt_s	datetime	format YYYYMMDD
Assigned default insurance (Y/N)	assgn_def_c	char	length 1
Written notice of lessor cancellation days	writ_ntc_les_can_days_l	integer
Grace days non gfxx	grc_days_non_gfxx_l	integer
Written notice of termination flag (Y/N)	writ_ntc_term_c	char	length 1
Form number	form_num_s	char	length 36
Form vendor	form_dlr_s	char	length 36
Product type code	prd_s	char	length 4
Interest type	int_typ_s	char	length 4
Maximum interest rates type	max_int_rate_typ_s	char	length 4
Balloon notes permissible (Y/N)	balloon_notes_c	char	length 1
Force placed insurance allowed (Y/N)	force_placed_ins_c	char	length 1
Suppress late fee if payment (Y/N)	suppress_late_fee_c	char	length 1
Suppress late fee if payment percentage	p_suppress_late_fee_d	double	scale 5
Termination date	d_termination_s	datetime	format YYYYMMDD
Termination fee	term_fee_d	double	scale 2
Documentation preparation fee	doc_preparation_fee_d	double	scale 2
Purchase option fee	purch_option_fee_d	double	scale 2
Extension/Deferment/Due Day change fee	ext_def_due_fee_d	double	scale 2
Administrative fee - NSF	adm_nsf_fee_d	double	scale 2
Administrative fee - NSF percentage	p_adm_nsf_fee_d	double	scale 5
Administrative fee - Parking ticket	adm_park_tix_fee_d	double	scale 2
Administrative fee - Property tax	adm_prop_tax_fee_d	double	scale 2
Language	language_s	char	length 2
FC rebate - rebate method [1]	fc_rebate1_c	char	length 1
FC rebate - rebate method [2]	fc_rebate2_c	char	length 1
FC rebate - rebate method [3]	fc_rebate3_c	char	length 1
FC rebate - rebate method [4]	fc_rebate4_c	char	length 1
FC rebate - sign [1]	fc_sign1_c	char	length 1
FC rebate - sign [2]	fc_sign2_c	char	length 1
FC rebate - sign [3]	fc_sign3_c	char	length 1
FC rebate - sign [4]	fc_sign4_c	char	length 1
FC rebate - term [1]	fc_term1_l	integer
FC rebate - term [2]	fc_term2_l	integer
FC rebate - term [3]	fc_term3_l	integer
FC rebate - term [4]	fc_term4_l	integer
CL/A&H rebate - rebate method [1]	clah_rebate1_c	char	length 1
CL/A&H rebate - rebate method [2]	clah_rebate2_c	char	length 1
CL/A&H rebate - rebate method [3]	clah_rebate3_c	char	length 1
CL/A&H rebate - rebate method [4]	clah_rebate4_c	char	length 1
CL/A&H rebate - sign [1]	clah_sign1_c	char	length 1
CL/A&H rebate - sign [2]	clah_sign2_c	char	length 1
CL/A&H rebate - sign [3]	clah_sign3_c	char	length 1
CL/A&H rebate - sign [4]	clah_sign4_c	char	length 1
CL/A&H rebate - term [1]	clah_term1_l	integer
CL/A&H rebate - term [2]	clah_term2_l	integer
CL/A&H rebate - term [3]	clah_term3_l	integer
CL/A&H rebate - term [4]	clah_term4_l	integer
Calculate rebate for payoff (Y/N)	payoff_rebate_c	char	length 1
Warranty rebate - rebate method (Y/N) [1]	warr_rebate1_c	char	length 1
Warranty rebate - rebate method (Y/N) [2]	warr_rebate2_c	char	length 1
Warranty rebate - rebate method (Y/N) [3]	warr_rebate3_c	char	length 1
Warranty rebate - rebate method (Y/N) [4]	warr_rebate4_c	char	length 1
Warranty rebate - sign [1]	warr_sign1_c	char	length 1
Warranty rebate - sign [2]	warr_sign2_c	char	length 1
Warranty rebate - sign [3]	warr_sign3_c	char	length 1
Warranty rebate - sign [4]	warr_sign4_c	char	length 1
Warranty rebate - term [1]	warr_term1_l	integer
Warranty rebate - term [2]	warr_term2_l	integer
Warranty rebate - term [3]	warr_term3_l	integer
Warranty rebate - term [4]	warr_term4_l	integer
Calculate late charge on original amount (Y/N)	late_chrg_on_orig_amt_c	char	length 1

rca Indexes

Index Name	Piece 1
rca_idx0	frm_s

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.