AccountManagerID, RegionalManagerID, DivisionalManagerID, CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Added in Version 6.0
The REALIGNPROFILE table stores information created for territory realignment using the Administrator (Tools > Realign Territories).
Table relationships
The REALIGNPROFILE table has a (Many) to (Zero or One) relationship with the USERINFO table.
|
|
AccountManagerID, RegionalManagerID, DivisionalManagerID, CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
PROFILEID (FK) |
char(12) |
NOT NULL |
REALIGNPROFILE_PRIMARY (AK) |
|
PROFILENAME |
varchar(64) |
NULLS |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
REALIGNTYPE |
int |
NULLS |
|
|
OLDOWNERID |
char(12) |
NULLS |
|
|
OLDUSERID |
char(12) |
NULLS |
|
|
OLDNAME |
varchar(64) |
NULLS |
|
|
OWNERID |
char(12) |
NULLS |
|
|
USERID (FK) |
char(12) |
NULLS |
|
|
ACCOUNTMANAGERID (FK) |
char(12) |
NULLS |
|
|
REGIONALMANAGERID (FK) |
char(12) |
NULLS |
|
|
DIVISIONMANAGERID (FK) |
char(12) |
NULLS |
|
|
PRIVATEACCOUNTS |
char(1) |
NULLS |
|
|
ACTIVITIES |
char(1) |
NULLS |
|
|
PROCESSES |
char(1) |
NULLS |
|
|
REALIGNTYPEID |
char(12) |
NULLS |
|
|
REALIGNTYPETEXT |
varchar(64) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER |
char(12) |
NULLS |
|