PSCPQFLDREL

index back

Composite Query

Composite Query CPQDM

  • Parent record: PSCPQMAP
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    CPQNAMECharacter(30)VARCHAR2(30) NOT NULLComposite Query
    SELNUMNumber(2,0)SMALLINT NOT NULLSelect Number
    CPQQRYALIASCharacter(30)VARCHAR2(30) NOT NULLChild Query Alias
    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