PSCPQFLDRELVW

index back

Composite Query

View for Composite Query based on PSCPQFLDREL record - with no data fetched
SELECT OPRID ,CPQNAME ,CPQQRYALIAS ,SELNUM ,CPQJOINCRITERIANUM ,CPQQRYFLDNAMEPAR ,CPQQRYFLDNAMECHILD ,CONDTYPE FROM PSCPQFLDREL WHERE 1=0

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
CPQNAMECharacter(30)VARCHAR2(30) NOT NULLComposite Query
CPQQRYALIASCharacter(30)VARCHAR2(30) NOT NULLChild Query Alias
SELNUMNumber(2,0)SMALLINT NOT NULLSelect Number
CPQJOINCRITERIANUMNumber(3,0)SMALLINT NOT NULLJoin Criteria Number
CPQQRYFLDNAMEPARCharacter(30)VARCHAR2(30) NOT NULLQuery Field
CPQQRYFLDNAMECHILDCharacter(30)VARCHAR2(30) NOT NULLChild Query Field Name
CONDTYPENumber(2,0)SMALLINT NOT NULLCondition Type
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19