RBW_AST_TYP1_VW

(SQL View)
 Index Back

View to display Asset Type1

This view is used for displaying all asset type1

SELECT ASSET_CAT_TYPE ,ASSET_CAT_DESCR FROM PS_RBW_CAT_DEF_TBL WHERE AST_CAT_LEVEL = '1'

  • Related Language Record: RBW_AST_TYP1_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ASSET_TYPE1 Character(4) VARCHAR2(4) NOT NULL This is the asset type1 of the asset category table.
    2 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description