Description
The Lists table holds the data that is on your defined lists.
Columns
The table contains the following columns:
ListId : int, primary key, allows null: no
The unique numeric identifier of the item.
Custom1..Custom10 : varchar (max 8000 chars), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for rich editing.
DateCreated : datetime, allows null: yes, default: Current date and time
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateOpened : datetime, allows null: yes
The date and time when the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: yes, default: Current date and time
The date and time when the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Field1..Field35 : varchar (max 8000 chars), allows null: yes
Data in fields 1 through 35.
These columns correspond to fields that can be available for rich editing.
GroupId : int, allows null: yes, default: 0
The ID of the related department or project. Depends on the GroupType value.
GroupType : varchar (max 30 chars), allows null: yes
Shows the type of the group identifier (DeptId or ProjId).
ImportId : int, allows null: yes
The ID of the imported batch in which the list item was imported.
IsNewList : varchar (max 1 char), allows null: no, default: N
The column is reserved for system use only.
ListManagerId : int, allows null: yes
The ID of the related list.
ListTypeCode : varchar (max 100 chars), allows null: no
List identifier: the name of the list without spaces.
OpenedBy : int, allows null: yes
The ID of the user who created the item.
OriginalId : int, allows null: yes
The column is reserved for system use only.
UpdateUserId : int, allows null: yes
The ID of the user who last updated the item.
UserName : varchar (max 80 chars), allows null: yes
The name of the user who last updated the item, in the Last name, First name format.