| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 |
|---|---|---|---|---|---|---|
| ryr_idx0 | por_s | com_s | reg_s | off_s | lse_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 |
| stamp_l | Record modification stamp |
NUMBER(10) | no |
| d_com_s | Equipment acquistion date |
DATE | yes |
| d_serv_s | In-service date |
DATE | yes |
| d_eqt_s | Equipment activity status date |
DATE | yes |
| d_mat_s | Maturity date/date of equipment sell |
DATE | yes |
| d_bok_s | Book depreciation start date |
DATE | yes |
| sold_s | Equipment activity status |
CHAR(4) | yes |
| st_s | State code (RST.ST_S code) |
CHAR(2) | 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 |
| ls_typ_s | Lease type code |
CHAR(4) | yes |
| fed_amt_s | Federal AMT method |
CHAR(4) | yes |
| tax_type_s | Tax type |
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 |
| 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 |
| desc_s | General description |
VARCHAR2(36) | yes |
| adj_depr_life_l | Adjustment depreciable life |
NUMBER(10) | yes |
| tax_d | Portfolio tax rate |
NUMBER(15,5) | yes |
| pay_st_rate_d | Payoff/sale state rate |
NUMBER(15,5) | yes |
| pay_ct_rate_d | Payoff/sale county rate |
NUMBER(15,5) | yes |
| pay_cy_rate_d | Payoff/sale city rate |
NUMBER(15,5) | yes |
| taxbasis_d | Starting book value for depreciation |
NUMBER(15,2) | yes |
| itcbasis_d | Starting book value for ITC |
NUMBER(15,2) | yes |
| sal_bkd_d | Book value salvage value |
NUMBER(15,2) | yes |
| sal_st_d | State salvage value |
NUMBER(15,2) | yes |
| itc_org_d | Original ITC |
NUMBER(15,2) | yes |
| itc_ltd_d | ITC L-T-D |
NUMBER(15,2) | yes |
| itc_ytd_d | ITC Y-T-D |
NUMBER(15,2) | yes |
| itc_sus_d | ITC sustained |
NUMBER(15,2) | yes |
| itc_to_rev_d | ITC to reverse |
NUMBER(15,2) | yes |
| ytd_bkd_d | Depreciation Y-T-D book |
NUMBER(15,2) | yes |
| ytd_fed_d | Depreciation Y-T-D federal |
NUMBER(15,2) | yes |
| ytd_st_d | Depreciation Y-T-D state |
NUMBER(15,2) | yes |
| ltd_bkd_d | Depreciation L-T-D book |
NUMBER(15,2) | yes |
| ltd_fed_d | Depreciation L-T-D federal |
NUMBER(15,2) | yes |
| ltd_st_d | Depreciation L-T-D state |
NUMBER(15,2) | yes |
| etc_org_d | ETC original total |
NUMBER(15,2) | yes |
| etc_ytd_d | ETC Y-T-D |
NUMBER(15,2) | yes |
| etc_ltd_d | ETC L-T-D |
NUMBER(15,2) | yes |
| etc_rev_d | ETC to reverse |
NUMBER(15,2) | yes |
| billed_rec_ytd_d | Receipts Y-T-D (billed) |
NUMBER(15,2) | yes |
| oth_ytd_d | Other income Y-T-D |
NUMBER(15,2) | yes |
| po_rec_d | Payoff amount |
NUMBER(15,2) | yes |
| fed_amt_ltd_d | Federal AMT L-T-D amount |
NUMBER(15,2) | yes |
| man_bas_d | Manufacturer's depreciation basis |
NUMBER(15,2) | yes |
| pmt_acc_d | Payment amount accrued Y-T-D |
NUMBER(15,2) | yes |
| bk_basis_d | Book tax basis |
NUMBER(15,2) | yes |
| l_in_ytd_d | Lessor income Y-T-D |
NUMBER(15,2) | yes |
| ast_cst_d | Original asset cost |
NUMBER(15,2) | yes |
| gp_beg_d | Gross profit beginning balance |
NUMBER(15,2) | yes |
| gp_rst_d | Gross profit restored |
NUMBER(15,2) | yes |
| org_bk_basis_d | Original book basis |
NUMBER(15,2) | yes |
| adj_bk_basis_d | Adjustment to book basis |
NUMBER(15,2) | yes |
| org_bkd_ltd_d | Original L-T-D book depreciation |
NUMBER(15,2) | yes |
| allow_d | Allowance for bad debt |
NUMBER(15,2) | yes |
| ytd_loss_d | Y-T-D loss on termination |
NUMBER(15,2) | yes |
| ytd_gain_d | Y-T-D gain on termination |
NUMBER(15,2) | yes |
| idc_ytd_d | IDC Y-T-D amount - book |
NUMBER(15,2) | yes |
| idc_tax_ytd_d | IDC Y-T-D amount - tax |
NUMBER(15,2) | yes |
| fed_amt_ytd_d | Federal AMT Y-T-D amount |
NUMBER(15,2) | yes |
| pay_tax_amt_d | Payoff/sale taxable amount |
NUMBER(15,2) | yes |
| nbv_pay_d | Net book value at payoff |
NUMBER(15,2) | yes |
| fed_pay_d | Federal book value at payoff |
NUMBER(15,2) | yes |
| std_pay_d | State book value at payoff |
NUMBER(15,2) | yes |
| amt_pay_d | Federal AMT book value at payoff |
NUMBER(15,2) | yes |
| r_in_reduct_ytd_d | Residual income reduction Y-T-D |
NUMBER(15,2) | yes |
| ger1_s | Additional method of depreciation 1 |
CHAR(4) | yes |
| ger2_s | Additional method of depreciation 2 |
CHAR(4) | yes |
| ger1_mtd_d | Depreciation M-T-D additional 1 |
NUMBER(15,2) | yes |
| ger1_ytd_d | Depreciation Y-T-D additional 1 |
NUMBER(15,2) | yes |
| ger1_ltd_d | Depreciation L-T-D additional 1 |
NUMBER(15,2) | yes |
| ger2_mtd_d | Depreciation M-T-D additional 2 |
NUMBER(15,2) | yes |
| ger2_ytd_d | Depreciation Y-T-D additional 2 |
NUMBER(15,2) | yes |
| ger2_ltd_d | Depreciation L-T-D additional 2 |
NUMBER(15,2) | yes |
| def_bkd_d | Deferred book depreciation amount |
NUMBER(15,2) | yes |
| dfrd_tax_ytd_d | Deferred tax YTD amount |
NUMBER(15,2) | yes |
| fsc_ytd_d | FSC exclusion Y-T-D amount |
NUMBER(15,2) | yes |
| int_expn_ytd_d | Interest expenses Y-T-D amount |
NUMBER(15,2) | yes |
| tax_inc_ytd_d | Taxable income Y-T-D amount |
NUMBER(15,2) | yes |
| supp_depr_ytd_d | Year-to-date supplemental depreciation |
NUMBER(15,2) | yes |
| idc_asc842_ytd_d | IDC ASC 842 Y-T-D amount -- book |
NUMBER(15,2) | yes |