PI_SN_LANG_VW

(SQL View)
 Index Back

Physical Inventory Serial ID

MPI - Related Language View of Serial IDs in the Asset Repository.

SELECT B.BUSINESS_UNIT , B.SERIAL_ID , A.LANGUAGE_CD , B.TAG_NUMBER , B.ASSET_ID , A.DESCR FROM PS_ASSET_LANG A , PS_ASSET B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND B.SERIAL_ID <> ' '

  • Related Language Record for PI_SERIAL_ID_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description