SEC_FUNCTIONOWNER Table

The SEC_FUNCTIONOWNER table stores security information for Infor CRM classes and functions.

Table Relationships

The SEC_FUNCTIONOWNER table has a (One) to (Many) relationship with the META_CLASSFUNCTION table.

  • OwnerID is a foreign key referencing SeccodeID in the SECCODE table.

  • 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

FUNCTIONOWNERID (PK)

STANDARDID(12)

 NOT NULL

SEC_FUNCTIONOWNER_FUNCTIONOWNERID_PK (CA)

OWNERID (FK)

STANDARDID(12)

 NOT NULL

SEC_FUNCTIONOWNER_COMP (AK)

CLASSFUNCTIONID(FK)

STANDARDID(12)

 NOT NULL

SEC_FUNCTIONOWNER-COMP (AK)

MODIFYDATE

datetime(8)

NULLS

 

MODIFYUSER (FK)

char(12)

NULLS

 

CREATEDATE

datetime(8)

NULLS

 

CREATEUSER (FK)

char(12)

NULLS