BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW
ASSET_IDEFFDTPrompt Table: UNITS_TBL
Prompt Table: UNITS_TBL
Prompt Table: UNITS_TBL
Prompt Table: UNITS_TBL
Prompt Table: UNITS_TBL
Prompt Table: UNITS_TBL
ASSET_ATR_FS_VW(SQL View) |
Index Back |
|---|---|
AM/Mfg Asset Attributes View |
| SELECT Business_Unit , Asset_Id , EffDt , Asset_Color , Asset_Weight , Weight_Um , Asset_Height , Height_Um , Asset_Width , Width_Um , Asset_Length , Length_Um , Asset_Capacity , Capacity_Um , Power_Rating , Power_Rating_Um FROM PS_ASSET_ATTRIBUTE |
| # | 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 |
| 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 |