Table of Contents

Table Srv_Service_Activity_Services

Entity

Entity: Applications.Service.ServiceActivityServices

Contains the services, which were actually performed during the service activity (repair). Entity: Srv_Service_Activity_Services

Owner Tables Hierarchy

Summary

Name Type Description
Covered_By_Guarantee bit True when the performed service is covered by the guarantee.
Line_No int Consecutive line number, unique within the document. Usually is increasing in steps of 10, like in 10, 20, 30, etc.
Notes nvarchar(254) Short notes for the service
Performed_By_Person_Id uniqueidentifier The id of the person from the enterprise company that actually performed the work
Quantity decimal(9, 2) The quantity of the service in the measurement unit of the service
Row_Version timestamp
Service_Activity_Id uniqueidentifier
Service_Activity_Service_Id uniqueidentifier PK
Service_Id uniqueidentifier The type of service that is conducted
Service_Name nvarchar(254) Description of the conducted service. The description may vary (contain additional information) from the standart name of the service.
Service_Object_Id uniqueidentifier The service object that was serviced. NULL means that it is unknown or N/A

Columns

Covered_By_Guarantee

True when the performed service is covered by the guarantee.

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop no
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 Short
User Login no
Visible yes

Line_No

Consecutive line number, unique within the document. Usually is increasing in steps of 10, like in 10, 20, 30, etc.

Property Value
Auto Complete no
Autoincrement 10
Data Filter no
Default Value None
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 no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Notes

Short notes for the service

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 254
Order 4
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

Performed_By_Person_Id

The id of the person from the enterprise company that actually performed the work

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 6
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Cm_Persons
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

Performed_By_Person_Id - Supported Filters

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

Quantity

The quantity of the service in the measurement unit of the service

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

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

Service_Activity_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 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Srv_Service_Activities
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Service_Activity_Id - Supported Filters

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

Service_Activity_Service_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

Service_Activity_Service_Id - Supported Filters

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

Service_Id

The type of service that is conducted

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 2
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Srv_Services
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Service_Id - Supported Filters

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

Service_Name

Description of the conducted service. The description may vary (contain additional information) from the standart name of the service.

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 254
Order 3
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 Long
User Login no
Visible yes

Service_Name - Supported Filters

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

Service_Object_Id

The service object that was serviced. NULL means that it is unknown or N/A

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 Srv_Service_Objects
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_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
Suggest improvement to this page