RSF_TR_REACCTLN(SQL Table) |
Index Back |
|---|---|
Related Language Record - ARWTerritory reassignment for accounts. |
| # | 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
Prompt Table: BO_NAME_PRIM_VW |
| 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
Prompt Table: RB_ACCT_CONT_VW |
| 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 14 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |