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

Database Reference Oracle 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
stamp_l
Record modification stamp
NUMBER(10) no
dlr_s
Vendor
CHAR(9) no
d_com1_s
Equipment acquisition date
DATE yes
d_serv_s
In-service date
DATE yes
d_act_s
Equipment activity status date
DATE yes
d_mat_s
Date of equipment sell
DATE yes
d_bok_s
Book depreciation start date
DATE yes
d_itc_s
ITC accrued to date
DATE yes
d_lien_s
Last lien date
DATE 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
VARCHAR2(36) yes
pmt_l
Number of payments accrued
NUMBER(10) yes
trm_l
Lease term
NUMBER(10) 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
org_d
Original acquisition cost
NUMBER(15,2) yes
res_d
Residual amount
NUMBER(15,2) yes
rec_ytd_d
Net receipts Y-T-D
NUMBER(15,2) yes
oth_ytd_d
Other income Y-T-D
NUMBER(15,2) yes
pay_d
Payoff
NUMBER(15,2) yes
pro_sale_d
Proceeds of sale
NUMBER(15,2) yes
gnls_d
Gain/Loss on termination
NUMBER(15,2) 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
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
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
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
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
fed_amt_ltd_d
Federal AMT L-T-D amount
NUMBER(15,2) yes
fed_amt_ytd_d
Federal AMT Y-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
org_bk_basis_d
Original book basis
NUMBER(15,2) yes
adj_bk_basis_d
Adjustment to book basis
NUMBER(15,2) yes
itc_cur_ue_d
Current ITC unearned
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
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
allow_ptx_c
Allow property tax assessment (Y/N)
CHAR(1) yes
fmv_d
Fair market value
NUMBER(15,2) yes
prop_tax_basis_d
Property tax basis
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_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_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
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
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
olb_pro_d
Off lease billing proceeds
NUMBER(15,2) yes
d_run_s
Run date
DATE yes
t_run_s
Run time
CHAR(6) yes
batch_s
Cash control batch number
VARCHAR2(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
NUMBER(15,2) yes
idc_asc842_ytd_d
IDC ASC 842 Y-T-D amount -- book
NUMBER(15,2) yes