| Description | Column | Datatype |
|---|---|---|
| Lease | lse_s | char (10) |
| Sybase timestamp | timestamp | timestamp |
| Asset | unit_s | char (10) |
| Effective date | d_eff_s | datetime |
| FMV date | d_fmv_s | datetime |
| Quote date | d_quote_s | datetime |
| Quote time | t_quote_s | char (6) |
| Good until date | d_good_s | datetime |
| 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 | char (36) |
| Comments [1] | commt1_s | char (80) |
| Comments [2] | commt2_s | char (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 | double precision |
| Interest rate | rate_d | double precision |
| FMV quote | fmv_d | double precision |
| Wear & tear | wear_d | double precision |
| Excess mileage | mileage_d | double precision |
| Base payoff amount | base_d | double precision |
| Payment delinquent | pmt_dlnq_d | double precision |
| Payments current | pmt_curr_d | double precision |
| Assessments outstanding | asm_outs_d | double precision |
| Fee/penalty | fee_d | double precision |
| Sales tax | sales_tax_d | double precision |
| ITC recaptured | itc_d | double precision |
| Additional charges | add_d | double precision |
| Total quote | quote_d | double precision |
| Security deposit | sec_d | double precision |
| Use tax | use_tax_d | double precision |
| Late charges | late_d | double precision |
| ITC reversed | itc_rev_d | double precision |
| Per diem | diem_d | double precision |
| Base amount for termination | bas_wo_d | double precision |
| Interest adjustment | int_adj_d | double precision |
| Base taxable amount | base_amt_d | double precision |
| Create payoff quote invoice (Y/N) | invoice_c | char (1) |
| Credit life insurance 1 rebate | cr_lif1_re_d | double precision |
| Credit life insurance 2 rebate | cr_lif2_re_d | double precision |
| Credit disability insurance 1 rebate | cr_dis1_re_d | double precision |
| Credit disability insurance 2 rebate | cr_dis2_re_d | double precision |
| Exclude unguaranteed residual amount | excl_unguar_res_c | char (1) |
| Collection fees | col_fee_d | double precision |
| Assumption fees | ass_fee_d | double precision |
| Legal fees | leg_fee_d | double precision |
| Payment extension fees | pmt_ext_fee_d | double precision |
| Lease extension fees | lse_ext_fee_d | double precision |
| Lease rewrite fees | lsrw_fee_d | double precision |
| Other charges | other_d | double precision |
| Maintenance fee | maint_d | double precision |
| Property tax | prop_tax_d | double precision |
| Federal highway use tax fee | fhut_fee_d | double precision |
| Adjust payoff assessments (Y/N) | adj_payoff_asm_c | char (1) |
| Recurring charge [1] | rcr1_d | double precision |
| Recurring charge [2] | rcr2_d | double precision |
| Recurring charge [3] | rcr3_d | double precision |
| Recurring charge [4] | rcr4_d | double precision |
| Recurring charge [5] | rcr5_d | double precision |
| Recurring charge [6] | rcr6_d | double precision |
| Recurring charge [7] | rcr7_d | double precision |
| Recurring charge [8] | rcr8_d | double precision |
| Recurring charge [9] | rcr9_d | double precision |
| Recurring charge [10] | rcr10_d | double precision |
| Recurring charge [11] | rcr11_d | double precision |
| Recurring charge [12] | rcr12_d | double precision |
| Recurring charge [13] | rcr13_d | double precision |
| Recurring charge [14] | rcr14_d | double precision |
| Recurring charge [15] | rcr15_d | double precision |
| 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 Database Reference
©
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.