PROD_GROUP_VW

(SQL View)
 Index Back

Product Group Table

This record stores the valid Product Group Codes to be used for Pricing, Reporting, Accounting, Transit and more.

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.prod_price_flg , a.adjust_altcost_pct , a.adjust_altcost_flg , a.eoep_mrgbase_flg , a.datetime_added , a.lastupddttm , a.last_maint_oprid FROM PS_PROD_GROUP_TBL a

# 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 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 NOT NULL 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

Default Value: A

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

Y/N Table Edit

Default Value: N

10 PROD_PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Option
0=Regular
1=KVI
2=NDP
11 ADJUST_ALTCOST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Alternate Cost Adjust Percent
12 ADJUST_ALTCOST_FLG Character(1) VARCHAR2(1) NOT NULL Adjust Alternate cost flag indicates whether 0% adjustment is a valid value.
13 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
1=Cost
2=Alternate
14 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
15 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.
16 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID