AM_EPL_MASTR

(SQL Table)
 Index Back

Equipment Parts List - master

  • Parent Record Of EPL_LOOKUP_VW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template
    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: MANUFACTURER

    8 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL_VW2

    9 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version