PeopleSoft 9
Asset Management

Table Name PI_EXTRACT

Table Description
PI_EXTRACT
Columns
Name Datatype Is PK Is FK
PI_ID char(10) Yes Yes
PI_LINE_NUM int Yes Yes
ASSET_ID char(12) Yes No
CF_SEQNO int Yes No
PROJECT_ID char(15) Yes No
DEPTID char(10) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
BUSINESS_UNIT char(5) 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
ACQUISITION_CD char(1) No No
COST decimal(26,3) No No
TAG_NUMBER char(12) No No
SERIAL_ID char(20) No No
MODEL char(30) No No
LOCATION char(10) No No
EMPLID char(11) No No
DESCR char(30) No No
MANUFACTURER char(30) No No
INVENTORY_DT PSDATE No No
Index
Name Type Unique Member
PS_PI_EXTRACT PK Yes
PS0PI_EXTRACT IE1 No
PS1PI_EXTRACT IE2 No
Member(s) of "PS_PI_EXTRACT" Index
PI_ID
PI_LINE_NUM
ASSET_ID
CF_SEQNO
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE
Member(s) of "PS0PI_EXTRACT" Index
TAG_NUMBER
PI_ID
PI_LINE_NUM
ASSET_ID
CF_SEQNO
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE
Member(s) of "PS1PI_EXTRACT" Index
LOCATION
PI_ID
PI_LINE_NUM
ASSET_ID
CF_SEQNO
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE

Published December 16, 2006