| Description | Column | Datatype |
|---|---|---|
| Accrued to date | d_acc_s | datetime |
| CCA tax entity | tax_ent_s | char (4) |
| CCA class | cca_cls_s | char (4) |
| Sybase timestamp | timestamp | timestamp |
| Date of last update | d_lup_s | datetime |
| Time of last update | t_lup_s | char (6) |
| Start date | d_strt_s | datetime |
| CCA accrual method | cca_acc_s | char (4) |
| CCA disposition method | cca_disp_s | char (4) |
| Comment for adjustment | comment_s | char (80) |
| UCC type
1 - UCC 2 - Terminal loss 3 - Recapture |
ucc_typ_l | integer |
| Number of assets in pool as of accrued to date | cca_n_unt_l | integer |
| Class rate (effective rate used to calculate CCA) | p_class_rate_d | double precision |
| UCC on which the rate is applied in calculating CCA
For asset type = 'L' and 'O' only |
ucc_d | double precision |
| CCA allowed for the year
For asset type = 'L' and 'O' only |
cca_allow_d | double precision |
| CCA taken for the year
For asset type = 'L' and 'O' only |
taken_d | double precision |
| Adjustment for the year | adj_d | double precision |
| Opening undepreciated capital cost balance | open_d | double precision |
| Total additions in the year | cur_cost_d | double precision |
| Total proceeds in the year | pro_ytd_d | double precision |
| Total capital cost of disposal in the year | ex_cost_d | double precision |
| Total additions in previous year | tot_prev_cap_cost_d | double precision |
| Total adjustment in previous year | tot_prev_adj_d | double precision |
| Index name | Piece 1 | Piece 2 | Piece 3 |
|---|---|---|---|
| rqz_idx0 | d_acc_s | tax_ent_s | cca_cls_s |