RF_ITEM_ORD_VW

(SQL View)
Index Back

Master Item Prompt View

This view returns all Items that are available to be ordered.

SELECT SETID , INV_ITEM_ID , DESCR60 , DESCRSHORT , DESCR , INV_ITEM_GROUP , INV_PROD_FAM_CD , ITM_STATUS_EFFDT , ITM_STATUS_CURRENT , UNIT_MEASURE_STD , LOT_CONTROL , SERIAL_CONTROL , SHIP_SERIAL_CNTRL , NON_OWN_FLAG , CONSIGNED_FLAG , INVENTORY_ITEM , SERVICEABLE_FLG , RETURNABLE_FLG , CONSUMABLE_FLG , HAZ_CLASS_CD , INTL_HAZARD_ID FROM PS_MASTER_ITEM_TBL WHERE ITM_STATUS_CURRENT IN ('1', '3')

  • Related Language Record: MASTER_ITM_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    7 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
    8 ITM_STATUS_EFFDT Date(10) DATE Item Status Date
    9 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    5=Pending Approval
    6=Denied Approval
    7=Under Initialization
    10 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Used to store the unit of measure for an item.
    11 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control

    Y/N Table Edit

    12 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control

    Y/N Table Edit

    13 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control

    Y/N Table Edit

    14 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o

    Y/N Table Edit

    15 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates if the item is consigned.

    Y/N Table Edit

    16 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item

    Y/N Table Edit

    17 SERVICEABLE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the item is serviceable or not.
    N=Non-serviceable
    Y=Serviceable
    18 RETURNABLE_FLG Character(1) VARCHAR2(1) NOT NULL Flag indicating if an item is returnable.
    N=Non-returnable
    Y=Returnable
    19 CONSUMABLE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if the item is consumable.
    N=Non-consumable
    Y=Consumable
    20 HAZ_CLASS_CD Character(4) VARCHAR2(4) NOT NULL Hazard Code
    21 INTL_HAZARD_ID Character(15) VARCHAR2(15) NOT NULL Intl Hazard ID