Table of Contents

Table Srv_Service_Activities

Entity

Entity: Applications.Service.ServiceActivities

Contains service activity headers. The service activities are the actual actions performed to service (repair) an object. Entity: Srv_Service_Activities

Owner Tables Hierarchy

Summary

Name Type Description
Activity_Id uniqueidentifier The base activity of the service activity. The activity contains the time frames, reminders, etc.
Credit_Limit_Override bit Specifies a value, which would be provided to SalesOrder.CreditLimitOverride, when generating SalesOrder.
Customer_Id uniqueidentifier The receiver of the work
Default_Service_Object_Id uniqueidentifier Default service object for materials and services lines
Location_Party_Contact_Mechanism_Id uniqueidentifier The location where or the communication line used to conduct the work
Receiver_Person_Id uniqueidentifier The id of the person from the customers company, that received and signed for the service
Receiver_Person_Name nvarchar(254) ML Copy of the name of the receiver at the time the activity was signed
Row_Version timestamp
Service_Activity_Id uniqueidentifier PK
Service_Agreement_Id uniqueidentifier The service agreement under which the work was done
Ship_To_Customer_Id uniqueidentifier Specific customer location of the main customer that receives the work.
Store_Id uniqueidentifier The default store from which materials are taken

Columns

Activity_Id

The base activity of the service activity. The activity contains the time frames, reminders, etc.

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 yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Cm_Activities
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

Activity_Id - Supported Filters

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

Credit_Limit_Override

Specifies a value, which would be provided to SalesOrder.CreditLimitOverride, when generating SalesOrder.

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

Credit_Limit_Override - Supported Filters

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

Customer_Id

The receiver of 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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Crm_Customers
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

Customer_Id - Supported Filters

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

Default_Service_Object_Id

Default service object for materials and services lines

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

Default_Service_Object_Id - Supported Filters

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

Location_Party_Contact_Mechanism_Id

The location where or the communication line used to conduct 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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Cm_Party_Contact_Mechanisms
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

Location_Party_Contact_Mechanism_Id - Supported Filters

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

Receiver_Person_Id

The id of the person from the customers company, that received and signed for the service

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 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

Receiver_Person_Id - Supported Filters

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

Receiver_Person_Name

Copy of the name of the receiver at the time the activity was signed

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 no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254) (MultiLanguage) (Allows NULL)
UI Memo Editor no
UI Width 100
User Login no
Visible yes

Receiver_Person_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Like None 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

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

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

Service_Agreement_Id

The service agreement under which the work was done

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_Agreements
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_Agreement_Id - Supported Filters

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

Ship_To_Customer_Id

Specific customer location of the main customer that receives 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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Crm_Customers
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

Ship_To_Customer_Id - Supported Filters

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

Store_Id

The default store from which materials are taken

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 Inv_Stores
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

Store_Id - Supported Filters

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