rca Table: Lease Form

Database Reference

rca Table: Lease Form

Indexes

Name	Segment 1
rca_idx0	frm_s

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