PeopleSoft 9
Asset Management

Table Name CAP_DET

Table Description
CAP_DET
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
CAP_NUM char(15) Yes Yes
CAP_SEQUENCE smallint Yes No
DESCR char(30) No No
ORIG_ADJ_SW char(1) No No
CAP_TYPE char(5) No Yes
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
DEPTID char(10) No No
PROJECT_ID char(15) No No
COST_ESTIMATED decimal(26,3) No No
COST_LIMIT decimal(26,3) No No
COST_OVER_RT decimal(9,8) No No
CLOSED_DT PSDATE No No
CAP_STATUS char(1) No No
OPEN_DT PSDATE No No
ESTIMATED_COMP_DT PSDATE No No
REQUESTOR_ID char(30) No No
HOLD_REQUESTOR char(30) No No
CURRENCY_CD char(3) No Yes
BD_UPDATE_FLAG char(1) No No
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_CAP_DET PK Yes
PS0CAP_DET IE1 No
PS1CAP_DET IE2 No
Member(s) of "PS_CAP_DET" Index
BUSINESS_UNIT
CAP_NUM
CAP_SEQUENCE
Member(s) of "PS0CAP_DET" Index
DEPTID
BUSINESS_UNIT
CAP_NUM
CAP_SEQUENCE
Member(s) of "PS1CAP_DET" Index
PROJECT_ID
BUSINESS_UNIT
CAP_NUM
CAP_SEQUENCE

Published December 16, 2006