| 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.
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.