Extends data in other tables with attached files, custom properties, etc. Each row is an object, bound to exactly one row in the primary table. Each object can be bound to a row in a different primary table, specified in Entity_Type. Entity: Sys_Objects
Specifies whether the object represented by this system object is deleted. After deletion of the original object, the system object remains in the system, but can be purged later by some cleanup processes.
The Id of the primary row to which the object is bound
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
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Entity_Item_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Entity_Type
The entity type of the row to which the object is bound
Property
Value
Auto Complete
no
Data Filter
no
Default Value
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
yes
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
Medium
User Login
no
Visible
yes
Entity_Type - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
External_Id
The id of the object, when it is imported/synchronized with external system. Used by sync apps to identify the object in external systems.
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
254
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
yes
Summary Type
None
Supports EQUALS_IN
yes
Type
nvarchar(254) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
External_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
External_System
The name of the external system from which the object is imported/synchronized.
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
yes
Type
nvarchar(64) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
External_System - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Is_Deleted
Specifies whether the object represented by this system object is deleted. After deletion of the original object, the system object remains in the system, but can be purged later by some cleanup processes.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
False
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
Is_Deleted - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Last_Update_Time_Utc
The exact server time (in UTC) of the last modification of the object represented by this system object. NULL means that it is unknown.
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
datetime (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Last_Update_Time_Utc - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
GreaterThanOrLessThan
None
no
no
Last_Update_User_Id
The user, who made the last modification of the object represented by this system object . NULL means that it is unknown.