Table of Contents

Table Srv_Service_Agreement_Materials

Entity

Entity: Applications.Service.ServiceAgreementMaterials

Contains the free materials, included in the service agreement. Entity: Srv_Service_Agreement_Materials

Owner Tables Hierarchy

Summary

Name Type Description
End_Date datetime End date to which the agreedment for the material is valid. For the agreement period, the material could be used 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.
Product_Id uniqueidentifier Paid or agreed in advance material that won't be invoiced after service activities
Quantity decimal(18, 3) Quantity of the agreed material
Quantity_Base decimal(18, 3) Readonly The equivalence of Quantity in the base measurement category of the product.
Quantity_Unit_Id uniqueidentifier The measurement unit of Quantity.
Row_Version timestamp
Service_Agreement_Id uniqueidentifier
Service_Agreement_Material_Id uniqueidentifier PK
Standard_Quantity_Base decimal(18, 3) Readonly The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution.
Start_Date datetime Start date from which the agreedment for the material is valid. For the agreement period, the material could be used free of charge in service activities.

Columns

End_Date

End date to which the agreedment for the material is valid. For the agreement period, the material could be used 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 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 datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

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

Product_Id

Paid or agreed in advance material that won't be invoiced after service activities

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 1
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
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Product_Id - Supported Filters

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

Quantity

Quantity of the agreed material

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

The equivalence of Quantity in the base measurement category of the 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 8
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(18, 3)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

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

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 7
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_Material_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 6
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_Material_Id - Supported Filters

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

Standard_Quantity_Base

The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution.

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 10
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(18, 3)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Start_Date

Start date from which the agreedment for the material is valid. For the agreement period, the material could be used 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 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 datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Start_Date - Supported Filters

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