WM_WO_MFGMOD_VW

(SQL View)
 Index Back

WO Tmplt Mfg-Model View

Work Order Template Manufacturer-Model view -- view on MFG_MODEL table; e.g., used as prompt table on WO Task/Job Template setup Note: used to establish connection between MFG_MODEL.MFG_ID and MANUFACTURER description field

SELECT SETID , MFG_ID , MODEL , DESCR FROM PS_MFG_MODEL

  • Related Language Record: WM_WO_MFGMD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    3 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description