CUST_GROUP_VW

(SQL View)
Index Back

Customer Groups

Prompt Table

SELECT G.SETID , G.CUST_GRP_TYPE , G.CUSTOMER_GROUP FROM PS_CUST_GROUP_TBL G WHERE %EffdtCheck(CUST_GROUP_TBL, G, %CurrentDateIn) AND G.EFF_STATUS = '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

2 CUST_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation
3 CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group