rcs Table: Historical Asset

Database Reference

rcs Table: Historical Asset

Indexes

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
com_s	Company
reg_s	Region
off_s	Office
lse_s	Lease
unit_s	Asset
	Record modification stamp
dlr_s	Vendor
d_com1_s	Equipment acquisition date
d_serv_s	In-service date
d_act_s	Equipment activity status date
d_mat_s	Date of equipment sell
d_bok_s	Book depreciation start date
d_itc_s	ITC accrued to date
d_lien_s	Last lien date
st_s	State code (RST.ST_S code)
eqt_s	Equipment activity status
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
fed_amt_s	Federal AMT method
tax_type_s	Tax type
ls_typ_s	Lease type code
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)
dyr_c	Flag for deletion (Y/N)
tax_rptg_c	Asset appears on tax reports (Y/N)
gp_typ_c	Gross profit type (R/U) R - related U - unrelated
rpt_ptax_c	Report property tax (Y/N)
desc_s	Asset description
pmt_l	Number of payments accrued
trm_l	Lease term
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
org_d	Original acquisition cost
res_d	Residual amount
rec_ytd_d	Net receipts Y-T-D
oth_ytd_d	Other income Y-T-D
pay_d	Payoff
pro_sale_d	Proceeds of sale
gnls_d	Gain/Loss on termination
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
ltd_bkd_d	Depreciation L-T-D book
ltd_fed_d	Depreciation L-T-D federal
ltd_st_d	Depreciation L-T-D state
ytd_bkd_d	Depreciation Y-T-D book
ytd_fed_d	Depreciation Y-T-D federal
ytd_st_d	Depreciation Y-T-D state
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
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
fed_amt_ltd_d	Federal AMT L-T-D amount
fed_amt_ytd_d	Federal AMT Y-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
org_bk_basis_d	Original book basis
adj_bk_basis_d	Adjustment to book basis
itc_cur_ue_d	Current ITC unearned
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
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
allow_ptx_c	Allow property tax assessment (Y/N)
fmv_d	Fair market value
prop_tax_basis_d	Property tax basis
ger1_s	Additional method of depreciation 1
ger2_s	Additional method of depreciation 2
ger1_ytd_d	Depreciation Y-T-D additional 1
ger1_ltd_d	Depreciation L-T-D additional 1
ger2_ytd_d	Depreciation Y-T-D additional 2
ger2_ltd_d	Depreciation L-T-D additional 2
eqt_o_s	Equipment activity status prior to sale
mov_o_s	Movement code prior to sale
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
olb_pro_d	Off lease billing proceeds
d_run_s	Run date
t_run_s	Run time
batch_s	Cash control batch number
paid_off_ck_c	Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed
supp_depr_ytd_d	Year-to-date supplemental depreciation
idc_asc842_ytd_d	IDC ASC 842 Y-T-D amount -- book