ryr Table: End of Year Tax

Database Reference Sybase DBMS

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	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
d_com_s	Equipment acquistion date	datetime	yes
d_serv_s	In-service date	datetime	yes
d_eqt_s	Equipment activity status date	datetime	yes
d_mat_s	Maturity date/date of equipment sell	datetime	yes
d_bok_s	Book depreciation start date	datetime	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	char(36)	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
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
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
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
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
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
billed_rec_ytd_d	Receipts Y-T-D (billed)	double precision	yes
oth_ytd_d	Other income Y-T-D	double precision	yes
po_rec_d	Payoff amount	double precision	yes
fed_amt_ltd_d	Federal AMT L-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
gp_beg_d	Gross profit beginning balance	double precision	yes
gp_rst_d	Gross profit restored	double precision	yes
org_bk_basis_d	Original book basis	double precision	yes
adj_bk_basis_d	Adjustment to book basis	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
fed_amt_ytd_d	Federal AMT Y-T-D amount	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
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	double precision	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_mtd_d	Depreciation M-T-D additional 2	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
def_bkd_d	Deferred book depreciation amount	double precision	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
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