| Description | Column | Datatype |
|---|---|---|
| Lease | lse_s | char (10) |
| Extension | ext_num_s | char (2) |
| Asset | unit_s | char (10) |
| Record number | unique_l | number (10) |
| Oracle row stamp | stamp_l | number (10) |
| Additional method of depreciation 1 | ger1_s | char (4) |
| Additional method of depreciation 2 | ger2_s | char (4) |
| Depreciation M-T-D additional 1 | ger1_mtd_d | number (15,2) |
| Depreciation Y-T-D additional 1 | ger1_ytd_d | number (15,2) |
| Depreciation L-T-D additional 1 | ger1_ltd_d | number (15,2) |
| Depreciation M-T-D additional 2 | ger2_mtd_d | number (15,2) |
| Depreciation Y-T-D additional 2 | ger2_ytd_d | number (15,2) |
| Depreciation L-T-D additional 2 | ger2_ltd_d | number (15,2) |
| Equipment street address 2 | eq_add2_s | varchar2 (36) |
| Collateral substitution dealer | sub_dlr_s | char (9) |
| Collateral substitution date | d_sub_s | date |
| Collateral substitution mileage | sub_miles_l | number (10) |
| Extended warranty months | ext_war_mnths_l | number (10) |
| Extended warranty miles | ext_war_miles_l | number (10) |
| Warranty mileage allowance | war_miles_l | number (10) |
| Total days in pending repossesion | days_p_repo_l | number (10) |
| Vehicle color | color_s | char (10) |
| Manufacturers key code | cd_key_s | char (6) |
| State of license plate issue | lic_st_s | char (2) |
| Lien holder claim | lien_hldr_claim_c | char (1) |
| Repossesion investments | repo_invst_d | number (15,2) |
| Repair charges | repair_d | number (15,2) |
| App recon charges | beauty_d | number (15,2) |
| Incentive charges | incentive_d | number (15,2) |
| Transportation cost | transprt_d | number (15,2) |
| Sales fee charges | sale_fee_d | number (15,2) |
| DMV/title charges | dmv_d | number (15,2) |
| Repairs/labor charges | rep_labor_d | number (15,2) |
| Storage charges recovery | storage_rec_d | number (15,2) |
| Storage charges remarketing | storage_rem_d | number (15,2) |
| Other credits | other_cr_d | number (15,2) |
| Gross proceeds | gr_proc_d | number (15,2) |
| Pre gap payments due | pre_gap_d | number (15,2) |
| Permanent state status (Y/N) | perm_st_c | char (1) |
| Part number | part_num_s | varchar2 (25) |
| Number of sub-assets on an asset | sub_count_l | number (10) |
| Insurance cancellation date | d_ins_can_s | date |
| Insurance expiration date | d_ins_exp_s | date |
| Insurance bank code | ins_bank_s | char (3) |
| Insurance cancellation reason | ins_can_s | char (4) |
| Insurance asset (Y/N) | ins_unit_c | char (1) |
| Diminishing value rate | p_dim_val_d | number (15,5) |
| Insurance percentage | p_ins_d | number (15,5) |
| Unearned insurance income | ue_ins_inc_d | number (15,2) |
| Life-to-date insurance payable | ltd_ins_pay_d | number (15,2) |
| Life-to-date insurance commission | ltd_ins_com_d | number (15,2) |
| Life-to-Date insurance income | ltd_ins_inc_d | number (15,2) |
| Refund insurance payable | ins_pay_refund_d | number (15,2) |
| Refund insurance commission | ins_com_refund_d | number (15,2) |
| Refund insurance income | ins_inc_refund_d | number (15,2) |
| Payment schedule adjustment method
A=Amount T=Term |
pmt_sch_meth_c | char (1) |
| Previous life-to-date depreciation | prev_ltd_bkd_d | number (15,2) |
| Previous book depreciation basis | prev_taxbasis_d | number (15,2) |
| Previous book salvage value | prev_sal_bkd_d | number (15,2) |
| Depreciation change counter | depr_chg_l | number (10) |
| Previous book depreciation start date | d_prev_bkd_s | date |
| Previous book depreciation method | prev_bkd_s | char (4) |
| Changed accounting method from FIN to OPER (Y/N) | fin_to_oper_c | char (1) |
| Deferred book depreciation amount | def_bkd_d | number (15,2) |
| Deferred book depreciation taken
N - Not taken D - Taken by depreciation P - Taken by payoff S = Taken by sale of asset |
def_bkd_taken_c | char (1) |
| Leveraged (Y/N) | lvr_c | char (1) |
| AMT depreciation life | amt_life_l | number (10) |
| Federal depreciation life | fed_life_l | number (10) |
| Deferred tax YTD amount | dfrd_tax_ytd_d | number (15,2) |
| FSC exclusion Y-T-D amount | fsc_ytd_d | number (15,2) |
| Interest expenses Y-T-D amount | int_expn_ytd_d | number (15,2) |
| OLB invoice/rent amount | olb_invo_d | number (15,2) |
| OLB sales tax amount | olb_stax_d | number (15,2) |
| Taxable income Y-T-D amount | tax_inc_ytd_d | number (15,2) |
| Previous Y-T-D federal AMT depreciation | prev_ytd_fed_amt_d | number (15,2) |
| Previous Y-T-D federal depreciation | prev_ytd_fed_d | number (15,2) |
| Previous Y-T-D state depreciation | prev_ytd_st_d | number (15,2) |
| Optional residual | opt_res_d | number (15,2) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 |
|---|---|---|---|---|
| rhqa_idx0 | lse_s | ext_num_s | unit_s | unique_l |
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.