RE_ASSET_VW

(SQL View)
Index Back

Asset Property View

View for Main Property Occupants

SELECT BUSINESS_UNIT , ASSET_ID , DESCR FROM PS_ASSET WHERE ASSET_TYPE = '050'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description