RSF_TR_REA_ACVW(SQL View) |
Index Back |
|---|---|
Account Reassignment ViewTerritory reassignment for accounts. |
| SELECT ' ' , ' ' , ' ' , B.PERSON_ID , B.BO_ID , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , A.REL_TYPE_ID , B.PERSON_ID , B.BO_ID , ' ' , ' ' , A.START_DT , A.START_DT , 'Y' , C.BO_NAME_DISPLAY , 'M' , D.CUST_STATUS , ' ' , 'N' , %subrec(RB_AUDIT_SBR, B) FROM PS_RD_PERSON B ,PS_BO_REL A ,PS_BO_NAME C ,PS_BC D WHERE A.ROLE_TYPE_ID_1 = 17 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 %CurrentDateIn >= A.START_DT AND %CurrentDateIn < A.END_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  REASSIGN_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Reassignment ID
Default Value: RSF_TR_REASSIGN.REASSIGN_ID |
| 2 | FROM_TREE |
Character(18) | VARCHAR2(18) NOT NULL |
Current Tree Name
Default Value: RSF_TR_REASSIGN.TREE_NAME |
| 3 | FROM_TERRITORY |
Character(20) | VARCHAR2(20) NOT NULL | Current Territory |
| 4 | FROM_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL |
Current Sales Representative
Prompt Table: RSF_ACC_FROM_VW |
| 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 | TO_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL |
New Sales Representative
Prompt Table: RSF_ACC_TO_VW |
| 10 | TO_BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | New Sales Rep BOID |
| 11 | TO_TREE |
Character(18) | VARCHAR2(18) NOT NULL |
New Tree Name
Default Value: RSF_TR_REASSIGN.TO_TREE |
| 12 | TO_TERRITORY |
Character(20) | VARCHAR2(20) NOT NULL |
New Territory
Prompt Table: RSF_TERR_NODEVW |
| 13 | REASSIGN_DATE | Date(10) | DATE |
Reassignment Date
Default Value: %date |
| 14 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
| 15 | SELECT_CHKBOX | Character(1) | VARCHAR2(1) NOT NULL |
This is used in action for enabling the actions
N=No Y=Yes |
| 16 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 17 | UPD_CRITERIA_ACCT | Character(1) | VARCHAR2(1) NOT NULL |
Account reassignments options.
M=Move Account |
| 18 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active I=Inactive |
| 19 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 20 | REAS_DTL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reassignment Detail Status, N is New, P is Process, E is Error and S is Skipped
E=Error N=New P=Processed S=Skipped Default Value: N |
| 21 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 22 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 23 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 24 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 25 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 26 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |