PROD_GROUP_EFVW

(SQL View)
 Index Back

Product Group Eff

Used in PRODUCT_GROUP_FULLSYNC_EFF full table publish rules.

SELECT a.setid , a.prod_grp_type , a.product_group , a.effdt , a.descr , a.eff_status , a.web_oe_prod_cat , a.descrshort , a.global_flag , a.datetime_added , a.lastupddttm , a.last_maint_oprid FROM PS_PROD_GROUP_TBL a WHERE %EffdtCheck(prod_group_tbl Y, a, %CurrentDateIn)

  • Related Language Record: PROD_GROUP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PROD_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Product Group Type
    ACCT=Accounting
    BO=Backorder/Reservations
    CA=Contract
    CLMB=Claimback Contract
    CTLG=Product Catalogs
    FCST=Forecast
    FRT=Freight
    PRC=Pricing
    RPT=Reporting
    SCON=Buying Agreement
    SSRC=Alternate Sources of Supply
    TAX=Tax
    TRPT=Transportations
    VAT=VAT
    WEB=WEB Order Entry
    3 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 WEB_OE_PROD_CAT Character(4) VARCHAR2(4) NOT NULL This field will contain all the WEB Categories to be used by the OM WEB application.
    COMP=Computer
    HARD=Hardware
    OTHR=Other
    SOFT=Software
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global
    10 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID