Table of Contents

Table Srv_Service_Agreement_Services

Entity

Entity: Applications.Service.ServiceAgreementServices

Contains the free services, included in the service agreement. Entity: Srv_Service_Agreement_Services

Owner Tables Hierarchy

Summary

Name Type Description
End_Date datetime End date to which the agreedment for the service or product is valid. For the agreement period, the service could be performed free of charge in service activities.
Line_No int Consecutive line number, unique within the document. Usually is increasing in steps of 10, like in 10, 20, 30, etc.
Quantity decimal(18, 3) Quantity of the agreed servcice or product
Quantity_Unit_Id uniqueidentifier The measurement unit of Quantity.
Row_Version timestamp
Service_Agreement_Id uniqueidentifier
Service_Agreement_Service_Id uniqueidentifier PK
Service_Id uniqueidentifier Paid or agreed in advance service that won't be invoiced after service activities (if Service_Id is filled then Service_Product_Id must be NULL)
Service_Product_Id uniqueidentifier Paid or agreed in advance product that will be substracted from the invoiced products from service activities (if Service_Product_Id is filled then Service_Id must be NULL)
Start_Date datetime Start date from which the agreedment for the service or product is valid. For the agreement period, the service could be performed free of charge in service activities.

Columns

End_Date

End date to which the agreedment for the service or product is valid. For the agreement period, the service could be performed free of charge in service activities.

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

End_Date - Supported Filters

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

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 no
Ignore for Insert Order no
Is Entity Name no
Max Length -1
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 int
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Quantity

Quantity of the agreed servcice or product

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 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 decimal(18, 3)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Quantity_Unit_Id

The measurement unit of Quantity.

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

Quantity_Unit_Id - Supported Filters

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

Service_Agreement_Id - Supported Filters

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

Service_Agreement_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_Agreement_Service_Id - Supported Filters

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

Service_Id

Paid or agreed in advance service that won't be invoiced after service activities (if Service_Id is filled then Service_Product_Id must be 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 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 (Allows NULL)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Service_Id - Supported Filters

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

Service_Product_Id

Paid or agreed in advance product that will be substracted from the invoiced products from service activities (if Service_Product_Id is filled then Service_Id must be 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 3
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 Long
User Login no
Visible yes

Service_Product_Id - Supported Filters

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

Start_Date

Start date from which the agreedment for the service or product is valid. For the agreement period, the service could be performed free of charge in service activities.

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

Start_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no
Suggest improvement to this page