PeopleSoft 9
Asset Management

Table Name DEPR_COMP

Table Description
DEPR_COMP
Columns
Name Datatype Is PK Is FK
RUN_ID char(25) Yes Yes
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes No
CF_SEQNO int Yes No
FISCAL_YEAR smallint Yes No
START_PD smallint Yes No
END_PD smallint Yes No
PROJECT_ID char(15) Yes No
DEPTID char(10) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
TRANS_TYPE char(3) Yes No
TRANS_IN_OUT char(1) Yes No
ACTUAL_END_PD smallint No No
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
TRANS_CODE char(5) No No
TRANS_DT PSDATE No No
YTD_FLAG char(1) No No
ACTIVITY_SW smallint No No
DEPR decimal(26,3) No No
DEPR_YTD decimal(26,3) No No
CURRENCY_CD char(3) No No
ARCHIVE_ID char(8) No No
MANUAL_DEPR_TYPE char(1) No No
SPEC_DEPR decimal(26,3) No No
INITIAL_DEPR decimal(26,3) No No
ACCEL_DEPR decimal(26,3) No No
INCREASE_DEPR decimal(26,3) No No
STANDARD_DEPR decimal(26,3) No No
Index
Name Type Unique Member
PS_DEPR_COMP PK Yes
PSADEPR_COMP IE1 No
PSBDEPR_COMP IE2 No
Member(s) of "PS_DEPR_COMP" Index
RUN_ID
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
CF_SEQNO
FISCAL_YEAR
START_PD
END_PD
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE
TRANS_TYPE
TRANS_IN_OUT
Member(s) of "PSADEPR_COMP" Index
FISCAL_YEAR
START_PD
END_PD
Member(s) of "PSBDEPR_COMP" Index
BUSINESS_UNIT
ASSET_ID
BOOK
CATEGORY

Published December 16, 2006