PROD_ATT_SRCH

(SQL View)
 Index Back

Products with Attachments


SELECT A.SETID ,A.PRODUCT_ID ,A.DESCR ,A.DESCR254 ,A.MODEL_NBR ,A.CATALOG_NBR ,A.PRODUCT_KIT_FLAG ,A.EFF_STATUS ,A.INV_ITEM_ID FROM PS_PROD_ITEM A , PS_PROD_ATT B WHERE A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID

  • Related Language Record: PROD_ITEM_LNG

    • # 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.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model number field to store model number value.
    6 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
    7 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit Flag

    Y/N Table Edit

    Default Value: N

    8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PROD_STOCK_VW