Table of Contents

Table Sys_Translations

Entity

Entity: Systems.Config.Translations

Contains user-defined translations for non-english languages of the user interface and program messages. Entity: Sys_Translations

Summary

Name Type Description
Active bit True when the translation is verified and activated.
Application_Name nvarchar(50) The application, containing the resource. For base resource types (T,C,H), this is NULL
Creation_Time datetime Readonly Timestamp when the translation was first created
Language nvarchar(8) The code of the language by the ISO639-1 two letter language coding: "en"=English, "bg"=Bulgarian.
Resource_Id nvarchar(800) The unique identifier of the translated resource. Should use ASCII/English chars only. Shorter strings are suggested. Depending on Text_Type: T:TableName; C:ColumnName; H:TableName.ColumnName; E,M,S: Application specific code
Resource_Type nvarchar(1) Allowed: T, C, H, R, E, M, S T=Table (entity) Name; C=Column Name; H=Column Hint; R=Meta Resource; E=Error; M=Message; S=Other application specific String
Row_Version timestamp
Translation nvarchar(max) The translated text
Translation_Id uniqueidentifier PK
Update_Time datetime Readonly When the translation was last updated

Columns

Active

True when the translation is verified and activated.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Active - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Application_Name

The application, containing the resource. For base resource types (T,C,H), this is NULL

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 50
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN no
Type nvarchar(50) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Application_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Creation_Time

Timestamp when the translation was first created

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTime
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Creation_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no yes

Language

The code of the language by the ISO639-1 two letter language coding: "en"=English, "bg"=Bulgarian.

Property Value
Auto Complete no
Data Filter no
Default Value en
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 8
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(8)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Language - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Resource_Id

The unique identifier of the translated resource. Should use ASCII/English chars only. Shorter strings are suggested. Depending on Text_Type: T:TableName; C:ColumnName; H:TableName.ColumnName; E,M,S: Application specific code

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 800
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(800)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Like None no no

Resource_Type

T=Table (entity) Name; C=Column Name; H=Column Hint; R=Meta Resource; E=Error; M=Message; S=Other application specific String

Property Value
Allowed Values T, C, H, R, E, M, S
Auto Complete no
Data Filter no
Default Value S
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(1)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Type - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Translation

The translated text

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Translation_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Translation_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Update_Time

When the translation was last updated

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTime
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Update_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None yes yes
Suggest improvement to this page