PeopleSoft 9
Asset Management

Table Name TAX_DEPR_BAL

Table Description
TAX_DEPR_BAL
Columns
Name Datatype Is PK Is FK
TAX_RPT_ENTITY char(10) Yes Yes
ENTITY_BOOK char(10) Yes Yes
ASSET_BLOCK char(20) Yes Yes
FISCAL_YEAR smallint Yes No
TAX_CLASS_AM char(6) Yes Yes
OPEN_WDV_VAL decimal(26,3) No No
ADD_50_RULE decimal(26,3) No No
ADD_REG_TAX decimal(26,3) No No
TOTAL_PROCEEDS decimal(26,3) No No
CCA_RATE decimal(6,3) No No
DEPR_AMOUNT decimal(26,3) No No
DEPR_AMT_50 decimal(26,3) No No
MANUAL_ADJ decimal(26,3) No No
CLOSING_WDV decimal(26,3) No No
LAST_UPDATED_BY char(30) No No
CURRENCY_CD char(3) No No
Index
Name Type Unique Member
PS_TAX_DEPR_BAL PK Yes
Member(s) of "PS_TAX_DEPR_BAL" Index
TAX_RPT_ENTITY
ENTITY_BOOK
ASSET_BLOCK
FISCAL_YEAR
TAX_CLASS_AM

Published December 16, 2006