• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

UDefFieldGL Table (147)

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

UDefFieldGL table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top