RSF_TR_REA_OPP

(SQL Table)
Index Back

Opportunity Reassignment

Territory reassignment for opportunities.

  • Related Language Record: RSF_TR_REOPP_LN
  • # 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