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