PRFPS_GCUST_VW (SQL View)	Index Back
PastDueItem Cust List by Grp AR Financial Operation Past Due Items User Preference - Customer List selection by Customer Group

PRFPS_GCUST_VW

(SQL View)

PastDueItem Cust List by Grp

AR Financial Operation Past Due Items User Preference - Customer List selection by Customer Group

SELECT S.OPRID , C.SETID , C.CUST_ID , S.CUST_GRP_TYPE , S.CUSTOMER_GROUP FROM PS_CUST_CGRP_LNK C , PS_ARFO_PRFPST_CGR S WHERE S.SETID = C.SETID AND S.CUST_GRP_TYPE = C.CUST_GRP_TYPE AND S.CUSTOMER_GROUP = C.CUSTOMER_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

4 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

5 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4	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
5	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group