PSCPQFLDREL

 index back

Composite Query

Composite Query CPQDM

  • Parent record: PSCPQMAP

    • 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
    CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
    CPQJOINCRITERIANUM Number(3,0) SMALLINT NOT NULL Join Criteria Number
    CPQQRYFLDNAMEPAR Character(30) VARCHAR2(30) NOT NULL Query Field
    CPQQRYFLDNAMECHILD Character(30) VARCHAR2(30) NOT NULL Child Query Field Name
    CONDTYPE Number(2,0) SMALLINT NOT NULL Condition Type
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20