RSF_TR_REOLD_LN(SQL Table) |
Index Back |
|---|---|
Related Language - Reorg LeadsLead reorganization detail worksheet. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  REORG_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Reorganization ID
Default Value: RSF_TR_REORG.REORG_ID |
| 2 | FROM_TREE |
Character(18) | VARCHAR2(18) NOT NULL |
Current Tree Name
Default Value: RSF_TR_REORG.FROM_TREE |
| 3 | FROM_TERRITORY |
Character(20) | VARCHAR2(20) NOT NULL |
Current Territory
Prompt Table: RSF_TERR_NODEVW |
| 4 | FROM_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL |
Current Sales Representative
Prompt Table: RSF_ACC_FROMVW1 |
| 5 | LEAD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
| 6 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Default Value: RSF_TR_REORG.TO_TREE |
| 7 | TO_SALES_REP |
Character(15) | VARCHAR2(15) NOT NULL |
New Sales Representative
Prompt Table: RSF_ACC_TOREPVW |
| 8 | TO_TERRITORY |
Character(20) | VARCHAR2(20) NOT NULL |
New Territory
Prompt Table: RSF_TER_NOD_VW |
| 9 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 10 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |