RSF_OPP_SLSR_VW

(SQL View)
 Index Back

Opportunity Sales Rep details

This tables contains all the Sales Reps working on a particular opportunity

SELECT OPPORTUNITY_ID , SALES_USER_NAME , PERSON_ID , BO_ID_PERSON , SALES_USER_TYPE , TERRITORY_ID , PRIMARY_FLG , ROLE_CD , PCT_ALLOC , SHADOW_AMT , SHADOW_PCT , DESCR254 FROM PS_RSF_OPP_SLSREP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

Prompt Table: RSF_OPPORTUNITY

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

Prompt Table: RSF_SUSER_A_VW

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RSF_SUSER_A_VW

4 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID
5 SALES_USER_TYPE Character(4) VARCHAR2(4) NOT NULL Sales User Type
ADMN=Sales Administrator
EXEC=Executive Sales Manager
FLDR=Field Sales Rep
INSR=Inside Sales Rep
PREP=Partner Contact
PRES=Pre-Sales Consultant
SMGR=Sales Manager
TECH=Sales Tech Support
TELR=Telesales Rep
6 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
7 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag which takes yes or no values and indicates whether the row is primary.
N=No
Y=Yes
8 ROLE_CD Character(4) VARCHAR2(4) NOT NULL Sales User Role Code
0001=Manager
0002=Administrator
0003=Consultant
0004=Legal
0005=Other
0006=Liaison
0007=Partner
0007=Partner
0008=Sales Rep
0009=Team Leader
0010=Technical Sales
0011=Technical
0012=Training
9 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
10 SHADOW_AMT Number(27,3) DECIMAL(26,3) NOT NULL An amount for a 'shadow' forecast.
11 SHADOW_PCT Number(6,2) DECIMAL(5,2) NOT NULL Shadow Amount Percent
12 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254