Table of Contents

Table Eam_Maintenance_Types

Entity

Entity: Applications.AssetManagement.MaintenanceTypes

Types of maintenances which can be scheduled and performed on the managed assets. Maintenances can be scheduled based on date and tracked parameter change. Entity: Eam_Maintenance_Types (Introduced in version 19.1)

Summary

Name Type Description
Default_Parameter_Change int Default positive change of the tracked parameter between two maintenances. NULL means, that maintenances are not scheduled based on parameter change.
Default_Schedule_Days int Specifies the maximum number of days between two maintenances (in addition to the number of months specified in Default Schedule Months). NULL means that there is no default schedule in days.
Default_Schedule_Months int Specifies the maximum number of months between two maintenances. NULL means that there is no default schedule in months.
Description nvarchar(max) ML Detailed description of the maintenance (multilanguage).
Maintenance_Type_Code nvarchar(16) Unique code of the maintenance type.
Maintenance_Type_Group_Id uniqueidentifier The group, to which this maintenance type belongs.
Maintenance_Type_Id uniqueidentifier PK
Maintenance_Type_Name nvarchar(254) ML Multilanguage name of the maintenance type.
Row_Version timestamp
Tracked_Parameter_Id uniqueidentifier Specifies the parameter, on which the next scheduled maintenance will be based. NULL means that there is no default schedule, based on parameter.

Columns

Default_Parameter_Change

Default positive change of the tracked parameter between two maintenances. NULL means, that maintenances are not scheduled based on parameter change.

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 int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Default_Schedule_Days

Specifies the maximum number of days between two maintenances (in addition to the number of months specified in Default Schedule Months). NULL means that there is no default schedule in days.

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 int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Default_Schedule_Months

Specifies the maximum number of months between two maintenances. NULL means that there is no default schedule in months.

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 int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Description

Detailed description of the maintenance (multilanguage).

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 2147483647
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(max) (MultiLanguage) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Maintenance_Type_Code

Unique code of the maintenance type.

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 16
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN no
Type nvarchar(16)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Maintenance_Type_Code - Supported Filters

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

Maintenance_Type_Group_Id

The group, to which this maintenance type belongs.

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

Maintenance_Type_Group_Id - Supported Filters

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

Maintenance_Type_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

Maintenance_Type_Id - Supported Filters

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

Maintenance_Type_Name

Multilanguage name of the maintenance type.

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

Maintenance_Type_Name - Supported Filters

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

Tracked_Parameter_Id

Specifies the parameter, on which the next scheduled maintenance will be based. NULL means that there is no default schedule, based on parameter.

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

Tracked_Parameter_Id - Supported Filters

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