PeopleSoft 9
Asset Management

Table Name CAP_ANNUAL_COST

Table Description
CAP_ANNUAL_COST
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
CAP_NUM char(15) Yes Yes
CAP_SEQUENCE smallint Yes Yes
FISCAL_YEAR smallint Yes No
EST_TOTAL_COST decimal(26,3) No No
COST_LIMIT decimal(26,3) No No
CURRENCY_CD char(3) No No
BD_UPDATE_FLAG char(1) No No
Index
Name Type Unique Member
PS_CAP_ANNUAL_COST PK Yes
Member(s) of "PS_CAP_ANNUAL_COST" Index
BUSINESS_UNIT
CAP_NUM
CAP_SEQUENCE
FISCAL_YEAR

Published December 16, 2006