PROJ_ITEM_VW

(SQL View)
 Index Back

Project Item Master View


SELECT SETID ,INV_ITEM_ID ,DESCR ,INV_ITEM_GROUP ,INV_PROD_FAM_CD ,DATE_ADDED ,ORIG_OPRID ,APPROVAL_OPRID ,APPROVAL_DATE ,LAST_MAINT_OPRID ,LAST_DTTM_UPDATE ,CHANGE_FIELD ,INVENTORY_ITEM FROM PS_MASTER_ITEM_TBL

  • Related Language Record: PROJ_ITEM_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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PROJ_ITEM_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    5 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
    6 DATE_ADDED Date(10) DATE Date Added
    7 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    8 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
    9 APPROVAL_DATE Date(10) DATE Approval Date
    10 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    11 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 CHANGE_FIELD Character(18) VARCHAR2(18) NOT NULL Change Reason
    13 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y