Table Sys_Form_Layouts

Entity

Entity: Systems.Core.FormLayouts

Contains user layouts of the screen forms. Entity: Sys_Form_Layouts

Summary

Name	Type	Description
Access_Key_Id	uniqueidentifier	The security access key which controls the access to the layout view
Application_Name	nvarchar(64)	The application, which consumes the layout.
Category	nvarchar(36)	The object category for which the layout is applied. Object category is usually user-defined and further divides the objects of a given object type.
Form_Layout_Id	uniqueidentifier PK
Form_Name	nvarchar(128)	The form, for which the layout is applied.
Inherit_Form_Layout_Id	uniqueidentifier	Specified when the current layout inherits from another layout
Layout	varbinary	The byte storage of the layout.
Layout_Format	nvarchar(1) Allowed: D, L, U	The format of the data in the Layout column. Values can be: 'U' - uncompressed; 'L' - LZO compressed; 'D' - Deflate compressed.
Layout_Name	nvarchar(64)	The name of a named layout. Standard layouts have empty string names.
Layout_Xml	nvarchar(max)	Layout xml - not used.
Machine_Name	nvarchar(128)	The machine name - not used.
Panel_Name	nvarchar(64)	The visual panel, for which the layout is applied.
Role_Id	uniqueidentifier	The role, for which the layout is applied.
Row_Version	timestamp
User_Name	nvarchar(64)	The user for which the layout is applied. NULL means that the layout is applied for all users.

Columns

Access_Key_Id

The security access key which controls the access to the layout view

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
Referenced Table	Sec_Access_Keys
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Access_Key_Id - Supported Filters

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

Application_Name

The application, which consumes the layout.

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	64
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(64)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Application_Name - Supported Filters

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

Category

The object category for which the layout is applied. Object category is usually user-defined and further divides the objects of a given object type.

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	36
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(36) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Category - Supported Filters

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

Form_Layout_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

Form_Layout_Id - Supported Filters

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

Form_Name

The form, for which the layout is applied.

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	128
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(128)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Form_Name - Supported Filters

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

Inherit_Form_Layout_Id

Specified when the current layout inherits from another layout

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
Referenced Table	Sys_Form_Layouts
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Inherit_Form_Layout_Id - Supported Filters

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

Layout

The byte storage of the layout.

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	varbinary (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Layout_Format

The format of the data in the Layout column. Values can be: 'U' - uncompressed; 'L' - LZO compressed; 'D' - Deflate compressed.

Property	Value
Allowed Values	D, L, U
Auto Complete	no
Data Filter	no
Default Value	U
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	100
User Login	no
Visible	yes

Layout_Name

The name of a named layout. Standard layouts have empty string names.

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	64
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(64)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Layout_Name - Supported Filters

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

Layout_Xml

Layout xml - not used.

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	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) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Machine_Name

The machine name - not used.

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	128
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(128) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Machine_Name - Supported Filters

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

Panel_Name

The visual panel, for which the layout is applied.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	Form
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	64
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(64)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Panel_Name - Supported Filters

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

Role_Id

The role, for which the layout is applied.

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
Referenced Table	Wf_Roles
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Role_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	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

User_Name

The user for which the layout is applied. NULL means that the layout is applied for all users.

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	64
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(64) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

User_Name - Supported Filters

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