RSF_TR_PTEAM_VW(SQL View) |
Index Back |
|---|---|
Partner teamCRM Sales - View of all Partner users. |
| SELECT A.TREE_NAME ,A.TERRITORY_ID ,A.BO_ID_PARTNER ,B.PERSON_ID ,B.PRIMARY_USER FROM PS_RSF_TR_PTNR_VW A , PS_RSF_TR_TEAM B WHERE A.TREE_NAME = B.TREE_NAME AND A.TERRITORY_ID = B.TERRITORY_ID |
| # | 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 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 4 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RSF_SUSER_A_VW |
| 5 | PRIMARY_USER | Character(1) | VARCHAR2(1) NOT NULL |
Primary Sales User
Y/N Table Edit Default Value: N |