ITEM_MFG_GPO

(SQL Table)
 Index Back

Item Manufacturer GPO table

Used for GPO item manufacturer price.

  • Parent record: ITEM_MFG

    • # 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: 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

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

    Prompt Table: CURRENCY_CD_TBL