META_CLASSFUNCTION Table

The META_CLASSFUNCTION table stores class and function information for Infor CRM classes and functions. This information includes the captions and hints that appear for Infor CRM actions.

Table Relationships

  • CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.

  • If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index.

Legend
 

Field Datatype (Length) Allow Nulls Indexes

CLASSFUNCTIONID (PK)

STANDARDID(12)

NOT NULL

META_CLASSFUNCTION_CLASSFUNCTIONID_PK (CA)

CLASSID (FK)

STANDARDID(12)

NOT NULL

META_CLASSFUNCTION_COMPOSITE (AK)

FUNCTIONID  (FK)

STANDARDID(12)

NOT NULL

META_CLASSFUNCTION_COMPOSITE (AK)

FUNCTIONCAPTION

STANDARDID(12)

NULLS

 

FUNCTIONHINT

STANDARDID(12)

NULLS

 

DESCRIPTION

STANDARDID(12)

NULLS

 

MODIFYDATE

datetime(8)

NULLS

 

MODIFYUSER (FK)

char(12)

NULLS

 

CREATEDATE

datetime(8)

NULLS

 

CREATEUSER (FK)

char(12)

NULLS