CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The META_FUNCTION table stores function information for Infor CRM functions such as change password, create Remote user database and View Settings.
Table Relationships
The META_FUNCTION table has a (Zero or One) to (Many) relationship with the META_CLASSFUNCTION table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
FUNCTIONID (PK) |
STANDARDID(12) |
NOT NULL |
META_FUNCTION_FUNCTIONID_PK (CA) |
|
FUNCTIONNAME |
varchar(64) |
NULLS |
|
|
DESCRIPTIONID |
STANDARDID(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|