UDListDefinition table - SuperOffice

UDListDefinition Table (139)

List table that contains the list of user-defined lists, as well as system-defined lists. The list items are stored in the UDList table.

Fields

Name	Description	Type	Nullable
UDListDefinition_id	Primary key	PK	No
name	The list item	String(239)	No
rank	Rank order	UShort	Yes
tooltip	Tooltip or other description	String(254)	Yes
deleted	0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists	UShort	Yes
listTableId	The table ID of the list table that this record contains the name of	TableNumber	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
requiredLicense	Licenses the user/installation must have if this reference is to be shown. Comma-separated list of owner.module pairs	String(254)	Yes

UDListDefinition table relationship diagram

Indexes

Fields	Types	Description
name	String(239)	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
UDefField	Definition table for user-defined fields; one row in this table corresponds to one generation of one field. The user defined fields that are in use, and earlier versions of user defined fields. ColumnId refers to the field type; see UDXXXSmall or UDXXXLarge for the referring ID. Preferences prefsection=‘System’, prefkey=‘CurrentUdefVersioncontact’ (or CurrentUdefVersionperson, project, sale), gives you the current version of user defined fields. prefkey=‘AdminUdefVersion<…>’ gives you the current version that’s being edited. If Current version = admin version, no editing has been done since the last Publish of user defined field was performed.
UDList	List table for user-defined lists, contains all user-defined lists. Note - MDO mode for userdefinede lists are either turned on or off, you may not have it on for one userdefined list and off for the others.

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

List events udlist28 UDList table How to create a user-defined field using the web services API Get List Id By List Name NSMDOAgent

⌘I