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