RSF_TR_REA_OPP(SQL Table) |
Index Back |
---|---|
Opportunity ReassignmentTerritory reassignment for opportunities. |
# | 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 | OPPORTUNITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
6 | TO_SALES_REP | Character(15) | VARCHAR2(15) NOT NULL |
New Sales Representative
Prompt Table: RSF_ACC_TO_VW |
7 | TO_TREE | Character(18) | VARCHAR2(18) NOT NULL |
New Tree Name
Default Value: RSF_TR_REASSIGN.TO_TREE |
8 | TO_TERRITORY | Character(20) | VARCHAR2(20) NOT NULL |
New Territory
Prompt Table: RSF_TERR_NODEVW |
9 | REASSIGN_DATE | Date(10) | DATE |
Reassignment Date
Default Value: %date |
10 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
11 | SELECT_CHKBOX | Character(1) | VARCHAR2(1) NOT NULL |
This is used in action for enabling the actions
N=No Y=Yes |
12 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
13 | EST_CLOSE_DT | Date(10) | DATE | Estimated Close Date of an Opportunity |
14 | UPD_CRITERIA_OPP | Character(1) | VARCHAR2(1) NOT NULL |
Opportunity reassignments: Criteria to move or leave sales reps.
H=Hold Revenue M=Move Opportunity T=Move Revenue Default Value: M |
15 | OPPORTUNITY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Opportunity Name - User Enters this field in Mixed Case. |
16 | PCT_ALLOC | Number(3,0) | SMALLINT NOT NULL | Allocation Percentage |
17 | OPPORTUNITY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Opportunity Status. The values are XLat Values
0=Open 1=Closed - Lost 2=Closed - Won 3=Inactive |
18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
19 | 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 |
20 | REASSIGN_FROM | Character(3) | VARCHAR2(3) NOT NULL |
Reassign From
MUL=Multiple Reps SGL=Single Rep UNA=Unassigned |
21 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
22 | DATETIME_MODIFIED | DateTime(26) | TIMESTAMP | Datetime Modified |
23 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
24 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
25 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
26 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
27 | 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. |
28 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |