WM_PC_DFLT_PRJ

(SQL Table)
Index Back

WO Default Project Information

This record will be used to identify Projects that are usable on a Work Order.

  • Parent Record Of WM_PC_DFLT_DTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

    Prompt Table: SP_BU_WM_NONVW

    2 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

    Prompt Table: WM_WO_TYPE

    3 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

    Prompt Table: WM_SRVC_GRP_BU

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date