rqy Table: CCA Master Year End

Database Reference

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