PeopleSoft 9
Asset Management

Table Name DEPR_CAP_YR_TBL

Table Description
DEPR_CAP_YR_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
COST_LIMIT_CD char(10) Yes Yes
AMOUNT decimal(26,3) Yes No
LOW_VALUE_SW char(1) No No
MSG_SEVERITY char(1) No No
CURRENCY_CD char(3) No No
Index
Name Type Unique Member
PS_DEPR_CAP_YR_TBL PK Yes
Member(s) of "PS_DEPR_CAP_YR_TBL" Index
SETID
COST_LIMIT_CD
AMOUNT

Published December 16, 2006