The PLUGIN table stores information about plugin types (forms, views, images, bitmaps, macros, menus, contact processes, report profiles, reports, SQL scripts, Visual Basic scripts, mail merge templates, and toolbars) created in Architect and used in Infor CRM. In addition, the PLUGIN table contains the plugin information for groups created in Infor CRM. (Ad hoc groups are stored in the AdHocGroup table.)
The PLUGIN table contains the plugin name (such as file name of the .ocx or the Type Library ID), family, numeric type, user creating the plugin, date created or modified, version number of the plugin, company details, read only and other attributes.
Table Relationships
The PLUGIN table has a (Zero or One) to (Zero or One) relationship with the PROJECTITEM table.
The PLUGIN table has a (Many) to (One) relationship with the USERINFO table.
The PLUGIN table has a (Zero or One) to (Many) relationship with the PLUGINATTACHMENT and PLUGINEXTS tables.
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes | Column Values |
|---|---|---|---|---|
|
PLUGINID (PK) |
STANDARDID(12) |
NOT NULL |
PLUGIN_PLUGINID_PK (AK) |
|
|
NAME |
varchar(64) |
NULLS |
PLUGIN_NAME (IE) |
|
|
FAMILY |
varchar(64) |
NULLS |
PLUGIN_FAMILY (CA) |
|
|
TYPE |
int(4) |
NULLS |
PLUGIN_TYPE (IE) |
0=Processes, 1=Sales Processes, 2=Scripts(Basic), 3=Views(Legacy), 4=Profiles(Reports), 5=Scripts(SQL), 8=Groups, 13=Macros, 14=Strips(Menu), 15=Strips(Toolbar), 18=Bitmaps, 19=Crystal Reports, 23=Groups, 25=Templates, 26=XML, 27=Active Script, 28=Forms, 29=ActiveX Control, 30=Main Views, 31=Global Scripts, 32=Stored Procedure, 33=Stored Procedure Project, 34=Text, 35=Dashboard Widgets, 36=Dashboard pages (or tabs) |
|
USERID(FK) |
STANDARDID(12) |
NULLS |
PLUGIN_USERID (IE) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
LOCKED |
BOOLEAN(1) |
NULLS |
|
|
|
LOCKEDID (FK) |
STANDARDID(12) |
NULLS |
|
|
|
DATA |
DATABLOB(16) |
NULLS |
|
|
|
VERSION |
int(4) |
NULLS |
|
|
|
SYSTEM |
BOOLEAN(1) |
NULLS |
|
|
|
ISPUBLIC |
BOOLEAN(1) |
NULLS |
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
DATACODE |
varchar(24) |
NULLS |
|
|
|
BASEDON |
STANDARDID(12) |
NULLS |
PLUGIN_BASEDON (IE) |
|
|
TEMPLATE |
varchar(64) |
NULLS |
|
|
|
AUTHOR |
varchar(50) |
NULLS |
PLUGIN_AUTHOR (IE) |
|
|
COMPANY |
varchar(50) |
NULLS |
PLUGIN_COMPANY (IE) |
|
|
COMPANYVERSION |
float(8) |
NULLS |
PLUGIN_COMPANYVERSION (IE) |
|
|
BASEDONCOMPANY |
varchar(50) |
NULLS |
|
|
|
BASEDONCOMPANYVERSION |
float(8) |
NULLS |
|
|
|
RELEASED |
char(1) |
NULLS |
|
|
|
DEV |
char(1) |
NULLS |
|
|
|
READONLY |
char(1) |
NULLS |
|
|
|
INSTALLATIONDATE |
datetime(8) |
NULLS |
|
|
|
RELEASEDDATE |
datetime(8) |
NULLS |
|
|
|
DISPLAYNAME |
varchar(128) |
NULLS |
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
|
CUSTOMFLAG |
varchar(1) |
NULLS |