| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 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 |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| por_s | Portfolio |
char(2) | no |
| com_s | Company |
char(2) | no |
| reg_s | Region |
char(2) | no |
| off_s | Office |
char(3) | no |
| lse_s | Lease |
char(10) | no |
| unit_s | Asset |
char(10) | no |
| timestamp | Record modification stamp |
timestamp | yes |
| dlr_s | Vendor |
char(9) | no |
| d_com1_s | Equipment acquisition date |
datetime | yes |
| d_serv_s | In-service date |
datetime | yes |
| d_act_s | Equipment activity status date |
datetime | yes |
| d_mat_s | Date of equipment sell |
datetime | yes |
| d_bok_s | Book depreciation start date |
datetime | yes |
| d_itc_s | ITC accrued to date |
datetime | yes |
| d_lien_s | Last lien date |
datetime | yes |
| st_s | State code (RST.ST_S code) |
char(2) | yes |
| eqt_s | Equipment activity status |
char(4) | yes |
| itc_s | ITC take/bypass code |
char(4) | yes |
| etc_s | ETC take/bypass code |
char(4) | yes |
| bkd_s | Book depreciation method |
char(4) | yes |
| fed_s | Federal method of depreciation |
char(4) | yes |
| std_s | State method of depreciation |
char(4) | yes |
| fed_amt_s | Federal AMT method |
char(4) | yes |
| tax_type_s | Tax type |
char(4) | yes |
| ls_typ_s | Lease type code |
char(4) | yes |
| pay_st_s | Payoff/sale state location code |
char(2) | yes |
| pay_ct_s | Payoff/sale county location code |
char(4) | yes |
| pay_cy_s | Payoff/sale city location code |
char(4) | yes |
| new_c | New/used (N/U) |
char(1) | yes |
| dyr_c | Flag for deletion (Y/N) |
char(1) | yes |
| tax_rptg_c | Asset appears on tax reports (Y/N) |
char(1) | yes |
| gp_typ_c | Gross profit type (R/U) R - related U - unrelated |
char(1) | yes |
| rpt_ptax_c | Report property tax (Y/N) |
char(1) | yes |
| desc_s | Asset description |
char(36) | yes |
| pmt_l | Number of payments accrued |
integer | yes |
| trm_l | Lease term |
integer | yes |
| adj_depr_life_l | Adjustment depreciable life |
integer | yes |
| tax_d | Portfolio tax rate |
double precision | yes |
| pay_st_rate_d | Payoff/sale state rate |
double precision | yes |
| pay_ct_rate_d | Payoff/sale county rate |
double precision | yes |
| pay_cy_rate_d | Payoff/sale city rate |
double precision | yes |
| org_d | Original acquisition cost |
double precision | yes |
| res_d | Residual amount |
double precision | yes |
| rec_ytd_d | Net receipts Y-T-D |
double precision | yes |
| oth_ytd_d | Other income Y-T-D |
double precision | yes |
| pay_d | Payoff |
double precision | yes |
| pro_sale_d | Proceeds of sale |
double precision | yes |
| gnls_d | Gain/Loss on termination |
double precision | yes |
| taxbasis_d | Starting book value for depreciation |
double precision | yes |
| itcbasis_d | Starting book value for ITC |
double precision | yes |
| sal_bkd_d | Book value salvage value |
double precision | yes |
| sal_st_d | State salvage value |
double precision | yes |
| ltd_bkd_d | Depreciation L-T-D book |
double precision | yes |
| ltd_fed_d | Depreciation L-T-D federal |
double precision | yes |
| ltd_st_d | Depreciation L-T-D state |
double precision | yes |
| ytd_bkd_d | Depreciation Y-T-D book |
double precision | yes |
| ytd_fed_d | Depreciation Y-T-D federal |
double precision | yes |
| ytd_st_d | Depreciation Y-T-D state |
double precision | yes |
| itc_org_d | Original ITC |
double precision | yes |
| itc_ltd_d | ITC L-T-D |
double precision | yes |
| itc_ytd_d | ITC Y-T-D |
double precision | yes |
| itc_sus_d | ITC sustained |
double precision | yes |
| itc_to_rev_d | ITC to reverse |
double precision | yes |
| etc_org_d | ETC original total |
double precision | yes |
| etc_ytd_d | ETC Y-T-D |
double precision | yes |
| etc_ltd_d | ETC L-T-D |
double precision | yes |
| etc_rev_d | ETC to reverse |
double precision | yes |
| fed_amt_ltd_d | Federal AMT L-T-D amount |
double precision | yes |
| fed_amt_ytd_d | Federal AMT Y-T-D amount |
double precision | yes |
| man_bas_d | Manufacturer's depreciation basis |
double precision | yes |
| pmt_acc_d | Payment amount accrued Y-T-D |
double precision | yes |
| bk_basis_d | Book tax basis |
double precision | yes |
| l_in_ytd_d | Lessor income Y-T-D |
double precision | yes |
| ast_cst_d | Original asset cost |
double precision | yes |
| org_bk_basis_d | Original book basis |
double precision | yes |
| adj_bk_basis_d | Adjustment to book basis |
double precision | yes |
| itc_cur_ue_d | Current ITC unearned |
double precision | yes |
| org_bkd_ltd_d | Original L-T-D book depreciation |
double precision | yes |
| allow_d | Allowance for bad debt |
double precision | yes |
| ytd_loss_d | Y-T-D loss on termination |
double precision | yes |
| ytd_gain_d | Y-T-D gain on termination |
double precision | yes |
| idc_ytd_d | IDC Y-T-D amount - book |
double precision | yes |
| idc_tax_ytd_d | IDC Y-T-D amount - tax |
double precision | yes |
| pay_tax_amt_d | Payoff/sale taxable amount |
double precision | yes |
| nbv_pay_d | Net book value at payoff |
double precision | yes |
| fed_pay_d | Federal book value at payoff |
double precision | yes |
| std_pay_d | State book value at payoff |
double precision | yes |
| amt_pay_d | Federal AMT book value at payoff |
double precision | yes |
| r_in_reduct_ytd_d | Residual income reduction Y-T-D |
double precision | yes |
| allow_ptx_c | Allow property tax assessment (Y/N) |
char(1) | yes |
| fmv_d | Fair market value |
double precision | yes |
| prop_tax_basis_d | Property tax basis |
double precision | yes |
| ger1_s | Additional method of depreciation 1 |
char(4) | yes |
| ger2_s | Additional method of depreciation 2 |
char(4) | yes |
| ger1_ytd_d | Depreciation Y-T-D additional 1 |
double precision | yes |
| ger1_ltd_d | Depreciation L-T-D additional 1 |
double precision | yes |
| ger2_ytd_d | Depreciation Y-T-D additional 2 |
double precision | yes |
| ger2_ltd_d | Depreciation L-T-D additional 2 |
double precision | yes |
| eqt_o_s | Equipment activity status prior to sale |
char(4) | yes |
| mov_o_s | Movement code prior to sale |
char(4) | yes |
| dfrd_tax_ytd_d | Deferred tax YTD amount |
double precision | yes |
| fsc_ytd_d | FSC exclusion Y-T-D amount |
double precision | yes |
| int_expn_ytd_d | Interest expenses Y-T-D amount |
double precision | yes |
| tax_inc_ytd_d | Taxable income Y-T-D amount |
double precision | yes |
| olb_pro_d | Off lease billing proceeds |
double precision | yes |
| d_run_s | Run date |
datetime | yes |
| t_run_s | Run time |
char(6) | yes |
| batch_s | Cash control batch number |
char(20) | yes |
| paid_off_ck_c | Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed |
char(1) | yes |
| supp_depr_ytd_d | Year-to-date supplemental depreciation |
double precision | yes |
| idc_asc842_ytd_d | IDC ASC 842 Y-T-D amount -- book |
double precision | yes |