Table: W_Document

ID

bigint

8

False

Unique identifier of the document.

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.

ProcessID

int

4

False

The ID of the related process (ID in C_Process)

ParentID

bigint

8

False

The ID of the parent document (root document). Empty when this is a root document, filled in for sub-documents.

ParentSiteId

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

The ID of the validation status (ID in C_Status). 

ErrorID

int

4

False

The ID of the error status (ID in C_Status).

SessionID

bigint

8

False

Unique identifier of the session that checked out the document. From the W_Session table. Internal.

SessionSiteId

int

4

False

Currently not used.

Item

int

4

False

The sequence number of the document.

Description

nvarchar(255)

510

False

The (optional) description of the document.

Identifier

nvarchar(255)

510

False

The unique identifier of the document.

Deleted

int

4

False

Whether the document is canceled (Deleted in W_Document).

Info

nvarchar(255)

510

False

Optional information about the document.

CreatedAt

datetime

8

False

When the document was created.

Flags

int

4

False

Freely usable flags for the processing status of the document.

BatchID

bigint

8

False

The ID of the root document (ID in W_Document).

BatchSiteId

int

4

False

Currently not used.

OriginalParent

nvarchar(255)

510

False

When the "Split documents" activity is executed in Extract mode, this column contains the Identifier of the parent document. Needed for merging after splitting documents.

For internal use only.

OriginalDocID

bigint

8

False

When the "Split documents" activity is executed in Split mode, this column contains the Identifier of the document from which the document was copied. Needed for displaying the original document name after a split.

For internal use only.

OriginalDocSiteId

int

4

False

Currently not used.

ProcessedAt

datetime

8

False

When the document was processed. Can be set by applications.

ProcessingTime

float

8

False

The time when the document was processed. Can be set by applications.

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.

FK_W_Document_W_Document

True

ParentID -> W_Document.ID

ParentSiteId -> W_Document.SiteId

FK_W_Document_C_Process

True

ProcessID -> C_Process.ID