The AdHocGroup table stores the definitions for ad hoc groups that are created in Infor CRM. Ad hoc groups are randomly selected groups of accounts, contacts, or opportunities that do not meet any specific condition. Other groups are stored in the Plugin table.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
GROUPID |
STANDARDID |
NULLS |
ADHOCGROUPID (IE) |
(One) to (Many) |
|
|
ENTITYID (FK) |
STANDARDID |
NULLS |
ADHOCGROUP_ENTITYID (CA) |
(Many) to (One) |
Holds ID of any entity type for which you want to generate an ad hoc group. For example, ACCOUNT.ACCOUNTID. |
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |