ramacttempusageperiod

Defines the expected usage against this activity template of the specified class and between the specified dates.

Syntax:

[ DynamicComponentDependency ] ramacttempusageperiod RAMActTempUsagePeriodName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_activity_template_id String(32) The identifier of the activity template.
ram_usage_class_id String(32) The identifier for the class of usage.
start_date Date The date from which this usage level applies.
end_date Date The date until which this usage level applies.
usage_per_day Double The usage per day during this period. 


            ramacttempusageperiod RAMActTempUsagePeriod {{SelectName}} {
               SELECT
                     ..                  ram_activity_template_id,
                     ..                  ram_usage_class_id,
                     ..                  start_date,
                     ..                  end_date,
                     ..                  usage_per_day
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMActTempUsagePeriodName

Syntax:

<Identifier>

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