Tables are often used in documents such as invoices that contain tables in which position, quantity, article number and price are processed. A table definition belongs to a document type.
Column | Data type | Max. length (bytes) | Allow nulls | Description |
ID | int | 4 | False | Unique identifier of the table definition. |
Rev | int | 4 | False | Revision number. For internal use. |
DocTypeID | int | 4 | False | The ID of the related document type (ID in C_DocType). |
Name | nvarchar(255) | 510 | False | The name of the table. |
Identifier | nvarchar(255) | 510 | False | The unique identifier of the table definition. |
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_C_TableDef_C_DocType | DocTypeID -> C_DocType.ID |