ryr Table: End of Year Tax

Database Reference

ryr Table: End of Year Tax

Indexes

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