RSF_TR_OP_TEAMV (SQL View)	Index Back
Opportunity Sales Team View Used in territory reorg to show current Sales reps working on a particular opportunity.

RSF_TR_OP_TEAMV

(SQL View)

Opportunity Sales Team View

Used in territory reorg to show current Sales reps working on a particular opportunity.

SELECT OPPORTUNITY_ID ,PERSON_ID ,SALES_USER_NAME ,TREE_NAME ,TERRITORY_ID ,PRIMARY_FLG 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RSF_SUSER_A_VW

3 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
Prompt Table: RSF_SUSER_A_VW

4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: RSF_TEAMTREE_VW

5 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
Prompt Table: RSF_TER_NODE_VW

6 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

#	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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RSF_SUSER_A_VW
3	SALES_USER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name field Prompt Table: RSF_SUSER_A_VW
4	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: RSF_TEAMTREE_VW
5	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID Prompt Table: RSF_TER_NODE_VW
6	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