RSF_CRIT_OBJ_VW

(SQL View)
 Index Back

Criteria Objects

This table is created to store criteria objects for sales

SELECT A.SETID , A.MARKET , A.ASSIGN_GROUP , A.CONFIG_CRITERIA_CD , A.CRITERIA_RECORD , A.CRITERIA_FIELDNAME , A.CRIT_DESCR_FIELD , A.CRITERIA_TYPE , A.CRIT_DESCR FROM PS_RSF_ASSIGN_CRIT A WHERE A.ASSIGN_WEIGHT > 0

  • Related Language Record: RSF_ASGN_CRIT_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    3 ASSIGN_GROUP Character(30) VARCHAR2(30) NOT NULL This field is used to specify assignment group name for Territory assignment.
    4 CONFIG_CRITERIA_CD Character(10) VARCHAR2(10) NOT NULL Configurable Criteria Code
    5 CRITERIA_RECORD Character(18) VARCHAR2(18) NOT NULL Criteria Record for Configurable Assignment

    Prompt Table: RSF_CRIT_REC_VW

    6 CRITERIA_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Key Field

    Prompt Table: RSF_CRIT_FLD_VW

    7 CRIT_DESCR_FIELD Character(18) VARCHAR2(18) NOT NULL Description Field

    Prompt Table: RSF_CRIT_FDS_VW

    8 CRITERIA_TYPE Character(1) VARCHAR2(1) NOT NULL Criteria Type
    R=Range
    S=Single

    Default Value: S

    9 CRIT_DESCR Character(30) VARCHAR2(30) NOT NULL Criteria Description