PSCPQCRITERIA

index back

Composite Query

Composite Query - CPQDM managed object

  • Parent record: PSCPQSELECT
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
    SELNUM Number(2,0) SMALLINT NOT NULL Select Number
    CRTNUM Number(3,0) SMALLINT NOT NULL Criteria Number
    COMBTYPE Number(1,0) SMALLINT NOT NULL Combination Type
    NEGATION Character(1) VARCHAR2(1) NOT NULL Negation
    LPARENLVL Number(2,0) SMALLINT NOT NULL Left Paren Level
    RPARENLVL Number(2,0) SMALLINT NOT NULL Right Paren Level
    CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
    QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
    CONDTYPE Number(2,0) SMALLINT NOT NULL Condition Type
    EXPRTYPE Number(2,0) SMALLINT NOT NULL Expression Type
    CPQR1CRTQRYALIAS Character(30) VARCHAR2(30) NOT NULL Query Alias
    CPQR1CRTFLDNAME Character(30) VARCHAR2(30) NOT NULL Query Field
    CPQR1CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right1 Criteria Expression No.
    CPQR2CRTQRYALIAS Character(30) VARCHAR2(30) NOT NULL Query Alias
    CPQR2CRTFLDNAME Character(30) VARCHAR2(30) NOT NULL Query Field
    CPQR2CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right1 Criteria Expression No.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19