PSCPQEXPR

index back

Query Expression


  • Parent record: PSCPQDEFN
  • 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
    EXPNUM Number(3,0) SMALLINT NOT NULL Expression Number
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    LENGTH Number(5,0) INTEGER NOT NULL Length
    DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
    EXPRESSIONTEXT Long Character CLOB Expression Text
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20