SETIDSALES_MODELA=Active
I=Inactive
Default Value: A
N=Not Used
S=Stage Level
T=Task Level
W=Stage Weight %
Default Value: N
RSF_SLSMDL_A_VW(SQL View) |
Index Back |
|---|---|
Sales Model Active VwView that contains the various Active Sales Models with their description |
| SELECT SETID , SALES_MODEL , STATUS , INDUSTRY_ID , SIC_CODE , DESCR , CLOSE_PCT_METHOD FROM PS_RSF_SALES_MODEL WHERE STATUS = 'A' |
| # | 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 |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | INDUSTRY_ID | Character(30) | VARCHAR2(30) NOT NULL | Industry ID. |
| 5 | SIC_CODE | Character(10) | VARCHAR2(10) NOT NULL | Standard Industry Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | CLOSE_PCT_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Stage % Close method
N=Not Used S=Stage Level T=Task Level W=Stage Weight % Default Value: N |