Database Reference Oracle DBMS
rpd Table: Payoff Quote
Indexes
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 |
|---|---|---|---|---|---|
| rpd_idx0 | lse_s | d_quote_s | t_quote_s | batch_num_s | unit_s |
| rpd_idx1 | batch_num_s | unit_s | lse_s | d_quote_s | t_quote_s |
| rpd_idx2 | unit_s | batch_num_s | lse_s | d_quote_s | t_quote_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| lse_s | Lease |
CHAR(10) | no |
| stamp_l | Record modification stamp |
NUMBER(10) | no |
| unit_s | Asset |
CHAR(10) | no |
| d_eff_s | Effective date |
DATE | yes |
| d_fmv_s | FMV date |
DATE | yes |
| d_quote_s | Quote date |
DATE | no |
| t_quote_s | Quote time |
CHAR(6) | no |
| d_good_s | Good until date |
DATE | yes |
| method_s | Method |
CHAR(4) | yes |
| quote_type_c | Quote type (P/T) |
CHAR(1) | yes |
| pmt_recd_c | Future payments received (Y/N) |
CHAR(1) | yes |
| ref_s | FMV reference |
VARCHAR2(36) | yes |
| commt1_s | Comments [1] |
VARCHAR2(80) | yes |
| commt2_s | Comments [2] |
VARCHAR2(80) | yes |
| opr_s | Operator initials |
CHAR(3) | yes |
| base_s | Base rate |
CHAR(4) | yes |
| base_def_s | Base payoff amount default |
CHAR(4) | yes |
| tax_d | Portfolio tax rate |
NUMBER(15,5) | yes |
| rate_d | Interest rate |
NUMBER(15,5) | yes |
| fmv_d | Fair market value |
NUMBER(15,2) | yes |
| wear_d | Wear & tear |
NUMBER(15,2) | yes |
| mileage_d | Excess mileage |
NUMBER(15,2) | yes |
| base_d | Base payoff amount |
NUMBER(15,2) | yes |
| pmt_dlnq_d | Payment delinquent |
NUMBER(15,2) | yes |
| pmt_curr_d | Payments current |
NUMBER(15,2) | yes |
| asm_outs_d | Assessments outstanding |
NUMBER(15,2) | yes |
| fee_d | Fee/penalty |
NUMBER(15,2) | yes |
| sales_tax_d | Sales tax |
NUMBER(15,2) | yes |
| itc_d | ITC recaptured |
NUMBER(15,2) | yes |
| add_d | Additional charges |
NUMBER(15,2) | yes |
| quote_d | Total quote |
NUMBER(15,2) | yes |
| sec_d | Security deposit |
NUMBER(15,2) | yes |
| use_tax_d | Use tax |
NUMBER(15,2) | yes |
| late_d | Late charges |
NUMBER(15,2) | yes |
| itc_rev_d | ITC reversed |
NUMBER(15,2) | yes |
| diem_d | Per diem |
NUMBER(15,2) | yes |
| bas_wo_d | Base amount for termination |
NUMBER(15,2) | yes |
| int_adj_d | Interest adjustment |
NUMBER(15,2) | yes |
| base_amt_d | Base taxable amount |
NUMBER(15,2) | yes |
| invoice_c | Create payoff quote invoice (Y/N) |
CHAR(1) | yes |
| cr_lif1_re_d | Credit life insurance 1 rebate |
NUMBER(15,2) | yes |
| cr_lif2_re_d | Credit life insurance 2 rebate |
NUMBER(15,2) | yes |
| cr_dis1_re_d | Credit disability insurance 1 rebate |
NUMBER(15,2) | yes |
| cr_dis2_re_d | Credit disability insurance 2 rebate |
NUMBER(15,2) | yes |
| excl_unguar_res_c | Exclude unguaranteed residual amount |
CHAR(1) | yes |
| col_fee_d | Collection fees |
NUMBER(15,2) | yes |
| ass_fee_d | Assumption fees |
NUMBER(15,2) | yes |
| leg_fee_d | Legal fees |
NUMBER(15,2) | yes |
| pmt_ext_fee_d | Payment extension fees |
NUMBER(15,2) | yes |
| lse_ext_fee_d | Lease extension fees |
NUMBER(15,2) | yes |
| lsrw_fee_d | Lease rewrite fees |
NUMBER(15,2) | yes |
| other_d | Other charges |
NUMBER(15,2) | yes |
| maint_d | Maintenance fee |
NUMBER(15,2) | yes |
| prop_tax_d | Property tax |
NUMBER(15,2) | yes |
| fhut_fee_d | Federal highway use tax fee |
NUMBER(15,2) | yes |
| adj_payoff_asm_c | Adjust payoff assessments (Y/N) |
CHAR(1) | yes |
| rcr1_d | Recurring charge [1] |
NUMBER(15,2) | yes |
| rcr2_d | Recurring charge [2] |
NUMBER(15,2) | yes |
| rcr3_d | Recurring charge [3] |
NUMBER(15,2) | yes |
| rcr4_d | Recurring charge [4] |
NUMBER(15,2) | yes |
| rcr5_d | Recurring charge [5] |
NUMBER(15,2) | yes |
| rcr6_d | Recurring charge [6] |
NUMBER(15,2) | yes |
| rcr7_d | Recurring charge [7] |
NUMBER(15,2) | yes |
| rcr8_d | Recurring charge [8] |
NUMBER(15,2) | yes |
| rcr9_d | Recurring charge [9] |
NUMBER(15,2) | yes |
| rcr10_d | Recurring charge [10] |
NUMBER(15,2) | yes |
| rcr11_d | Recurring charge [11] |
NUMBER(15,2) | yes |
| rcr12_d | Recurring charge [12] |
NUMBER(15,2) | yes |
| rcr13_d | Recurring charge [13] |
NUMBER(15,2) | yes |
| rcr14_d | Recurring charge [14] |
NUMBER(15,2) | yes |
| rcr15_d | Recurring charge [15] |
NUMBER(15,2) | yes |
| tot_diem_d | Total per diem amount |
NUMBER(15,2) | yes |
| days_diem_l | Days of per diem |
NUMBER(10) | yes |
| batch_num_s | Batch number |
CHAR(6) | no |
| payoff_lvl_c | Payoff quote level (L/A) L - Lease A - Asset |
CHAR(1) | yes |
| rcr16_d | Recurring charge [16] |
NUMBER(15,2) | yes |
| rcr17_d | Recurring charge [17] |
NUMBER(15,2) | yes |
| rcr18_d | Recurring charge [18] |
NUMBER(15,2) | yes |
| rcr19_d | Recurring charge [19] |
NUMBER(15,2) | yes |
| rcr20_d | Recurring charge [20] |
NUMBER(15,2) | yes |
| rcr21_d | Recurring charge [21] |
NUMBER(15,2) | yes |
| rcr22_d | Recurring charge [22] |
NUMBER(15,2) | yes |
| rcr23_d | Recurring charge [23] |
NUMBER(15,2) | yes |
| rcr24_d | Recurring charge [24] |
NUMBER(15,2) | yes |
| rcr25_d | Recurring charge [25] |
NUMBER(15,2) | yes |
| rcr26_d | Recurring charge [26] |
NUMBER(15,2) | yes |
| rcr27_d | Recurring charge [27] |
NUMBER(15,2) | yes |
| rcr28_d | Recurring charge [28] |
NUMBER(15,2) | yes |
| rcr29_d | Recurring charge [29] |
NUMBER(15,2) | yes |
| rcr30_d | Recurring charge [30] |
NUMBER(15,2) | yes |
| rcr31_d | Recurring charge [31] |
NUMBER(15,2) | yes |
| rcr32_d | Recurring charge [32] |
NUMBER(15,2) | yes |
| rcr33_d | Recurring charge [33] |
NUMBER(15,2) | yes |
| rcr34_d | Recurring charge [34] |
NUMBER(15,2) | yes |
| rcr35_d | Recurring charge [35] |
NUMBER(15,2) | yes |
| lse_fee1_d | Lease fee [1] |
NUMBER(15,2) | yes |
| lse_fee2_d | Lease fee [2] |
NUMBER(15,2) | yes |
| lse_fee3_d | Lease fee [3] |
NUMBER(15,2) | yes |
| lse_fee4_d | Lease fee [4] |
NUMBER(15,2) | yes |
| lse_fee5_d | Lease fee [5] |
NUMBER(15,2) | yes |
| lse_fee6_d | Lease fee [6] |
NUMBER(15,2) | yes |
| lse_fee7_d | Lease fee [7] |
NUMBER(15,2) | yes |
| lse_fee8_d | Lease fee [8] |
NUMBER(15,2) | yes |
| lse_fee9_d | Lease fee [9] |
NUMBER(15,2) | yes |
| lse_fee10_d | Lease fee [10] |
NUMBER(15,2) | yes |
| lse_fee11_d | Lease fee [11] |
NUMBER(15,2) | yes |
| lse_fee12_d | Lease fee [12] |
NUMBER(15,2) | yes |
| lse_fee13_d | Lease fee [13] |
NUMBER(15,2) | yes |
| lse_fee14_d | Lease fee [14] |
NUMBER(15,2) | yes |
| lse_fee15_d | Lease fee [15] |
NUMBER(15,2) | yes |
| lse_fee16_d | Lease fee [16] |
NUMBER(15,2) | yes |
| lse_fee17_d | Lease fee [17] |
NUMBER(15,2) | yes |
| lse_fee18_d | Lease fee [18] |
NUMBER(15,2) | yes |
| lse_fee19_d | Lease fee [19] |
NUMBER(15,2) | yes |
| lse_fee20_d | Lease fee [20] |
NUMBER(15,2) | yes |
| unit_fee1_d | Asset fee [1] |
NUMBER(15,2) | yes |
| unit_fee2_d | Asset fee [2] |
NUMBER(15,2) | yes |
| unit_fee3_d | Asset fee [3] |
NUMBER(15,2) | yes |
| unit_fee4_d | Asset fee [4] |
NUMBER(15,2) | yes |
| unit_fee5_d | Asset fee [5] |
NUMBER(15,2) | yes |
| unit_fee6_d | Asset fee [6] |
NUMBER(15,2) | yes |
| unit_fee7_d | Asset fee [7] |
NUMBER(15,2) | yes |
| unit_fee8_d | Asset fee [8] |
NUMBER(15,2) | yes |
| unit_fee9_d | Asset fee [9] |
NUMBER(15,2) | yes |
| unit_fee10_d | Asset fee [10] |
NUMBER(15,2) | 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.