| Description | Column | Datatype |
|---|---|---|
| Portfolio | por_s | char (2) |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Lease | lse_s | char (10) |
| Asset | unit_s | char (10) |
| Oracle row stamp | stamp_l | number (10) |
| Vendor | dlr_s | char (9) |
| Equipment acquisition date | d_com1_s | date |
| In-service date | d_serv_s | date |
| Equipment activity status date | d_act_s | date |
| Date of equipment sell | d_mat_s | date |
| Book depreciation start date | d_bok_s | date |
| ITC accrued to date | d_itc_s | date |
| Last lien date | d_lien_s | date |
| State | st_s | char (2) |
| Equipment activity status | eqt_s | char (4) |
| ITC take/bypass code | itc_s | char (4) |
| ETC take/bypass code | etc_s | char (4) |
| Book depreciation method | bkd_s | char (4) |
| Federal method of depreciation | fed_s | char (4) |
| State method of depreciation | std_s | char (4) |
| Federal AMT method | fed_amt_s | char (4) |
| Tax type | tax_type_s | char (4) |
| Lease type code | ls_typ_s | char (4) |
| Payoff/sale state location code | pay_st_s | char (2) |
| Payoff/sale county location code | pay_ct_s | char (4) |
| Payoff/sale city location code | pay_cy_s | char (4) |
| New/used (N/U) | new_c | char (1) |
| Flag for deletion (Y/N) | dyr_c | char (1) |
| Asset appears on tax reports (Y/N) | tax_rptg_c | char (1) |
| Gross profit type - related/unrelated (R/U) | gp_typ_c | char (1) |
| Report property tax (Y/N) | rpt_ptax_c | char (1) |
| Asset description | desc_s | varchar2 (36) |
| Number of payments accrued | pmt_l | number (10) |
| Lease term | trm_l | number (10) |
| Adjustment depreciable life | adj_depr_life_l | number (10) |
| Portfolio tax rate | tax_d | number (15,5) |
| Payoff/sale state rate | pay_st_rate_d | number (15,5) |
| Payoff/sale county rate | pay_ct_rate_d | number (15,5) |
| Payoff/sale city rate | pay_cy_rate_d | number (15,5) |
| Original acquisition cost | org_d | number (15,2) |
| Residual amount | res_d | number (15,2) |
| Net receipts Y-T-D | rec_ytd_d | number (15,2) |
| Other income Y-T-D | oth_ytd_d | number (15,2) |
| Payoff | pay_d | number (15,2) |
| Proceeds of sale | pro_sale_d | number (15,2) |
| Gain/Loss on termination | gnls_d | number (15,2) |
| Starting book value for depreciation | taxbasis_d | number (15,2) |
| Starting book value for ITC | itcbasis_d | number (15,2) |
| Book value salvage value | sal_bkd_d | number (15,2) |
| State salvage value | sal_st_d | number (15,2) |
| Depreciation L-T-D book | ltd_bkd_d | number (15,2) |
| Depreciation L-T-D federal | ltd_fed_d | number (15,2) |
| Depreciation L-T-D state | ltd_st_d | number (15,2) |
| Depreciation Y-T-D book | ytd_bkd_d | number (15,2) |
| Depreciation Y-T-D federal | ytd_fed_d | number (15,2) |
| Depreciation Y-T-D state | ytd_st_d | number (15,2) |
| Original ITC | itc_org_d | number (15,2) |
| ITC L-T-D | itc_ltd_d | number (15,2) |
| ITC Y-T-D | itc_ytd_d | number (15,2) |
| ITC sustained | itc_sus_d | number (15,2) |
| ITC to reverse | itc_to_rev_d | number (15,2) |
| ETC original total | etc_org_d | number (15,2) |
| ETC Y-T-D | etc_ytd_d | number (15,2) |
| ETC L-T-D | etc_ltd_d | number (15,2) |
| ETC to reverse | etc_rev_d | number (15,2) |
| Federal AMT L-T-D amount | fed_amt_ltd_d | number (15,2) |
| Federal AMT Y-T-D amount | fed_amt_ytd_d | number (15,2) |
| Manufacturer's depreciation basis | man_bas_d | number (15,2) |
| Payment amount accrued Y-T-D | pmt_acc_d | number (15,2) |
| Book tax basis | bk_basis_d | number (15,2) |
| Lessor income Y-T-D | l_in_ytd_d | number (15,2) |
| Original asset cost | ast_cst_d | number (15,2) |
| Original book basis | org_bk_basis_d | number (15,2) |
| Adjustment to book basis | adj_bk_basis_d | number (15,2) |
| Current ITC unearned | itc_cur_ue_d | number (15,2) |
| Original L-T-D book depreciation | org_bkd_ltd_d | number (15,2) |
| Allowance for bad debt | allow_d | number (15,2) |
| Y-T-D loss on termination | ytd_loss_d | number (15,2) |
| Y-T-D gain on termination | ytd_gain_d | number (15,2) |
| IDC Y-T-D amount - book | idc_ytd_d | number (15,2) |
| IDC Y-T-D amount - tax | idc_tax_ytd_d | number (15,2) |
| Payoff/sale taxable amount | pay_tax_amt_d | number (15,2) |
| Net book value at payoff | nbv_pay_d | number (15,2) |
| Federal book value at payoff | fed_pay_d | number (15,2) |
| State book value at payoff | std_pay_d | number (15,2) |
| Federal AMT book value at payoff | amt_pay_d | number (15,2) |
| Residual income reduction Y-T-D | r_in_reduct_ytd_d | number (15,2) |
| Allow property tax assessment (Y/N) | allow_ptx_c | char (1) |
| FMV quote | fmv_d | number (15,2) |
| Property tax basis | prop_tax_basis_d | number (15,2) |
| Additional method of depreciation 1 | ger1_s | char (4) |
| Additional method of depreciation 2 | ger2_s | char (4) |
| 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 Y-T-D additional 2 | ger2_ytd_d | number (15,2) |
| Depreciation L-T-D additional 2 | ger2_ltd_d | number (15,2) |
| Equipment activity status prior to sale | eqt_o_s | char (4) |
| Movement code prior to sale | mov_o_s | char (4) |
| 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) |
| Taxable income Y-T-D amount | tax_inc_ytd_d | number (15,2) |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 | Piece 6 |
|---|---|---|---|---|---|---|
| rcs_idx0 | por_s | com_s | reg_s | off_s | lse_s | unit_s |
| rcs_idx1 | lse_s | unit_s | ||||
| rcs_idx2 | unit_s | |||||
| rcs_idx3 | dlr_s | unit_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.