Table: W_TableCell

ID

bigint

8

False

The ID of the table cell.

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.

ParentRowID

bigint

8

False

The ID of the related table row (ID in W_TableRow).

ParentRowSiteId

int

4

False

Currently not used.

Name

nvarchar(255)

510

False

The name of the cell.

Type

int

4

False

The data type of the field. Possible values:

0 = string
1 = integer
2 = float
3 = datetime

VarcharValue

nvarchar(255)

510

False

Field value when Type=0 (string).

IntValue

int

4

False

Field value when Type=1 (integer).

FloatValue

float

8

False

Field value when Type=2 (float).

DatetimeValue

datetime

8

False

Field value when Type=3 (datetime).

Item

int

4

False

The sequence number of the cell definition.

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).

BatchID

bigint

8

False

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

BatchSiteId

int

4

False

Currently not used.

Identifier

nvarchar(255)

510

False

The unique identifier of the table cell definition.

BinaryValue

varbinary(max)

max

False

The value of VarcharValue in binary form. Only filled in when VarcharValue > 255.

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_TableCell_W_TableRow

ParentRowID -> W_TableRow.ID

ParentRowSiteId -> W_TableRow.SiteId