PeopleSoft 9
Asset Management

Table Name ASSET_ATTRIBUTE

Table Description
ASSET_ATTRIBUTE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
EFFDT PSDATE Yes No
ASSET_COLOR char(15) No No
ASSET_WEIGHT decimal(12,3) No No
WEIGHT_UM char(3) No No
ASSET_HEIGHT decimal(12,3) No No
HEIGHT_UM char(3) No No
ASSET_WIDTH decimal(12,3) No No
WIDTH_UM char(3) No No
ASSET_LENGTH decimal(12,3) No No
LENGTH_UM char(3) No No
ASSET_CAPACITY decimal(12,3) No No
CAPACITY_UM char(3) No No
POWER_RATING decimal(12,3) No No
POWER_RATING_UM char(3) No No
Index
Name Type Unique Member
PS_ASSET_ATTRIBUTE PK Yes
Member(s) of "PS_ASSET_ATTRIBUTE" Index
BUSINESS_UNIT
ASSET_ID
EFFDT

Published December 16, 2006