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 |