Defines a template used to create regular visit activities, such as planned maintenence work.
Syntax:
[ DynamicComponentDependency ] ramactivitytemplate RAMActivityTemplateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
id | String(32) | A unique id. | |
ram_activity_type_id | String(32) | The type of this activity template. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
description | String(2000) | A description for this type of activity template. | |
last_visited | Date | The time that this activity was last visited. | |
ram_location_id | String(32) | The location of this activity. | |
ram_modelling_pattern_id | String(32) | The modelling pattern to use for this template. | |
ram_time_pattern_id | String(32) | This determines the frequecy with which the visit should happen. |
ramactivitytemplate RAMActivityTemplate {{SelectName}} { SELECT .. id, .. ram_activity_type_id, -- optional columns .. description, .. last_visited, .. ram_location_id, .. ram_modelling_pattern_id, .. ram_time_pattern_id FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMActivityTemplate.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.