rqy Table: CCA Master Year End
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rqy Table: CCA Master Year End

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7
rqy_idx0 d_acc_s tax_ent_s cca_cls_s cca_typ_c unit_s    
rqy_idx1 d_acc_s unit_s          
rqy_idx2 d_acc_s por_s com_s reg_s off_s lse_s unit_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
d_acc_s
Accrued to date
datetime no
tax_ent_s
CCA tax entity
char(4) no
cca_cls_s
CCA class
char(4) no
cca_typ_c
CCA type (L/O/P)
  L - Specified leasing property
  O - Separate class
  P - Pool
char(1) no
unit_s
Asset
char(10) no
timestamp
Record modification stamp
timestamp yes
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
d_serv_s
In-service date
datetime yes
d_lup_s
Date of last update
datetime yes
t_lup_s
Time of last update
char(6) yes
d_strt_s
Fiscal year start date
datetime yes
cca_acc_s
CCA accrual method
char(4) yes
cca_disp_s
CCA disposition method
char(4) yes
eqt_s
Equipment activity status
char(4) yes
off_c
Off-lease (Y/N)
char(1) yes
desc_s
Equipment description
char(36) yes
comment_s
Comment for adjustment
char(80) yes
ucc_typ_l
UCC type
  1 - UCC
  2 - Terminal loss
  3 - Recapture
integer yes
p_rate_d
Effective rate used to calculate CCA
double precision yes
p_addon_d
Add-on rate
double precision yes
cap_cost_d
CCA capital cost
double precision yes
adj_d
Adjustment for the year
double precision yes
cum_adj_d
Cumulative adjustment prior
double precision yes
open_d
Opening undepreciated capital cost balance
double precision yes
ord_d
Ordinary CCA for the year
double precision yes
cum_ord_d
Ordinary CCA cumulative to the start of the year
double precision yes
cum_taken_d
CCA taken cumulative to the start of the year for types L,O
double precision yes
prn_accrued_d
Principal accrued for the year
double precision yes
cum_prn_d
Principal repayment accrued at start of the year
double precision yes
prn_taken_d
CCA taken cumlative on the current lease
  For asset type = 'L' only
double precision yes
cca_allow_d
CCA allowed for the year
  For asset type = 'L' and 'O' only
double precision yes
taken_d
CCA taken for the year
  For asset type = 'L' and 'O' only
double precision yes
ucc_d
UCC on which the rate is applied in calculating CCA
  For asset type = 'L' and 'O' only
double precision yes
prorated_d
Prorated ordinary CCA for the year
  For asset type = 'L' only
double precision yes
proceeds_d
Proceeds
double precision yes
cca_itc_d
CCA ITC (investment tax credit)
double precision yes