Table Sys_Translations
Entity
Entity: Systems.Core.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 or language-culture pair. Standard Windows codes are used. English="en"; US English = "en-us" |
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 or language-culture pair. Standard Windows codes are used. English="en"; US English = "en-us"
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 |