PeopleSoft 9
Asset Management

Table Name BD_ASSET

Table Description
BD_ASSET
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
BOOK char(10) Yes No
ASSET_ID char(12) Yes No
ACCOUNT char(10) Yes No
ALTACCT char(10) Yes No
SCENARIO char(10) Yes No
PROJECT_ID char(15) Yes No
DEPTID char(10) Yes No
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
CF_SEQNO int Yes No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
BD_CASH_ACCOUNT char(10) No No
BD_ASSET_ACCOUNT char(10) No No
BD_DEPR_ACCOUNT char(10) No No
DESCR char(30) No No
ASSET_STATUS char(1) No No
ACQUISITION_FY smallint No No
ACQUISITION_AP smallint No No
IN_SERVICE_FY smallint No No
IN_SERVICE_AP smallint No No
COST decimal(26,3) No No
QUANTITY decimal(15,4) No No
ASSET_CLASS char(10) No No
PROFILE_ID char(10) No No
METHOD char(2) No No
SALVAGE_VALUE decimal(26,3) No No
DISPOSAL_CODE char(1) No No
PROCEEDS decimal(26,3) No No
REMOVAL_COST decimal(26,3) No No
LIFE smallint No No
RETIREMENT_FY smallint No No
RETIREMENT_AP smallint No No
SPREADTYPE smallint No No
SPREAD_TEMPLATE char(30) No No
CAP_NUM char(15) No No
CAP_SEQUENCE smallint No No
CURRENCY_CD char(3) No No
BD_LEDGER_TYPE char(25) No No
BD_UPDATE_FLAG char(1) No No
Index
Name Type Unique Member
PS_BD_ASSET PK Yes
PSWBD_ASSET IE1 No
Member(s) of "PS_BD_ASSET" Index
BUSINESS_UNIT
BOOK
ASSET_ID
ACCOUNT
ALTACCT
SCENARIO
PROJECT_ID
DEPTID
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
CF_SEQNO
Member(s) of "PSWBD_ASSET" Index
BUSINESS_UNIT
BOOK
ASSET_ID
ACCOUNT
ALTACCT
SCENARIO
PROJECT_ID
DEPTID
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1

Published December 16, 2006