CS_ENTITY_C_VW (SQL View)	Index Back
Entity Table Prompt View Used to prompt for Contracts contained in the Entity Table

CS_ENTITY_C_VW

(SQL View)

Entity Table Prompt View

Used to prompt for Contracts contained in the Entity Table

SELECT DISTINCT CS_SETID , CNTRCT_ID FROM PS_PRCR_ENTITY_TBL WHERE CS_SETID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
Prompt Table: SP_SETID_NONVW

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_SETID	Character(5)	VARCHAR2(5) NOT NULL	setid for the document objects Prompt Table: SP_SETID_NONVW
2	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID