| Active |
Defines if the row contains active data. Inactive means logically deleted. |
| ChangedBy |
The ID of the user who last edited this data. FK to HH.Users |
| ChangedOn |
The datetime this data was last edited |
| Counter |
The row number for multi-value metadata values |
| Createdby |
The ID of the user who first created this data. FK to HH.Users |
| CreatedOn |
The datetime this data was first created |
| DocumentId |
The ID of the document this data belongs to. |
| Locked |
True if this value is locked for editing |
| MetadataId |
The ID of the custom metadata field. FK to HH.Metadata. |
| ValueBin |
Contains the value if datatype is Binary |
| ValueBool |
Contains the value if datatype is Boolean+B5 |
| ValueDateTime |
Contains the value if datatype is DateTime |
| ValueFloat |
Contains the value if datatype is Floating point |
| ValueInt |
Contains the value if datatype is Integer |
| ValueKey |
The key to the selected value in the XML data for the MetadataType |
| ValueText |
Contains the value if datatype is Text |
| Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |