PeopleSoft 9
Asset Management

Table Name COST

Table Description
COST
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes Yes
CF_SEQNO int Yes No
GROUP_ASSET_ID char(12) Yes No
MEM_IN_SERVICE_DT PSDATE Yes No
IU_MAP_KEY smallint Yes No
CONVENTION char(2) Yes 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
PROJECT_ID char(15) No No
DEPTID char(10) No No
CATEGORY char(5) No Yes
COST_TYPE char(1) No Yes
TRANS_TYPE char(3) No No
TRANS_IN_OUT char(1) No No
TRANS_CODE char(5) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
ACTIVITY_SW smallint No No
RETIRE_SW smallint No No
QUANTITY decimal(15,4) No No
TXN_COST decimal(26,3) No No
COST decimal(26,3) No No
TRANSFER_BU char(5) No No
TRANSFER_ASSET_ID char(12) No No
TRANSFER_BOOK char(10) No No
OPRID char(30) No No
TXN_CURRENCY_CD char(3) No No
FROM_CUR char(3) No No
ARCHIVE_ID char(8) No No
GRP_ACCUM_DEPR decimal(26,3) No No
GRP_DEPR_YTD decimal(26,3) No No
GRP_DEPR_CALC_STAT char(1) No No
SALVAGE_VALUE decimal(26,3) No No
RT_TYPE char(5) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
RT_EFFDT PSDATE No No
Index
Name Type Unique Member
PS_COST PK Yes
PSACOST IE1 No
PSBCOST IE2 No
PSCCOST IE3 No
Member(s) of "PS_COST" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
CF_SEQNO
GROUP_ASSET_ID
MEM_IN_SERVICE_DT
IU_MAP_KEY
CONVENTION
Member(s) of "PSACOST" Index
BUSINESS_UNIT
BOOK
ACCOUNTING_DT
Member(s) of "PSBCOST" Index
BUSINESS_UNIT
BOOK
ACCOUNTING_DT
CATEGORY
COST_TYPE
TRANS_TYPE
TRANS_IN_OUT
TRANS_CODE
Member(s) of "PSCCOST" Index
ASSET_ID
BUSINESS_UNIT
BOOK
CATEGORY

Published December 16, 2006