LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rqp Table: CCA Pool

Description Column Datatype
CCA tax entity tax_ent_s char (4)
CCA class cca_cls_s char (4)
Oracle row stamp stamp_l number (10)
Date of last update d_lup_s date
Time of last update t_lup_s char (6)
Accrued to date d_acc_s date
Undepreciated capital cost balance
  opening balance for the next fiscal year
  = cap_cost - cca taken L-T-D - adjustment L-T-D
balance_d number (15,2)
Capital cost of additions during previous fiscal year
  This figure is needed for Straight Line Pool.
prev_cap_cost_d number (15,2)
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 number (15,2)

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