rqm Table: CCA Asset Master

Database Reference Sybase DBMS

rqm Table: CCA Asset Master

Indexes

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	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
d_lup_s	Date of last update	datetime	yes
t_lup_s	Time of last update	char(6)	yes
d_acc_s	Accrued to date	datetime	yes
cca_acc_s	CCA accrual method	char(4)	yes
cca_disp_s	CCA disposition method	char(4)	yes
p_addon_d	Add-on rate	double precision	yes
p_sch_prcnt_d	Schedule percentage	double precision	yes
cap_cost_d	CCA capital cost	double precision	yes
adj_ltd_d	Adjustment L-T-D (for types L, O)	double precision	yes
cca_itc_d	CCA ITC (investment tax credit)	double precision	yes
balance_d	Undepreciated capital cost balance opening balance for the next fiscal year = cap_cost - cca taken L-T-D - adjustment L-T-D	double precision	yes
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)	double precision	yes
taken_ltd_d	CCA taken L-T-D (for types L,O)	double precision	yes
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.	double precision	yes
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.	double precision	yes
prn_ltd_taken_d	CCA taken L-T-D on current lease This field is cleared when asset is placed on a new lease.	double precision	yes
prorated_ltd_d	Prorated ordinary CCA L-T-D on current lease For type = L only	double precision	yes
org_cap_cost_d	CCA original capital cost	double precision	yes