This table contains a history of the document. Each change to the document is saved. For example you can trace changes to the document type.
This table is populated if both of the following are true:
The option is selected in the XBOUND document type.
The statistics database settings in the Data Manager include and .
Column | Data type | Max. length (bytes) | Allow nulls | Description |
ID | bigint | 8 | False | Unique identifier. |
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 related step (ID in W_Step). |
StepSiteId | int | 4 | False | Currently not used. |
DocumentID | bigint | 8 | False | The ID of the related Document (ID in W_Document). |
DocumentSiteId | int | 4 | False | Currently not used. |
Name | nvarchar(255) | 510 | False | The name of the document. |
TypeID | int | 4 | False | The ID of the related document type (ID in C_DocType). |
ValidID | int | 4 | False | 0 = not set 1 = valid 2 = invalid 3 = fatal error |
SheetCount | int | 4 | False | Number of sheets in this document and process step. |
PageCount | int | 4 | False | Number of pages in this document and process step. |
ImageCount | int | 4 | False | Number of images in this document and process step. |
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_DocHistory_W_Step | StepID -> W_Step.ID StepSiteId -> W_Step.SiteId |