rcs Table: Historical Asset
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

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 DescriptionDatatype ¿? 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