RSF_TR_REA_ACV2(SQL View) |
Index Back |
---|---|
Account Reassignment ViewTerritory reassignment for accounts. |
SELECT E.TREE_NAME , E.TERRITORY_ID , B.PERSON_ID , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , B.BO_ID , C.BO_NAME_DISPLAY , D.CUST_STATUS FROM PS_BO_REL A , PS_RD_PERSON B , PS_BO_NAME C , PS_BC D , PS_RD_ACCT_TR_INFO E WHERE A.REL_TYPE_ID = 31 AND A.BO_ID_1 = B.BO_ID AND C.BO_ID = A.BO_ID_2 AND C.PRIMARY_IND = 'Y' AND A.BO_ID_2 = D.BO_ID AND D.BO_ID = E.BO_ID AND E.ROLE_TYPE_ID = A.ROLE_TYPE_ID_2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL |
Current Tree Name
Default Value: RSF_TR_REASSIGN.TREE_NAME |
|
2 | Character(20) | VARCHAR2(20) NOT NULL | Current Territory | |
3 | Character(15) | VARCHAR2(15) NOT NULL |
Current Sales Representative
Prompt Table: RSF_ACC_FROM_VW |
|
4 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID | |
5 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID | |
6 | FROM_BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Current Sales Rep BOID |
7 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
8 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active I=Inactive |