SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

CAN_FILTER_SERVER_SIDE

boolean

Can Filter Server-side

☑

Whether the column can be filtered on server-side.

CHECK_SPELLING

boolean

Check Spelling

☑

Whether the column's value should preferably be checked for spelling and grammar errors in a user interface.

CLIENT_SIDE_CACHEABLE

boolean

Table Client-Side Cacheable

Are the contents eligible for caching on the client?

DATABASE_DATA_TYPE

string(240)

Database Data Type

Data type in the database.

DERIVED_VALUE

boolean

Derived Value

☑

Whether the column contains a derived value (calculated using an expression).

DISPLAY_CONTROL

string(240)

Display Control

☐

Display control for displaying the column's contents.

DISPLAY_IN_FILTER

boolean

Display in Filter

☑

Whether the column should be included in a search window.

DISPLAY_IN_LOV

boolean

Display in LOV

☑

Whether the column should be included in a pick list.

DISPLAY_IN_RECORD

boolean

Display in Record

☑

Whether the column should be included in a single record view.

DISPLAY_IN_RESULTS

boolean

Display in Results

☑

Whether the column should be included in a multiple records view.

DISPLAY_LENGTH_AVERAGE

int32

Display Length (Average)

☐

Average length in characters of the contents of the column.

DISPLAY_LENGTH_SD

int32

Display Length (SD)

☐

Standard deviation in characters of the contents of the column.

DISPLAY_ORDER

int32

Display Order

☐

Relative position in which the column should be displayed compared to other columns.

DOCUMENTATION

string(4000)

Documentation

☐

Documentation.

DOTNET_DATA_TYPE

string(240)

.NET Data Type

Data type for .NET.

EXAMPLE

string(4000)

Example

☐

Example.

FETCH_BY_DEFAULT

boolean

Fetch by Default

☑

Whether this field is fetched by default. True if the column is fetched by default, or false if it is being fetched when accessed.

ID

int32

ID

Unique ID of the column.

INFLUENCES_INSERT

boolean

Influences Insert

☑

Whether the column's value has an impact on the database's contents.

LABEL_HEADING

string(240)

Label Heading

☐

Optional heading label to be shown before the column's normal label.

LABEL_PLURAL_COMPOSED

string(4000)

Label Plural Composed

☐

Translatable label composed of the prefix and the plural label.

LABEL_PLURAL_POSTFIX

string(240)

Label Plural Postfix

☐

Translatable label postfix in plural.

LABEL_PLURAL_PREFIX

string(240)

Label Plural Prefix

☐

Translatable label prefix in plural.

LABEL_PLURAL

string(4000)

Label Plural

☐

Translatable label in plural.

LABEL_SINGULAR_COMPOSED

string(4000)

Label Singular Composed

☐

Translatable label composed of the prefix and the singular label.

LABEL_SINGULAR_I18N

string(4000)

Translated Label Singular

Translated human-readable label in singular form.

LABEL_SINGULAR_POSTFIX

string(240)

Label Singular Postfix

☐

Translatable label postfix in singular.

LABEL_SINGULAR_PREFIX

string(240)

Label Singular Prefix

☐

Translatable label prefix in singular.

LABEL_SINGULAR

string(4000)

Label Singular

Human-readable label in singular form.

MAX_LENGTH

int32

Maximum Length

Maximum length.

MINIMUM_LENGTH_PADDING

string(240)

Minimum Length Padding

☑

Which side padding has to be applied if the minimum length is not met.

MINIMUM_LENGTH

int32

Minimum Length

☑

Minimum required length for a text field.

MOST_UNQUALIFIED_NAME

string(240)

Most Unqualified Name

☑

The most unique name ('users' for 'exactonline.crm.users')

NAME

string(240)

Name

Name of the column.

NULLABLE

boolean

Nullable

Whether the value is optional.

POSITION

int32

Position

☑

Numeric ID of the column.

PRECISION

int16

Precision

Precision.

PROVIDER_DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

☐

Data container alias.

PROVIDER_DATA_CONTAINER_ID

string(4000)

Data Container ID

☐

Data container ID.

PROVIDER_DESCRIPTION

string(16000)

Provider Description

☑

Provider description.

PROVIDER_INSTANCE_UID

guid

Provider Instance UID

☑

Unique ID of the provider instance.

PROVIDER_NAME

string(240)

Provider Name

☑

Name of the provider.

PROVIDER_SHORT_NAME

string(240)

Provider Short Name

☑

Provider short name.

SCALE

int16

Scale

Scale.

SOURCE_ADDITIONAL_INFO_1

string(4000)

Source Additional Information 1

Additional information, no predefined structure.

SOURCE_ADDITIONAL_INFO_2

string(4000)

Source Additional Information 2

Additional information, no predefined structure.

SOURCE_ADDITIONAL_INFO_3

string(4000)

Source Additional Information 3

Additional information, no predefined structure.

