| Description | Column | Datatype |
|---|---|---|
| CCA tax entity | tax_ent_s | char (4) |
| CCA class | cca_cls_s | char (4) |
| CCA type (L/O/P)
L - Specified leasing property O - Separate class P - Pool |
cca_typ_c | char (1) |
| Asset | unit_s | char (10) |
| Sybase timestamp | timestamp | timestamp |
| Date of last update | d_lup_s | datetime |
| Time of last update | t_lup_s | char (6) |
| Accrued to date | d_acc_s | datetime |
| CCA accrual method | cca_acc_s | char (4) |
| CCA disposition method | cca_disp_s | char (4) |
| Add-on rate | p_addon_d | double precision |
| Schedule percentage | p_sch_prcnt_d | double precision |
| CCA capital cost | cap_cost_d | double precision |
| Adjustment L-T-D (for types L, O) | adj_ltd_d | double precision |
| CCA ITC (investment tax credit) | cca_itc_d | double precision |
| Undepreciated capital cost balance
opening balance for the next fiscal year = cap_cost - cca taken L-T-D - adjustment L-T-D |
balance_d | double precision |
| 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) |
ord_ltd_d | double precision |
| CCA taken L-T-D
(for types L,O) |
taken_ltd_d | double precision |
| 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_ltd1_d | double precision |
| 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_accrued_ytd_d | double precision |
| CCA taken L-T-D on current lease
This field is cleared when asset is placed on a new lease. |
prn_ltd_taken_d | double precision |
| Prorated ordinary CCA L-T-D on current lease
For type = L only |
prorated_ltd_d | double precision |
| CCA original capital cost | org_cap_cost_d | double precision |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 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 |