PeopleSoft 9
Asset Management

Table Name ASSET_UD_ATTR

Table Description
ASSET_UD_ATTR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
EFFDT PSDATE Yes Yes
AM_UD_ATTR_ID char(10) Yes Yes
VALUE_ATTR char(7) No No
UNIT_OF_MEASURE char(3) No No
Index
Name Type Unique Member
PS_ASSET_UD_ATTR PK Yes
Member(s) of "PS_ASSET_UD_ATTR" Index
BUSINESS_UNIT
ASSET_ID
EFFDT
AM_UD_ATTR_ID

Published December 16, 2006