FROM_TREEFROM_TERRITORYFROM_SALES_REPOPPORTUNITY_IDRSF_TR_OPPREPVW(SQL View) |
Index Back |
|---|---|
Territory - Reps & Opps. View |
| SELECT A.TREE_NAME ,A.TERRITORY_ID ,A.PERSON_ID ,A.OPPORTUNITY_ID ,B.OPPORTUNITY_NAME ,B.NAME1 ,B.EST_CLOSE_DT ,A.PCT_ALLOC FROM PS_RSF_OPP_SLSREP A , PS_RSF_OPPORTUNITY B WHERE A.OPPORTUNITY_ID = B.OPPORTUNITY_ID AND B.OPPORTUNITY_STATUS = '0' AND A.PERSON_ID = B.PERSON_ID AND A.PRIMARY_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FROM_TREE |
Character(18) | VARCHAR2(18) NOT NULL | Current Tree Name |
| 2 | FROM_TERRITORY |
Character(20) | VARCHAR2(20) NOT NULL | Current Territory |
| 3 | FROM_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL | Current Sales Representative |
| 4 | OPPORTUNITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
| 5 | OPPORTUNITY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Opportunity Name - User Enters this field in Mixed Case. |
| 6 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 7 | EST_CLOSE_DT | Date(10) | DATE | Estimated Close Date of an Opportunity |
| 8 | PCT_ALLOC | Number(3,0) | SMALLINT NOT NULL | Allocation Percentage |