Please enable JavaScript to view this site.

Navigation: » No topics above this level «

SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

Columns per table.

Catalog: DataDictionary

Schema: Invantive

Alias: tcn

Label: Table Columns

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

View Columns

The columns of the view SYSTEMTABLECOLUMNS are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

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

int32

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

int32

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

int32

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

int32

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

int32

Table Total Time Spent Writing Rows (ms)

 

Total clock time spent writing rows in milliseconds.

TABLE_ROWS_WRITTEN

int32

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

int32

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.

 

19-03-2022 11:54 Version 22.0.85-PROD+3263