SCP_RCPOSHP_VW2 (SQL View)	Index Back
Supplier User Supplier User

SCP_RCPOSHP_VW2

(SQL View)

Supplier User

SELECT VENDOR_SETID ,VENDOR_ID ,GROUP_NAME ,COUNT(PO_ID) FROM PS_SCP_RCPOSHP_VW1 WHERE DUE_DT < %CurrentDateIn AND (%CurrentDateIn - %DatePart(DATETIME_DISP) ) >=0 AND (%CurrentDateIn - %DatePart(DATETIME_DISP) ) <=90 GROUP BY VENDOR_SETID ,vendor_id ,GROUP_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Group Name

4 COUNT1 Number(10,0) DECIMAL(10) NOT NULL Counter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	GROUP_NAME	Character(30)	VARCHAR2(30) NOT NULL	Group Name
4	COUNT1	Number(10,0)	DECIMAL(10) NOT NULL	Counter