Table Srv_Service_Objects
Entity
Entity: Applications.Service.ServiceObjects
Contains the serviceable objects. The service objects can be covered by service agreements, serviced in service activities, etc. Entity: Srv_Service_Objects
Summary
Name |
Type |
Description |
Enterprise_Company_Id |
uniqueidentifier |
|
Is_Active |
bit |
Indicates whether the current service object is active. |
Managed_Asset_Id |
uniqueidentifier |
Link to a managed asset definition from the asset management module. It is used to manage, track and maintain the asset. |
Notes |
nvarchar(254) |
|
Product_Id |
uniqueidentifier |
When not-NULL identifies the product, from which the service object was created |
Row_Version |
timestamp |
|
Serial_Number |
nvarchar(32) |
The serial number of the item, that is being serviced. |
Serial_Number_Id |
uniqueidentifier |
Serial number for the product, that corresponds to this service object. If there is no product, then the other field for 'Serial number' is used to specify this data. |
Service_Object_Id |
uniqueidentifier PK |
|
Service_Object_Name |
nvarchar(254) |
|
Service_Object_Type_Id |
uniqueidentifier |
When not NULL specifies the type of the service object |
Serviced_Product_Id |
uniqueidentifier |
The product, which is used to physically store the service object, when it is serviced. Need to be specified, only when it is different from Product; otherwise, it is null. |
Columns
Enterprise_Company_Id
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
6 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Enterprise_Companies |
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 |
no |
Enterprise_Company_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Is_Active
Indicates whether the current service object is active.
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 |
10 |
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_Active - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
True |
no |
no |
Managed_Asset_Id
Link to a managed asset definition from the asset management module. It is used to manage, track and maintain the asset.
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 |
11 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Eam_Managed_Assets |
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 |
Managed_Asset_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Notes
Property |
Value |
Attributes |
IsLongString |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
254 |
Order |
5 |
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(254) (Allows NULL) |
UI Memo Editor |
no |
UI Width |
100 |
User Login |
no |
Visible |
yes |
Product_Id
When not-NULL identifies the product, from which the service object was created
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
4 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Products |
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 |
yes |
Product_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 |
9 |
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 |
Serial_Number
The serial number of the item, that is being serviced.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
32 |
Order |
2 |
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(32) (Allows NULL) |
UI Memo Editor |
no |
UI Width |
70 |
User Login |
no |
Visible |
yes |
Serial_Number - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Like |
None |
no |
no |
Serial_Number_Id
Serial number for the product, that corresponds to this service object. If there is no product, then the other field for 'Serial number' is used to specify this data.
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 |
7 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Inv_Serial_Numbers |
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 |
Serial_Number_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Service_Object_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 |
0 |
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 |
Service_Object_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Service_Object_Name
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 |
1 |
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(254) |
UI Memo Editor |
no |
UI Width |
600 |
User Login |
no |
Visible |
yes |
Service_Object_Name - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
yes |
Like |
None |
no |
no |
Service_Object_Type_Id
When not NULL specifies the type of the service object
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
3 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Srv_Service_Object_Types |
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 |
yes |
Service_Object_Type_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Serviced_Product_Id
The product, which is used to physically store the service object, when it is serviced. Need to be specified, only when it is different from Product; otherwise, it 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 |
-1 |
Order |
8 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Products |
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 |
Serviced_Product_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |