C360_ORDSUM1_VW (SQL View)	Index Back
Comprehensive Customer View

C360_ORDSUM1_VW

(SQL View)

Comprehensive Customer View

SELECT R.SETID ,H.SOLD_TO_CUST_ID , H.ORDER_STATUS ,COUNT(*) FROM PS_ORD_HEADER H ,PS_SET_CNTRL_REC R WHERE H.ORDER_TYPE_CD = 'SO' AND R.SETCNTRLVALUE=H.BUSINESS_UNIT AND R.RECNAME='CUSTOMER' AND R.REC_GROUP_ID='FS_23' GROUP BY R.SETID ,H.SOLD_TO_CUST_ID , H.ORDER_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

3 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled

4 COUNT_LINES Number(15,0) DECIMAL(15) NOT NULL Count of Lines

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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.
3	ORDER_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Order Status C=Closed O=Open P=Pending X=Canceled
4	COUNT_LINES	Number(15,0)	DECIMAL(15) NOT NULL	Count of Lines