PV_EXP_FORMS_VW

(SQL View)
 Index Back

PV Merchants

This view identifies merchants that apply to PV.

SELECT A.PV_EASYFORM_TYPE , A.EFFDT , A.DESCR , A.INSTALLED_SW , A.IMAGE_NAME , A.MENUNAME , A.BARNAME , A.ITEMNAME , A.PANELNAME , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.CATEGORY_ID , A.UNIT_OF_MEASURE , A.CURRENCY_CD , A.PV_KEYWORDS , A.DESCR254_MIXED , A.PV_ACTION , A.PRICE_SDF , A.QTY_SDF , A.MSGSET , A.MSGNUM ,a.edit_qty ,a.edit_price ,A.FORM_TYPE_STATUS ,a.PV_MENUNAME_INQ ,a.PV_itemNAME_INQ ,a.PV_panelNAME_INQ FROM PS_PV_EXT_PROFILE A WHERE A.INSTALLED_SW = 'Y' AND A.FORM_TYPE_STATUS NOT IN ('F', 'E') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PV_EXT_PROFILE B WHERE A.PV_EASYFORM_TYPE = B.PV_EASYFORM_TYPE AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: PV_EXT_PR_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PV_EASYFORM_TYPE Character(10) VARCHAR2(10) NOT NULL Easyform Type
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INSTALLED_SW Character(1) VARCHAR2(1) NOT NULL Installed?
    5 IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.
    6 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    7 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: PSMENUBAR_VW

    8 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: PSMENUITEM

    9 PANELNAME Character(18) VARCHAR2(18) NOT NULL Panelname

    Prompt Table: PSPNLGROUP_VW

    10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SETID_TBL

    11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR
    Set Control Field: VENDOR_SETID

    12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    13 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

    Prompt Table: PV_CAT_SETID_VW
    Set Control Field: SETID

    14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    16 PV_KEYWORDS Character(254) VARCHAR2(254) NOT NULL Search Keywords
    17 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    18 PV_ACTION Character(60) VARCHAR2(60) NOT NULL Action Name
    19 PRICE_SDF Character(254) VARCHAR2(254) NOT NULL Unit Price
    20 QTY_SDF Character(254) VARCHAR2(254) NOT NULL Quantity
    21 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
    22 MSGNUM Number(5,0) INTEGER NOT NULL Message Number
    23 EDIT_QTY Character(1) VARCHAR2(1) NOT NULL Editable
    N=UnChecked
    Y=Checked
    24 EDIT_PRICE Character(1) VARCHAR2(1) NOT NULL Editable
    N=UnChecked
    Y=Checked
    25 FORM_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Application Designer Form
    D=In Design
    E=Edit Fluid Requisition Form
    F=Fluid Supplemental Data Form
    I=Inactivated
    S=Supplemental Data Form
    26 PV_MENUNAME_INQ Character(30) VARCHAR2(30) NOT NULL Menu Name
    27 PV_ITEMNAME_INQ Character(30) VARCHAR2(30) NOT NULL Item Name
    28 PV_PANELNAME_INQ Character(18) VARCHAR2(18) NOT NULL Inquiry Page Name