ITEM_MFG_GPO_VW

(SQL View)
 Index Back

Item Manufacturer GPO View

Used for GPO item manufacturer price.

SELECT SETID ,INV_ITEM_ID ,MFG_ID ,MFG_ITM_ID ,GPO_ID ,GPO_CNTRCT_NBR ,UNIT_OF_MEASURE ,PRICE ,CURRENCY_CD FROM PS_ITEM_MFG_GPO

  • Parent record: ITEM_MFG

    • # 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: MST_ITM_VW4

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

    Prompt Table: MFG_GPO

    4 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    5 GPO_ID Character(18) VARCHAR2(18) NOT NULL GPO ID

    Prompt Table: GPO_TBL

    6 GPO_CNTRCT_NBR Character(25) VARCHAR2(25) NOT NULL GPO Contract Number

    Prompt Table: MFG_GPO_CNTR_VW

    7 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

    8 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL