PICKLIST Table

The PICKLIST table stores standard or custom pick lists created in Infor CRM. Pick lists contain values you can select from when entering data in a field. This table has a one-to-many association within itself as it stores not only a pick list definition (PICKLISTID), but also the entries (ITEMID) for a pick list definition.

If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic.  For more information, see the Index Changes.pdf document.

 

  • 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

ID

int(4)

NOT NULL

 

TEXT

varchar(64)

NULLS

PICKLIST_TEXT(IE)

SHORTTEXT

varchar(64)

NULLS

 

ITEMID

STANDARDID(12)

NULLS

PICKLIST_COMPOSITE (IE)

PICKLISTID

STANDARDID(12)

NULLS

PICKLIST_COMPOSITE (IE)

USERID(FK)

STANDARDID(12)

NULLS

 

DEFAULTINDEX

int(4)

NULLS

 

MODIFYDATE

datetime(8)

NULLS

 

MODIFYUSER (FK)

char(12)

NULLS

 

CREATEDATE

datetime(8)

NULLS

 

CREATEUSER (FK)

char(12)

NULLS

 
FILTER varchar(256) NULLS  
LANGUAGECODE varchar(6) NULLS  
DEFAULTCODE nvarchar(64) NULLS