ramslatemplateitem

An item within an SLA Template.

Syntax:

[ DynamicComponentDependency ] ramslatemplateitem RAMSLATemplateItemName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
deadline Number (minutes by default) The period from the open time of the activity to the end of this SLA period.
ram_sla_template_id String(32) The id of the template.

Optional columns

Column Name Data Type Description Default Value
ram_sla_type_id String(32) The SLA Type to use for this period. 


            ramslatemplateitem RAMSLATemplateItem {{SelectName}} {
               SELECT
                     ..                  deadline,
                     ..                  ram_sla_template_id,
                  -- optional columns
                     ..                  ram_sla_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling RAMSLATemplateItem.

RAMSLATemplateItemName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.