TREE_NAMETERRITORY_IDPrompt Table: RSF_SUSER_A_VW
Y/N Table Edit
Default Value: N
RSF_TR_TEAMO_VW(SQL View) |
Index Back |
|---|---|
Territory Team OwnerView of the territory team owner. |
| SELECT TR.TREE_NAME ,TR.TERRITORY_ID ,TR.PERSON_ID ,TR.PRIMARY_USER , PRS.BO_NAME_DISPLAY FROM %Table(RSF_TR_TEAM) TR , %Table(RD_PERSON_NAME) PRS WHERE TR.PRIMARY_USER = 'Y' AND %EffdtCheck(RSF_TR_TEAM TR2, TR, %CurrentDateIn) AND TR.PERSON_ID = PRS.PERSON_ID AND PRS.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | TERRITORY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Territory ID |
| 3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RSF_SUSER_A_VW |
| 4 | PRIMARY_USER | Character(1) | VARCHAR2(1) NOT NULL |
Primary Sales User
Y/N Table Edit Default Value: N |
| 5 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |