RSF_SALES_TSK_V

(SQL View)
 Index Back

Sales Model Task Table

Table that contains the various Sales Models with associated Stages for each model and Tasks/Steps for each Stage.

SELECT SETID , SALES_MODEL , SALES_STAGE , SALES_TASK , SEQNUMTASK , REQUIRED_FLAG , DESCR50 , DESCR60 FROM PS_RSF_SALES_TASK WHERE Status = 'A'

  • Related Language Record: RSF_SLS_TSK_LNG

    • # 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 SALES_MODEL Character(18) VARCHAR2(18) NOT NULL Sales Model Id

    Default Value: RSF_SALES_STAGE.SALES_MODEL

    3 SALES_STAGE Character(24) VARCHAR2(24) NOT NULL Sales Stage Identifier

    Default Value: RSF_SALES_STAGE.SALES_STAGE

    4 SALES_TASK Character(24) VARCHAR2(24) NOT NULL Sales Stage Task Identifier
    5 SEQNUMTASK Number(3,0) SMALLINT NOT NULL Sequence Number to keep track of the task number from the sales model, stage.
    6 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required
    N=No
    Y=Yes
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description