UDefFieldGL Table (147)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
User group link table for UDefField, for MDO item hiding
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| UDefFieldGL_Id | Primary key | PK | |
| UDefFieldId | Link to field | FK UDefField | |
| fieldLineNo | Line number in display, 1, 2, 3… | UShort | |
| group_id | Link to Group table | FK UserGroup | |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| UDefFieldGL_Id | PK | Clustered, Unique |
| UDefFieldId | FK | Index |
| group_id | FK | Index |
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. |
| UserGroup | Secondary user groups |
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.