SOURCE_PATH

string(4000)

Source Path

Path of the source of the value.

TABLE_CALL_SAFE_NAME

string(240)

Table Call Safe Name

Name for use within SQL with special characters escaped.

TABLE_CAN_DELETE

boolean

Table Can Delete

Indicator whether you can delete data in this table.

TABLE_CAN_INSERT

boolean

Table Can Insert

Indicator whether you can insert data in this table.

TABLE_CAN_SELECT

boolean

Table Can Select

Indicator whether you can select data in this table.

TABLE_CAN_UPDATE

boolean

Table Can Update

Indicator whether you can update data in this table.

TABLE_CATALOG_NAME

string(240)

Table Catalog

Catalog where the tables are contained in.

TABLE_CREATION_DATE_UTC

datetime

Table Creation Date

Date at which the table was originally created (UTC).

TABLE_DESCRIPTION

string(4000)

Table Description

Description of the contents.

TABLE_DOCUMENTATION

string(4000)

Table Documentation

Documentation of the table or view.

TABLE_ESTIMATED_NUMBER_OF_ROWS

int64

Table Estimated Number of Rows

Estimated number of rows in this table per partition

TABLE_ESTIMATED_SIZE_BYTES

int64

Table Estimated Size in Bytes

Estimated size in bytes of this table per partition.

TABLE_EXAMPLE

string(4000)

Table Example

Example of the contents.

TABLE_FULL_QUALIFIED_NAME

string(240)

Table Full Qualified Name

Full qualified name.

TABLE_FULL_TABLE_SCAN_ROW_RETRIEVAL_TOTAL_CLOCK_TIME_MS

int64

Table Full Table Scan Row Retrieval Total Clock Time (ms)

Total clock time spent retrieving data using full table scans.

TABLE_FULL_TABLE_SCAN_ROWS_RETRIEVED

int64

Table Rows Retrieved during Full Table Scans

Total number of rows retrieved using full table scans.

TABLE_FULL_TABLE_SCANS_EXECUTED

int32

Table Number of Full Table Scans Executed

Total number of full table scans executed.

TABLE_IS_PARTITION_SPECIFIC

boolean

Table Is Partition Specific

Indicator whether the contents of this table typically differ per partition.

TABLE_LABEL_LIST

string(4000)

Table Label for List

Label of the table for use in lists.

TABLE_LABEL_PLURAL

string(4000)

Table Label Plural

Label of the table contents in plural form.

TABLE_LABEL_SINGULAR

string(4000)

Table Label Singular

Label of the table contents in singular form.

TABLE_LAST_UPDATE_DATE_UTC

datetime

Table Last Update Date

Date at which the table's structure was last modified (UTC).

TABLE_MEASURED_AVERAGE_ACCESS_LATENCY_MS

int64

Table Measured Average Access Latency (ms)

Measured Average Access Latency in milliseconds.

TABLE_NAME

string(240)

Table Name

Name of the table or view.

TABLE_PARAMETERS

string(4000)

Parameters

Parameters defined on the table.

TABLE_POINT_QUERIES_EXECUTED_TOTAL_CLOCK_TIME_MS

int64

Table Total Clock Time Spent Executing Point Queries (ms)

Total clock time spent retrieving data using point queries.

TABLE_POINT_QUERIES_EXECUTED

int32

Table Number of Point Queries Executed

Number of point queries executed.

TABLE_PRIMARY_KEY_FIELD

string(4000)

Primary Key Columns

Primary key column(s) of the table.

TABLE_ROWS_WRITE_TOTAL_CLOCK_TIME_MS

int64

Table Total Time Spent Writing Rows (ms)

Total clock time spent writing rows in milliseconds.

TABLE_ROWS_WRITTEN

int64

Table Number of Rows Written

Number of rows written.

TABLE_SCHEMA_NAME

string(240)

Table Schema

Schema within the catalog where the table is contained in.

TABLE_SHORT_NAME

string(240)

Table Short Name

Typical alias for the table.

TABLE_STATIC_AVERAGE_ACCESS_LATENCY_MS

int64

Table Static Average Access Latency (ms)

Statically determined average access latency in milliseconds.

TABLE_STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE

int32

Table Static Average Rows per Minute on Full Scan

Statically determined average number of rows accessible per minute.

TABLE_STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE

int32

Table Static Average Rows per Minute on Point Query

Statically determined average of points queries throughput per minute.

TABLE_STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE

int32

Table Static Average Rows per Minute Written

Statically determined throughput of written rows per minute.

TABLE_TYPE

string(30)

Table Type

Type, can be either 'view' or 'table'.

TABLE_VALID

boolean

Table Valid

Whether the structure of the table is valid.

TABLE_WRITES_EXECUTED

int32

Table Number of Writes

Total number of writes executed.

USER_CHANGEABLE

boolean

User Changeable

☑

Whether the column's value can be changed ever by a human user with sufficient access rights.