PSCPQFIELD

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
    QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
    COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number
    ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number
    ORDERBYDIR Character(1) VARCHAR2(1) NOT NULL Order-By Direction
    A=Ascending
    D=Descending
    GROUPBYNUM Number(3,0) SMALLINT NOT NULL Group-By Number
    CPQAGGREGATETYPE Number(1,0) SMALLINT NOT NULL Aggregate Type
    FLDEXPNUM Number(3,0) SMALLINT NOT NULL Field Expression Number
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19