| 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.
This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.
If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.
If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.
If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.