Top
Oracle dbRef
Help
Print Version
Search
DocSuite
| Description | Column | Datatype |
|---|---|---|
| Lease | lse_s | char (10) |
| Oracle row stamp | stamp_l | number (10) |
| Asset | unit_s | char (10) |
| Effective date | d_eff_s | date |
| FMV date | d_fmv_s | date |
| Quote date | d_quote_s | date |
| Quote time | t_quote_s | char (6) |
| Good until date | d_good_s | date |
| Method | method_s | char (4) |
| Quote type (P/T) | quote_type_c | char (1) |
| Future payments received (Y/N) | pmt_recd_c | char (1) |
| FMV reference | ref_s | varchar2 (36) |
| Comments [1] | commt1_s | varchar2 (80) |
| Comments [2] | commt2_s | varchar2 (80) |
| Operator initials | opr_s | char (3) |
| Base rate | base_s | char (4) |
| Base payoff amount default | base_def_s | char (4) |
| Portfolio tax rate | tax_d | number (15,5) |
| Interest rate | rate_d | number (15,5) |
| FMV quote | fmv_d | number (15,2) |
| Wear & tear | wear_d | number (15,2) |
| Excess mileage | mileage_d | number (15,2) |
| Base payoff amount | base_d | number (15,2) |
| Payment delinquent | pmt_dlnq_d | number (15,2) |
| Payments current | pmt_curr_d | number (15,2) |
| Assessments outstanding | asm_outs_d | number (15,2) |
| Fee/penalty | fee_d | number (15,2) |
| Sales tax | sales_tax_d | number (15,2) |
| ITC recaptured | itc_d | number (15,2) |
| Additional charges | add_d | number (15,2) |
| Total quote | quote_d | number (15,2) |
| Security deposit | sec_d | number (15,2) |
| Use tax | use_tax_d | number (15,2) |
| Late charges | late_d | number (15,2) |
| ITC reversed | itc_rev_d | number (15,2) |
| Per diem | diem_d | number (15,2) |
| Base amount for termination | bas_wo_d | number (15,2) |
| Interest adjustment | int_adj_d | number (15,2) |
| Base taxable amount | base_amt_d | number (15,2) |
| Create payoff quote invoice (Y/N) | invoice_c | char (1) |
| Credit life insurance 1 rebate | cr_lif1_re_d | number (15,2) |
| Credit life insurance 2 rebate | cr_lif2_re_d | number (15,2) |
| Credit disability insurance 1 rebate | cr_dis1_re_d | number (15,2) |
| Credit disability insurance 2 rebate | cr_dis2_re_d | number (15,2) |
| Exclude unguaranteed residual amount | excl_unguar_res_c | char (1) |
| Collection fees | col_fee_d | number (15,2) |
| Assumption fees | ass_fee_d | number (15,2) |
| Legal fees | leg_fee_d | number (15,2) |
| Payment extension fees | pmt_ext_fee_d | number (15,2) |
| Lease extension fees | lse_ext_fee_d | number (15,2) |
| Lease rewrite fees | lsrw_fee_d | number (15,2) |
| Other charges | other_d | number (15,2) |
| Maintenance fee | maint_d | number (15,2) |
| Property tax | prop_tax_d | number (15,2) |
| Federal highway use tax fee | fhut_fee_d | number (15,2) |
| Adjust payoff assessments (Y/N) | adj_payoff_asm_c | char (1) |
| Recurring charge [1] | rcr1_d | number (15,2) |
| Recurring charge [2] | rcr2_d | number (15,2) |
| Recurring charge [3] | rcr3_d | number (15,2) |
| Recurring charge [4] | rcr4_d | number (15,2) |
| Recurring charge [5] | rcr5_d | number (15,2) |
| Recurring charge [6] | rcr6_d | number (15,2) |
| Recurring charge [7] | rcr7_d | number (15,2) |
| Recurring charge [8] | rcr8_d | number (15,2) |
| Recurring charge [9] | rcr9_d | number (15,2) |
| Recurring charge [10] | rcr10_d | number (15,2) |
| Recurring charge [11] | rcr11_d | number (15,2) |
| Recurring charge [12] | rcr12_d | number (15,2) |
| Recurring charge [13] | rcr13_d | number (15,2) |
| Recurring charge [14] | rcr14_d | number (15,2) |
| Recurring charge [15] | rcr15_d | number (15,2) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 |
|---|---|---|---|---|
| rpd_idx0 | lse_s | d_quote_s | t_quote_s | |
| rpd_idx1 | unit_s | lse_s | d_quote_s | t_quote_s |
LeasePak 5.2a Database Reference
©
2005 by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, 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 McCue Systems, Inc. is prohibited.