This table contains a history of the field values. It is populated if is selected in the XBOUND field definitions (if any) and in the document type to which the fields belong.
Column | Data type | Max. length (bytes) | Allow nulls | Description |
ID | bigint | 8 | False | Unique Identifier of the field history. |
SiteId | int | 4 | False | Currently not used. |
Rev | bigint | 8 | False | Revision number. For internal use. |
Acl | varbinary(max) | max | False | For internal use only. |
MAcl | varbinary(max) | max | False | For internal use only. |
StepID | bigint | 8 | False | The ID of the step (ID in W_Step). |
StepSiteId | int | 4 | False | Currently not used. |
FieldID | bigint | 8 | False | The ID of the field (ID in W_Field). |
FieldSiteId | int | 4 | False | Currently not used. |
Name | nvarchar(255) | 510 | False | The name of the field. |
Type | int | 4 | False | The field type. Possible values: 0 = group |
VarcharValue | nvarchar(255) | 510 | False | Field value when Type=1 (string). |
IntValue | int | 4 | False | Field value when Type=2 (integer). |
FloatValue | float | 8 | False | Field value when Type=3 (float). |
DatetimeValue | datetime | 8 | False | Field value when Type=4 (datetime). |
ValidID | int | 4 | False | The ID of the validation status (ID in C_Status). |
BinaryValue | varbinary(max) | max | False | The value of VarcharValue in binary form. Only filled in when VarcharValue > 255. |
BatchID | bigint | 8 | False | The ID of the root document (BatchID in W_Document). |
BatchSiteId | int | 4 | False | Currently not used. |
DeletedAt | datetime | 8 | True | The date when the data set was deleted from the XBOUND database (main database). Available in XBOUND 3.8 and later. |
Name | Columns |
FK_W_FieldHistory_W_Step | StepID -> W_Step.ID StepSiteId -> W_Step.SiteId |