PSCPQFIELD

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
    QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field
    COLUMNNUMNumber(3,0)SMALLINT NOT NULLColumn Number
    ORDERBYNUMNumber(3,0)SMALLINT NOT NULLOrder-By Number
    ORDERBYDIRCharacter(1)VARCHAR2(1) NOT NULLOrder-By Direction
    A=Ascending
    D=Descending
    GROUPBYNUMNumber(3,0)SMALLINT NOT NULLGroup-By Number
    CPQAGGREGATETYPENumber(1,0)SMALLINT NOT NULLAggregate Type
    FLDEXPNUMNumber(3,0)SMALLINT NOT NULLField Expression Number
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19