ASSET_ATTRIBUTE(SQL Table) |
Index Back |
|---|---|
Asset Attributes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | ASSET_COLOR | Character(15) | VARCHAR2(15) NOT NULL | Asset Color |
| 5 | ASSET_WEIGHT | Number(13,3) | DECIMAL(12,3) NOT NULL | Asset Weight |
| 6 | WEIGHT_UM | Character(3) | VARCHAR2(3) NOT NULL |
Asset Weight Unit of Measure
Prompt Table: UNITS_TBL |
| 7 | ASSET_HEIGHT | Number(13,3) | DECIMAL(12,3) NOT NULL | Asset Height |
| 8 | HEIGHT_UM | Character(3) | VARCHAR2(3) NOT NULL |
Asset Height Unit of Measure
Prompt Table: UNITS_TBL |
| 9 | ASSET_WIDTH | Number(13,3) | DECIMAL(12,3) NOT NULL | Asset Width |
| 10 | WIDTH_UM | Character(3) | VARCHAR2(3) NOT NULL |
Asset Width Unit of Measure
Prompt Table: UNITS_TBL |
| 11 | ASSET_LENGTH | Number(13,3) | DECIMAL(12,3) NOT NULL | Asset Length |
| 12 | LENGTH_UM | Character(3) | VARCHAR2(3) NOT NULL |
Asset Length Unit of Measure
Prompt Table: UNITS_TBL |
| 13 | ASSET_CAPACITY | Number(13,3) | DECIMAL(12,3) NOT NULL | Asset Capacity |
| 14 | CAPACITY_UM | Character(3) | VARCHAR2(3) NOT NULL |
Capacity Units
Prompt Table: UNITS_TBL |
| 15 | POWER_RATING | Number(13,3) | DECIMAL(12,3) NOT NULL | Power Rating |
| 16 | POWER_RATING_UM | Character(3) | VARCHAR2(3) NOT NULL |
Power Rating Units
Prompt Table: UNITS_TBL |