Navigation: Schema: Invantive > Tables

SYSTEMTABLES: Data Dictionary Tables

Tables, function tables and views per active data container.

Catalog: DataDictionary

Schema: Invantive

Alias: tbe

Label: Tables

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL 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 SYSTEMTABLES are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
CACHE_RESULT	boolean	Cache Result	☐	Whether the result of the execution can be cached for the lifetime of the statement.
CALL_SAFE_NAME	string	Call Safe Name		Name for use within SQL with special characters escaped.
CAN_DELETE	boolean	Can Delete		Indicator whether you can delete data in this table.
CAN_INSERT	boolean	Can Insert		Indicator whether you can insert data in this table.
CAN_SELECT	boolean	Can Select		Indicator whether you can select data in this table.
CAN_UPDATE	boolean	Can Update		Indicator whether you can update data in this table.
CATALOG	string	Catalog		Catalog where the tables are contained in.
CLIENT_SIDE_CACHEABLE	boolean	Client-Side Cacheable		Are the contents eligible for caching on the client?
CREATION_DATE_UTC	datetime	Creation Date		Date at which the table was originally created (UTC).
DESCRIPTION	string	Description		Description of the contents.
DOCUMENTATION	string	Documentation		Documentation.
EDI_CLASS_NAME	string(240)	EDI Class Name	☐	EDI: master class name.
EDI_PATH_FROM_MASTER	string(240)	EDI Path from Master	☐	EDI: path from the master instance.
ESTIMATED_NUMBER_OF_ROWS	int64	Estimated Number of Rows		Estimated number of rows in this table per partition.
ESTIMATED_SIZE_BYTES	int64	Estimated Size in Bytes		Estimated size in bytes of this table per partition.
EXAMPLE	string	Example		Example of the contents.
FULL_QUALIFIED_NAME	string	Full Qualified Name		Fully qualified name.
FULL_SCAN_ROWS	int64	Full Scan (rows)		Number of full scans row processed.
FULL_SCANS_ELAPSED_TIME_MS	int64	Full Scans Elapsed Time (ms)		Time elapsed during full scans (ms).
FULL_SCANS_EXECUTED	int32	Full Scans Executed		Number of full scans executed.
ID	int32	ID		Unique ID of the table.
IS_PARTITION_SPECIFIC	boolean	Is Partition Specific		Indicator whether the contents of this table typically differ per partition.
LABEL_LIST_I18N	string	Translated Label List		Translated label of the table for use in lists.
LABEL_LIST	string	Label for List		Label of the table for use in lists.
LABEL_PLURAL_I18N	string	Translated Label Plural		Label of the table contents in plural form.
LABEL_PLURAL	string	Label Plural		Label of the table contents in plural form.
LABEL_SINGULAR_I18N	string	Translated Label Singular		Translated label of the table contents in singular form.
LABEL_SINGULAR	string	Label Singular		Label of the table contents in singular form.
LAST_UPDATE_DATE_UTC	datetime	Last Update Date		Date at which the table's structure was last modified (UTC).
MEASURED_AVERAGE_ACCESS_LATENCY_MS	int64	Measured Average Access Latency (ms)		Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.
MEASURED_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE	int32	Measured Average Number Full Scan Row per Minute		Measured average number of rows that fetched per minute on a full table scan.
MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE	int32	Measured Average Number Point Query Rows per Minute		Measured average number of rows processed per minute on point queries.
MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE	int32	Measured Average Number Rows Written per Minute		Measured average number of rows written per minute.
NAME	string	Name		Name of the table or view.
ODATA_BASE_PATH	string(240)	OData Base Path	☐	OData: base path.
ODATA_FIELD_SELECTION_METHOD	string(240)	OData Field Selection Method	☐	OData: field selection method.
ODATA_METADATA_URL	string(4000)	OData Metadata URL	☐	OData: URL for retrieving metadata.
ODATA_SERVER_SIDE_FILTERS	string	OData Server-side Filters	☐	OData: text representation of server-side filters.
ODATA_SERVICE_URL_FOR_DELETE	string(4000)	OData Service URL for Delete	☐	OData: service URL for deleting data.
ODATA_SERVICE_URL_FOR_INSERT	string(4000)	OData Service URL for Insert	☐	OData: service URL for inserting data.
ODATA_SERVICE_URL_FOR_SELECT	string(4000)	OData Service URL for Select	☐	OData: service URL for retrieving data.
ODATA_SERVICE_URL_FOR_UPDATE	string(4000)	OData Service URL for Update	☐	OData: service URL for updating data.
POINT_QUERIES_ELAPSED_TIME_MS	int64	Time Spent in Point Queries (ms)		Time elapsed during point queries (ms).
POINT_QUERIES_EXECUTED	int32	Rows through Point Queries		Number of point queries executed.
PRIMARY_KEY_FIELD	string(4000)	Primary Key Columns		Primary key column(s) of the table.
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.
SCHEMA	string	Schema		Schema within the catalog where the table is contained in.
SHORT_NAME	string	Short Name		Typical alias for the table.
SOAP_ACTION	string(240)	SOAP Action	☐	SOAP: action.
STATIC_AVERAGE_ACCESS_LATENCY_MS	int64	Static Average Access Latency (ms)		Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.
STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE	int32	Static Average Rows per Minute on Full Scan		Average number of rows that fetched per minute on a full table scan, statically configured.
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE	int32	Static Average Rows per Minute on Point Query		Average number of rows processed per minute on point queries, statically configured.
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE	int32	Static Average Rows per Minute Written		Average number of rows written per minute, statically configured.
SWAGGER_CONTENT_TYPE	string(240)	Swagger Content Type	☐	SWAGGER: content type.
SWAGGER_DELETE_OPERATION	string(240)	Swagger Delete Operation	☐	SWAGGER: delete operation.
SWAGGER_INSERT_OPERATION	string(240)	Swagger Insert Operation	☐	SWAGGER: insert operation.
SWAGGER_PRE_MAPPING_TABLE_NAME	string(240)	Swagger Pre Mapping Table Name	☐	SWAGGER: pre-mapping table name.
SWAGGER_RESPONSE_SCHEMA	string(240)	Swagger Response Schema	☐	SWAGGER: response schema.
SWAGGER_SELECT_OPERATION	string(240)	Swagger Select Operation	☐	SWAGGER: select operation.
SWAGGER_UPDATE_OPERATION	string(240)	Swagger Update Operation	☐	SWAGGER: update operation.
TABLE_PARAMETERS	string(4000)	Parameters		Parameters defined on the table.
TYPE	string	Type		Type, can be either 'view' or 'table'.
VALID	boolean	Valid		Whether the structure of the table is valid.
WEBHOOK_KEY_FIELD	string(4000)	Webhook Key Column	☐	Key column on webhook messages.
WEBHOOK_TOPIC	string(4000)	Topic	☐	Webhook topic.
WRITE_ELAPSED_TIME_MS	int64	Elapsed Write Time (ms)		Time elapsed during point queries (ms).
WRITES_EXECUTED	int32	Writes Executed		Number of writes executed.
WRITTEN_ROWS	int64	Rows Written		Number of rows written.
XML_BASE_XPATH	string(240)	Base XPath	☐	XML: XPath expression which forms the root containing all rows.
XML_DEFAULT_NAMESPACE_PREFIX	string(240)	Default Namespace Prefix	☐	XML: default namespace prefix.
XML_NAMED_COMPLEX_TYPE	string(240)	Named Complex Type	☐	XML: name of the complex type.
XML_SERVER_SIDE_FILTERS	string	Server-side Filters	☐	XML: text representation of server-side filters.
XML_SERVICE_URL	string(240)	Service URL	☐	XML: Service URL.
XML_TOPIC	string(240)	Topic	☐	XML: topic or action as known on the remote server. Defaults to Name when not set.
XML_XPATH	string(240)	XPath	☐	XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath.

28-07-2024 17:46 Version 24.1.6-BETA+4856

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Data Dictionary Data Model Data Dictionary Forums

SYSTEMTABLES: Data Dictionary Tables

View Columns

Important Safety and Usage Information