FROM_TREEFROM_TERRITORYPERSON_ID_MANAGERFROM_SALES_REPA=Active
I=Inactive
N=No
Y=Yes
RSF_TR_REO_A_VW(SQL View) |
Index Back |
|---|---|
Territory Reorg - AccountsTerritory Reorg - Account by Manager |
| SELECT C.TREE_NAME , A.FROM_TERRITORY , C.PERSON_ID_MANAGER , A.FROM_SALES_REP , A.FROM_BO_ID , A.BO_ID , A.ROLE_TYPE_ID , A.REL_TYPE_ID , A.BO_REL_ID , A.TO_BO_ID , A.BO_NAME_DISPLAY , C.BO_NAME_DISPLAY , A.CUST_STATUS , A.ACCT_OWNER FROM PS_RSF_TR_ACCT_VW A , PS_RSF_ACC_FROM_VW C WHERE A.FROM_SALES_REP = C.FROM_USER |
| # | 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 | PERSON_ID_MANAGER |
Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 4 | FROM_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL | Current Sales Representative |
| 5 | FROM_BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Current Sales Rep BOID |
| 6 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 7 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 8 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 9 | BO_REL_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
| 10 | TO_BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | New Sales Rep BOID |
| 11 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 12 | BO_NAME_DISPLAY_1 | Character(80) | VARCHAR2(80) NOT NULL | This field represents the Display Name for a business object |
| 13 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active I=Inactive |
| 14 | ACCT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Account Team Owners....................
N=No Y=Yes |