PeopleSoft 9
Asset Management

Table Name AM_ASSET_SD

Table Description
AM_ASSET_SD
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
SD_RECNAME CHAR(15) Yes No
SEQ_NUM SMALLINT Yes No
SD_DATE_1 PSDATE No No
SD_DATE_2 PSDATE No No
SD_DATE_3 PSDATE No No
SD_TIME_1 PSTIME No No
SD_TIME_2 PSTIME No No
SD_TEXT4_1 CHAR(4) No No
SD_TEXT4_2 CHAR(4) No No
SD_TEXT4_3 CHAR(4) No No
SD_TEXT4_4 CHAR(4) No No
SD_TEXT4_5 CHAR(4) No No
SD_TEXT20_1 CHAR(20) No No
SD_TEXT20_2 CHAR(20) No No
SD_TEXT20_3 CHAR(20) No No
SD_TEXT20_4 CHAR(20) No No
SD_TEXT20_5 CHAR(20) No No
SD_TEXT50_1 CHAR(50) No No
SD_TEXT50_2 CHAR(50) No No
SD_INT_1 INT No No
SD_INT_2 INT No No
SD_INT_3 INT No No
SD_INT_4 INT No No
SD_INT_5 INT No No
SD_NUM9_1 DECIMAL(9,2) No No
SD_NUM9_2 DECIMAL(9,2) No No
SD_NUM9_3 DECIMAL(9,2) No No
SD_NUM19_1 DECIMAL(19,4) No No
SD_NUM19_2 DECIMAL(19,4) No No
Index
Name Type Unique Member
PS_AM_ASSET_SD PK Yes
Member(s) of "PS_AM_ASSET_SD" Index
BUSINESS_UNIT
ASSET_ID
SD_RECNAME
SEQ_NUM

Published December 16, 2006