FO_CST_GRP_SRCH

(SQL View)
 Index Back

FO Customer Group Search Recor

This Search Record is used to select Pay/Bill Records from the CUST_GROUP_TBL in the Front Office.

SELECT A.SETID , A.CUST_GRP_TYPE , A.CUSTOMER_GROUP , A.DESCR , A.GLOBAL_FLAG FROM PS_CUST_GROUP_TBL A WHERE CUST_GRP_TYPE = 'PBIL'

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

Default Value: PBIL

3 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global

Y/N Table Edit

Default Value: N