PeopleSoft 9
Asset Management

Table Name BD_ASSET_DEPR

Table Description
BD_ASSET_DEPR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
BOOK char(10) Yes Yes
ASSET_ID char(12) Yes Yes
ACCOUNT char(10) Yes Yes
ALTACCT char(10) Yes Yes
PROJECT_ID char(15) Yes Yes
DEPTID char(10) Yes Yes
OPERATING_UNIT char(8) Yes Yes
PRODUCT char(6) Yes Yes
FUND_CODE char(5) Yes Yes
CLASS_FLD char(5) Yes Yes
PROGRAM_CODE char(5) Yes Yes
BUDGET_REF char(8) Yes Yes
AFFILIATE char(5) Yes Yes
AFFILIATE_INTRA1 char(10) Yes Yes
AFFILIATE_INTRA2 char(10) Yes Yes
SCENARIO char(10) Yes Yes
FISCAL_YEAR smallint Yes No
ACCOUNTING_PERIOD smallint Yes No
BD_LEDGER_TYPE char(25) Yes No
BUDGET_PERIOD char(8) Yes No
CF_SEQNO int Yes Yes
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
DEPR decimal(26,3) No No
NET_BK_VALUE decimal(26,3) No No
CURRENCY_CD char(3) No No
BD_UPDATE_FLAG char(1) No No
Index
Name Type Unique Member
PS_BD_ASSET_DEPR PK Yes
PS0BD_ASSET_DEPR IE1 No
PSWBD_ASSET_DEPR IE2 No
Member(s) of "PS_BD_ASSET_DEPR" Index
BUSINESS_UNIT
BOOK
ASSET_ID
ACCOUNT
ALTACCT
PROJECT_ID
DEPTID
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
SCENARIO
FISCAL_YEAR
ACCOUNTING_PERIOD
BD_LEDGER_TYPE
BUDGET_PERIOD
CF_SEQNO
Member(s) of "PS0BD_ASSET_DEPR" Index
DEPR
BUSINESS_UNIT
BOOK
ASSET_ID
ACCOUNT
ALTACCT
PROJECT_ID
DEPTID
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
Member(s) of "PSWBD_ASSET_DEPR" Index
BUSINESS_UNIT
BOOK
ASSET_ID
ACCOUNT
ALTACCT
PROJECT_ID
DEPTID
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2

Published December 16, 2006