LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rqp Table: CCA Pool

Description Column Datatype
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)
Accrued to date d_acc_s datetime
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
Capital cost of additions during previous fiscal year
  This figure is needed for Straight Line Pool.
prev_cap_cost_d double precision
Adjustment for previous fiscal year
  The value is entered through Adjustment Update after
  the year end processing.
  This figure is needed for Straight Line Pool.
prev_adj_d double precision

rqp Indexes:

Index name Piece 1 Piece 2
rqp_idx0 tax_ent_s cca_cls_s
rqp_idx1 cca_cls_s tax_ent_s


HomeTableIndexes