PeopleSoft 9
Asset Management

Table Name DEPR_RPT_CF_SUM

Table Description
DEPR_RPT_CF_SUM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
BOOK char(10) Yes Yes
GROUP_ASSET_FLAG char(1) Yes Yes
FISCAL_YEAR smallint Yes Yes
ACCOUNTING_PERIOD smallint Yes Yes
OPERATING_UNIT char(8) Yes No
PRODUCT char(6) Yes No
FUND_CODE char(5) Yes No
CLASS_FLD char(5) Yes No
PROGRAM_CODE char(5) Yes No
BUDGET_REF char(8) Yes No
AFFILIATE char(5) Yes No
AFFILIATE_INTRA1 char(10) Yes No
AFFILIATE_INTRA2 char(10) Yes No
PROJECT_ID char(15) Yes No
DEPTID char(10) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
PROFILE_ID char(10) Yes No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
ACCOUNT_FA char(10) No No
ACCOUNT_AD char(10) No No
DEPR decimal(26,3) No No
DEPR_YTD decimal(26,3) No No
DEPR_LTD decimal(26,3) No No
CURRENCY_CD char(3) 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
COST decimal(26,3) No No
SALVAGE_VALUE decimal(26,3) No No
GRP_COST decimal(26,3) No No
GRP_SALVAGE_VALUE decimal(26,3) No No
ACCUM_DEPR_ADD decimal(26,3) No No
ACCUM_DEPR_TRF decimal(26,3) No No
ACCUM_DEPR_RCT decimal(26,3) No No
ACCUM_DEPR_REI decimal(26,3) No No
ACCUM_DEPR_RET decimal(26,3) No No
COST_ADD decimal(26,3) No No
COST_ADJ decimal(26,3) No No
COST_TRF decimal(26,3) No No
COST_RCT decimal(26,3) No No
COST_REI decimal(26,3) No No
COST_RET decimal(26,3) No No
DEPR_PDP decimal(26,3) No No
Index
Name Type Unique Member
PS_DEPR_RPT_CF_SUM PK Yes
PSWDEPR_RPT_CF_SUM IE1 No
Member(s) of "PS_DEPR_RPT_CF_SUM" Index
BUSINESS_UNIT
BOOK
GROUP_ASSET_FLAG
FISCAL_YEAR
ACCOUNTING_PERIOD
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE
PROFILE_ID
Member(s) of "PSWDEPR_RPT_CF_SUM" Index
BUSINESS_UNIT
BOOK
GROUP_ASSET_FLAG
FISCAL_YEAR
ACCOUNTING_PERIOD
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
PROJECT_ID
DEPTID

Published December 16, 2006