rqm Table: CCA Asset Master

Name	Segment 1	Segment 2	Segment 3	Segment 4
rqm_idx0	tax_ent_s	cca_cls_s	cca_typ_c	unit_s
rqm_idx1	cca_cls_s	cca_typ_c	unit_s
rqm_idx2	unit_s

Columns
Name	Description	Datatype ¿?	Allow Null
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
d_lup_s	Date of last update
t_lup_s	Time of last update
d_acc_s	Accrued to date
cca_acc_s	CCA accrual method
cca_disp_s	CCA disposition method
p_addon_d	Add-on rate
p_sch_prcnt_d	Schedule percentage
cap_cost_d	CCA capital cost
adj_ltd_d	Adjustment L-T-D (for types L, O)
cca_itc_d	CCA ITC (investment tax credit)
balance_d	Undepreciated capital cost balance opening balance for the next fiscal year = cap_cost - cca taken L-T-D - adjustment L-T-D
ord_ltd_d	Ordinary CCA L-T-D as of last year end (CCA would have been, had the asset been the only asset in the class and fully depreciated at all times)
taken_ltd_d	CCA taken L-T-D (for types L,O)
prn_ltd1_d	Principal accrued L-T-D on current lease at last year end This field is cleared when asset is placed on a new lease.
prn_accrued_ytd_d	Principal accrued Y-T-D on current lease at last year end This field is cleared when asset is placed on a new lease. This field is updated in accruals when payments are due. It is added to the prn_ltd_d during year end and then cleared.
prn_ltd_taken_d	CCA taken L-T-D on current lease This field is cleared when asset is placed on a new lease.
prorated_ltd_d	Prorated ordinary CCA L-T-D on current lease For type = L only
org_cap_cost_d	CCA original capital cost