Database Reference Oracle 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 |
| stamp_l | Record modification stamp |
NUMBER(10) | no |
| 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 |
VARCHAR2(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 |
NUMBER(10) | yes |
| tma_grc_l | Grace days for late charge termination calculation |
NUMBER(10) | yes |
| grc_l | Grace period in days |
NUMBER(10) | yes |
| p_lc_d | Late charge percentage |
NUMBER(15,5) | yes |
| p_bb_d | Purchase percentage - KBB wholesale |
NUMBER(15,5) | yes |
| p_oc_d | Purchase percentage - original cost |
NUMBER(15,5) | yes |
| p_tf_d | Termination fee percentage |
NUMBER(15,5) | yes |
| p_pp_d | Pre-payment penalties percentage |
NUMBER(15,5) | yes |
| p_tlc_d | Termination late charge rate |
NUMBER(15,5) | yes |
| p_pt_d | Property tax late charge percentage |
NUMBER(15,5) | yes |
| ins_plc_d | Insurance - public liability coverage |
NUMBER(15,2) | yes |
| ins_pdc_d | Insurance - property damage coverage |
NUMBER(15,2) | yes |
| ins_cda_d | Insurance - collision deductible amount |
NUMBER(15,2) | yes |
| ins_coa_d | Insurance - comprehensive amount |
NUMBER(15,2) | yes |
| ins_bic_d | Insurance - bodily injury coverage |
NUMBER(15,2) | yes |
| lch_min_d | Late charge - minimum dollar amount |
NUMBER(15,2) | yes |
| lch_max_d | Late charge - maximum dollar amount |
NUMBER(15,2) | yes |
| lch_fix_d | Late charge - fixed dollar amount |
NUMBER(15,2) | yes |
| tea_tfe_d | Early term - termination fee |
NUMBER(15,2) | yes |
| tea_ppp_d | Early term - pre-payment penalty |
NUMBER(15,2) | yes |
| tma_tfe_d | Maturity - termination fee |
NUMBER(15,2) | yes |
| tma_emc_d | Maturity - excess mile (cents/mile) |
NUMBER(15,2) | yes |
| tma_wtd_d | Maturity - wear and tear deductible |
NUMBER(15,2) | yes |
| rel_mrf_d | Relocation - monthly removal fee |
NUMBER(15,2) | yes |
| ltch_grc_amt_d | Late charge grace amount |
NUMBER(15,2) | yes |
| adv_inv_days_l | Advanced invoice days |
NUMBER(10) | yes |
| d_revision_s | Revision date |
DATE | yes |
| late_chrg_st_s | Late charge state |
CHAR(2) | yes |
| typ_cont_s | Type of contract |
VARCHAR2(20) | yes |
| max_grp_life_c | Maximum group life insurance (Y/N) |
CHAR(1) | yes |
| max_grp_life_d | Maximum group life insurance |
NUMBER(15,2) | yes |
| writ_ntc_term_l | Written notice of termination days |
NUMBER(10) | yes |
| ret_chk_chrg_d | Returned check charge maximum |
NUMBER(15,2) | yes |
| p_ret_chk_chrg_per_d | Returned check charge percent maximum |
NUMBER(15,5) | yes |
| pmt_acc_meth_s | Payment accrual method |
CHAR(4) | yes |
| pur_opt_grc_days_l | Purchase option grace days |
NUMBER(10) | yes |
| pur_opt_ntc_req_days_l | Purchase option notice required days |
NUMBER(10) | yes |
| grp_life_prem_allw_c | Group life premimum allow (Y/N) |
CHAR(1) | yes |
| min_fin_chrg_d | Minimum finance charge |
NUMBER(15,2) | yes |
| payoff_adj_per_l | Payoff adjustment period |
NUMBER(10) | yes |
| payoff_adj_src_s | Payoff adjustment source |
VARCHAR2(25) | yes |
| payoff_grc_per_days_l | Payoff grace period days |
NUMBER(10) | yes |
| payoff_ntc_req_days_l | Payoff notice required days |
NUMBER(10) | 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 |
NUMBER(15,2) | yes |
| exc_msrp_chrg_d | Excess msrp charges |
NUMBER(15,2) | yes |
| exc_mile_chrg_msrp_d | Excess mileage charges |
NUMBER(15,2) | yes |
| fee_tax_c | Switch for fees and taxes (Y/N) |
CHAR(1) | yes |
| p_att_fee_max_d | Attorney fees maximum percent |
NUMBER(15,5) | yes |
| ntc_sale_days_l | Notice of sale days |
NUMBER(10) | yes |
| d_clnt_eff_s | Effective date on lease |
DATE | yes |
| d_last_acpt_s | Last date accepted |
DATE | yes |
| assgn_def_c | Assigned default insurance (Y/N) |
CHAR(1) | yes |
| writ_ntc_les_can_days_l | Written notice of lessor cancellation days |
NUMBER(10) | yes |
| grc_days_non_gfxx_l | Grace days non gfxx |
NUMBER(10) | yes |
| writ_ntc_term_c | Written notice of termination flag (Y/N) |
CHAR(1) | yes |
| form_num_s | Form number |
VARCHAR2(36) | yes |
| form_dlr_s | Form vendor |
VARCHAR2(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 |
NUMBER(15,5) | yes |
| d_termination_s | Termination date |
DATE | yes |
| term_fee_d | Termination fee |
NUMBER(15,2) | yes |
| doc_preparation_fee_d | Documentation preparation fee |
NUMBER(15,2) | yes |
| purch_option_fee_d | Purchase option fee |
NUMBER(15,2) | yes |
| ext_def_due_fee_d | Extension/Deferment/Due Day change fee |
NUMBER(15,2) | yes |
| adm_nsf_fee_d | Administrative fee - NSF |
NUMBER(15,2) | yes |
| p_adm_nsf_fee_d | Administrative fee - NSF percentage |
NUMBER(15,5) | yes |
| adm_park_tix_fee_d | Administrative fee - Parking ticket |
NUMBER(15,2) | yes |
| adm_prop_tax_fee_d | Administrative fee - Property tax |
NUMBER(15,2) | 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] |
NUMBER(10) | yes |
| fc_term2_l | FC rebate - term [2] |
NUMBER(10) | yes |
| fc_term3_l | FC rebate - term [3] |
NUMBER(10) | yes |
| fc_term4_l | FC rebate - term [4] |
NUMBER(10) | 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] |
NUMBER(10) | yes |
| clah_term2_l | CL/A&H rebate - term [2] |
NUMBER(10) | yes |
| clah_term3_l | CL/A&H rebate - term [3] |
NUMBER(10) | yes |
| clah_term4_l | CL/A&H rebate - term [4] |
NUMBER(10) | 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] |
NUMBER(10) | yes |
| warr_term2_l | Warranty rebate - term [2] |
NUMBER(10) | yes |
| warr_term3_l | Warranty rebate - term [3] |
NUMBER(10) | yes |
| warr_term4_l | Warranty rebate - term [4] |
NUMBER(10) | 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.