Navigation: Catalog: Knack > Schemas > Schema: DataDictionary > Tables

Applications: Knack Applications

Catalog: Knack

Schema: DataDictionary

Primary Keys: id

Label: Applications

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

Table Columns

The columns of the table Applications are shown below. Each column has an SQL data type.

Name	Data Type	Required	Documentation
account_beta_deadline	varchar2	☐
account_billing_customer_id	varchar2	☐
account_billing_notice_date	varchar2	☐
account_billing_status	varchar2	☐
account_clientid	varchar2	☐
account_gclid	varchar2	☐
account_id	varchar2	☐
account_name	varchar2	☐
account_plan_limits_storage	int64	☐
account_plan_limits_transactions	int64	☐
account_product_plan_ai_credit_limit_monthly	int64	☐
account_product_plan_api_limit	int64	☐
account_product_plan_apps	int64	☐
account_product_plan_babu_unit	varchar2	☐
account_product_plan_freeze_cost	int64	☐
account_product_plan_frequency	varchar2	☐
account_product_plan_id	varchar2	☐
account_product_plan_name	varchar2	☐
account_product_plan_price	int64	☐
account_product_plan_records	int64	☐
account_product_plan_storage	varchar2	☐
account_product_plan_subscription_id	varchar2	☐
account_product_plan_transactions_amount	int64	☐
account_product_plan_transactions_plan_id_prod	int64	☐
account_product_plan_transactions_plan_id_test	int64	☐
account_product_plan_type	varchar2	☐
account_referral	varchar2	☐
account_session_user_account_id	varchar2	☐
account_session_user_created_on	datetime	☐
account_session_user_email	varchar2	☐
account_session_user_first_name	varchar2	☐
account_session_user_id	varchar2	☐
account_session_user_last_name	varchar2	☐
account_session_user_utility_key	varchar2	☐
account_settings_builder_default_version	varchar2	☐
account_settings_flows_language	varchar2	☐
account_settings_flows_timezone	varchar2	☐
account_settings_region	varchar2	☐
account_slug	varchar2	☐
account_user_id	varchar2	☐
asset_size	int64	☐
count_A_B_C	int64	☐
count_Accounts	int64	☐
count_CompaniesExpanded	int64	☐
count_ContactsExpanded	int64	☐
count_DateTest	int64	☐
count_Journals	int64	☐
count_OrdersObject	int64	☐
count_ProductsExpanded	int64	☐
count_TestcaseIUDExpanded	int64	☐
count_TestExpanded	int64	☐
count_testpho	int64	☐
description	varchar2	☐
design_general_buttons_bg_color	varchar2	☐
design_general_buttons_color	varchar2	☐
design_general_font	varchar2	☐
design_general_links_color	varchar2	☐
design_general_menus_links_buttons_borderThickness	varchar2	☐
design_general_menus_links_buttons_colors_fill_border_color	varchar2	☐
design_general_menus_links_buttons_colors_outline_text_color	varchar2	☐
design_general_menus_links_buttons_format	varchar2	☐
design_general_tables_spacing	varchar2	☐
design_general_tables_style	varchar2	☐
design_general_views_links_delete_colors_button_color	varchar2	☐
design_general_views_links_delete_colors_text_color	varchar2	☐
design_general_views_links_page_icon_align	varchar2	☐
design_regions_header_layout_menuPosition	varchar2	☐
design_regions_header_legacy_settings_title_logo_filename	varchar2	☐
design_regions_header_legacy_settings_title_logo_height	int16	☐
design_regions_header_legacy_settings_title_logo_size	int64	☐
design_regions_header_legacy_settings_title_logo_url	varchar2	☐
design_regions_header_legacy_settings_title_logo_width	int16	☐
design_regions_header_logo_icon_icon	varchar2	☐
design_regions_header_logo_image_height	int16	☐
design_regions_header_logo_image_size	int64	☐
design_regions_header_logo_image_url	varchar2	☐
design_regions_header_logo_image_width_pct	int64	☐
design_regions_header_logo_image_width	int16	☐
design_regions_header_menu_dropdown_menu_links_background_active_color_style	varchar2	☐
design_regions_header_menu_dropdown_menu_links_background_active_color	varchar2	☐
design_regions_header_menu_dropdown_menu_links_background_color	varchar2	☐
design_regions_header_menu_dropdown_menu_links_text_active_colorStyle	varchar2	☐
design_regions_header_menu_dropdown_menu_links_text_color	varchar2	☐
design_regions_header_menu_format	varchar2	☐
design_regions_header_menu_links_buttons_size	varchar2	☐
design_regions_header_menu_links_tabs_colors_background_active_color	varchar2	☐
design_regions_header_menu_links_text_activeStyle	varchar2	☐
design_regions_header_menu_links_text_colors_color	varchar2	☐
design_regions_header_menu_mobile_menu_links_background_active_colorStyle	varchar2	☐
design_regions_header_menu_mobile_menu_links_background_color	varchar2	☐
design_regions_header_title_text	varchar2	☐
ecommerce_enabled	char	☐
HERE_appCode	varchar2	☐
HERE_appId	varchar2	☐
home_scene_key	varchar2	☐
home_scene_slug	varchar2	☐
id	varchar2	☑	Unique ID.
layout_app_fullwidth	char	☐
layout_app_menu_auth	char	☐
layout_entry_scene_menu	char	☐
layout_page_menu_style	varchar2	☐
layout_theme	varchar2	☐
logo_url	varchar2	☐
name	varchar2	☑
s3_application_cdn_domain	varchar2	☐
s3_bucket	varchar2	☐
s3_domain	varchar2	☐
s3_secure_bucket	varchar2	☐
s3_secure_domain	varchar2	☐
settings_babu_preseed_status	varchar2	☐
settings_embed_login_method	varchar2	☐
settings_from_email	varchar2	☐
settings_inactivity_timeout	int64	☐
settings_last_update	varchar2	☐
settings_logo	varchar2	☐
settings_runner	varchar2	☐
settings_sql	varchar2	☐
settings_technical_contact	varchar2	☐
settings_timezone_dst	int64	☐
settings_timezone_offset	int64	☐
slug	varchar2	☐
status	varchar2	☐
subdomain	varchar2	☐
total_entries	int64	☐
users_enabled	char	☐
users_registration	varchar2	☐
users_scope	varchar2	☐
users_templates_all_users_info	varchar2	☐
users_templates_profile_15_info	varchar2	☐

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.

Knack API Data Model

Applications: Knack Applications

Table Columns

Important Safety and Usage Information