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 | Character(15) | VARCHAR2(15) NOT NULL |
Reassignment ID
Default Value: RSF_TR_REASSIGN.REASSIGN_ID |
|
2 | Character(18) | VARCHAR2(18) NOT NULL |
Current Tree Name
Default Value: RSF_TR_REASSIGN.TREE_NAME |
|
3 | Character(20) | VARCHAR2(20) NOT NULL | Current Territory | |
4 | Character(15) | VARCHAR2(15) NOT NULL |
Current Sales Representative
Prompt Table: RSF_ACC_FROM_VW |
|
5 | Signed Number(32,0) | DECIMAL(31) NOT NULL |
Current Sales Rep BOID
Prompt Table: BO_NAME_PRIM_VW |
|
6 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID | |
7 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID | |
8 | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID | |
9 | Character(15) | VARCHAR2(15) NOT NULL |
New Sales Representative
Prompt Table: RSF_ACC_TO_VW |
|
10 | Signed Number(32,0) | DECIMAL(31) NOT NULL |
New Sales Rep BOID
Prompt Table: RB_ACCT_CONT_VW |
|
11 | Character(18) | VARCHAR2(18) NOT NULL |
New Tree Name
Default Value: RSF_TR_REASSIGN.TO_TREE |
|
12 | Character(20) | VARCHAR2(20) NOT NULL |
New Territory
Prompt Table: RSF_TERR_NODEVW |
|
13 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
14 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |