WM_ASSET_VW_LNG

(SQL View)
 Index Back

Asset View for MM

Asset View with fields required for MM.

SELECT B.BUSINESS_UNIT AS BUSINESS_UNIT_AM , B.ASSET_ID , B.LANGUAGE_CD , B.DESCR , B.DESCR_LONG FROM PS_ASSET_LANG B , PS_WM_ASSETBASE_VW A WHERE %Join(COMMON_KEYS, ASSET_LANG B, ASSET A)

  • Related Language Record for WM_ASSET_VW WM_PMASSET_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description